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

[Riya Verma]

Hi @surendarm ,

Hope you are doing great.

To establish connectivity using ODBC, please follow these steps:

1. Ensure that you have the necessary ODBC driver installed for the external system on the MID Server machine.
2. Configure the ODBC driver by providing the required connection details, such as the server name or IP address, port number, database name, and authentication credentials.
3. In ServiceNow, navigate to the MID Server configuration page by going to "System Definition" -> "MID Servers" and select the appropriate MID Server.
4. Within the MID Server record, locate the "Additional capabilities" section and check the box for "ODBC".
5. Save the MID Server configuration to enable ODBC connectivity.

Once the ODBC connection is established, you can useServiceNow's capabilities, such as scripting or integration actions, to interact with the external system's data using SQL queries through the ODBC driver.

[Jeffrey Siegel]

Wow, thanks for the fast response.

im on step 3, and i dont see a System Definition - Mid Servers module,  when i access the mid server's configuration via the Mid Servers - servers, i dont see any capabilities area,

when i goto Mid Servers - Capabilities, i get a list of capabilities like, Google, REST, JDBC, SSH... but dont see ODBC in this listing.

My instance is running on Tokyo Release.

[Jeffrey Siegel]

I couldnt get this to work with ODBC connection, however i was able to get this to work with JDBC connection. and it was much easier than setting up the ODBC driver.