How to get data from external database into servicenow

johannes5
Giga Expert

‎03-01-2017 06:38 PM

Hi ServiceNow Community Developers,

I have a requirement to set up a nightly job to get data from some table outside ServiceNow. The table resides in some database on

some server outside ServiceNow. I need to connect to that server from ServiceNow and bring the data from that table into ServiceNow

and then transform it into a production table in ServiceNow. The question is I have is how do I do that? Do I use JDBC or ODBC?

Please advise.

Thanks,

Johannes

0 Helpfuls
  • 2,441 Views
1 REPLY 1

josh_nerius
ServiceNow Employee
ServiceNow Employee

‎03-01-2017 07:21 PM

Hi Johannes,



What you want is a JDBC type data source. These can be configured to retrieve data from a database and load that data into an import set table for transformation into your desired target table in ServiceNow. You'll most likely need a MID server to facilitate the connection to the database as well.


0 Helpfuls