How to import data from SQL DB to servicenow Custom table

Rameshnathan
Tera Expert

‎08-14-2017 10:47 PM

Hi Friends

I have one custom table with following fields (Name, Number, Address, City) in ServiceNow, Now i want import this details form external table (SQL DB)

can any one help me from scratch how to import the data so its more helpful to me.....

or share me if any video or document with picture

Thanks

Ramesh

Labels:
0 Helpfuls
  • 4,778 Views
3 REPLIES 3

Harsh Vardhan
Giga Patron

‎08-14-2017 11:40 PM

i think you need set your data source as JDBC type in import set.


Please refer the link below.



Data Sources - ServiceNow Wiki


0 Helpfuls

antin_s
ServiceNow Employee
ServiceNow Employee

‎08-14-2017 11:47 PM

Hi Ramesh,



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.



Import Set : Importing Data Using Import Sets - ServiceNow Wiki



Transform map: http://wiki.servicenow.com/index.php?title=Creating_New_Transform_Maps#gsc.tab=0



Thanks


Antin


0 Helpfuls