Import Data into ServiceNow via ODBC connection

[surendarm]

Hi All,

In ServiceNow, it possible to configure a ODBC connection to an another system by installing their ODBC driver in the MID Server to pull the data into ServiceNow?

If 'Yes' please do let us know how we can establish the connectivity or do we have any other ways to connect through ODBC connection? This will aid us to build the functionality to pull the data into ServiceNow.

Thanks in Advance.

Surendar M

[haseena ayesha]

Hi Surender

Import Set table:  A table that acts as a staging location for records imported from a data source prior to transforming those records. Fields on these tables are generated automatically based on imported data and should not be modified manually.

Data source : A record that defines where to get the data to import. A data source may point to a file, a JDBC-compatible database, or an LDAP organizational unit.

Please go through the below links:

https://docs.servicenow.com/bundle/kingston-platform-administration/page/administer/import-sets/concept/c_ImportSetsKeyConcepts.html

https://docs.servicenow.com/bundle/kingston-platform-administration/page/administer/import-sets/reference/r_JDBCTypeDataSource.html

Thanks & Regards

Haseena

                                                    PS: Hit like, Helpful or Correct depending on the impact of the response                       

[surendarm]

Hi Haseena,

Thank you for your response.

I completely agree with the Import set, but I am not sure about the data source configuration.

We are trying to connect to a database which has been made accessible via ODBC connection. In ServiceNow, we dont have an option to choose 'ODBC' when we configure the data source.

Does the ODBC connection works same as the 'JDBC' type of Data Source in ServiceNow or do we need to configure any additional setups to make ServiceNow to recognize the ODBC connection?

Thanks in advance.

Surendar M

[AndyLock]

Hey Surender,

I'm going to assume you're comfortable with ODBC and permissions, so I'll be brief.

MID servers uses JDBC - a Java version of ODBC that works in pretty much the same way. Here's how to set up a connection:

Navigate to System Import Sets, Data sources

Create NEW

"Type" is JDBC

"Format" can be MySQL; Oracle; SQL Server

As long as you know the connection parameters you should be good to go with the rest. Once set up you can 'Test Load 20 Records' into your staging table.

Hopefully that will give you a head start with the formal articles suggested by Haseena Ayesha, above.

PS. you can do exports like this, too. Look at Export Sets 😉

[surendarm]

Hi Andy,

Thank you for your response.

We are trying to connect to a database which has been made accessible via ODBC connection. In ServiceNow, we dont have an option to choose 'ODBC' when we configure the data source.

As you said, does the ODBC connection works same as the 'JDBC' type of Data Source in ServiceNow or do we need to configure any additional setups to make ServiceNow to recognize the ODBC connection?

And when you say 'ODBC and Permissions', could you please let me know what was it about?