How to import data from SQL DB to servicenow

[khajaa]

I  want to import  details from an external table (SQL DB) and use that data as inventory in SNOW

can anyone help me please I am new to SNOW

Thanks

[Tejas1018]

repare SQL Database Connection:

Set up a connection to your SQL database in ServiceNow.
Create Import Table:

Make a table in ServiceNow to hold imported data.
Map Fields:

Define how SQL data matches up with ServiceNow fields.
Import Data:

Use a scheduled job or manual import to bring SQL data into ServiceNow.
Verify and Use:

Confirm data is imported correctly and start using it in ServiceNow.
 
 
 
 

[Community Alums]

Hi @khajaa ,

The following steps might help.

1. Export the data from SQL to csv

2. Import the csv into import set table using Import Set UI

3. Run the transform map to move the data from import set table to Business/End tables.

[Tai Vu]

Hi @khajaa 

Have you tried to define a data source JDBC type?

JDBC type data source

Create a JDBC type data source

Cheers,

Tai Vu

[Sohail Khilji]

Hi @khajaa ,

Follow this > 

1. Go to > System import sets > data source , from the filter navigator..

2. Click on new and create a new data source using JDBC as like below example.

(You would need all the info which are updated below in field from the conserned Database team)

3. Save and create a transform map to map the field to your target table. 

4. Transform data to target table...

(I know it will be hard for you go step by step as suggested , let me know were your struck...) happy to help....