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

[AndyLock]

Sorry, Dude - didn't answer the ODBC & Permission thing.

Your MID server needs to be able to see your database server - ports and firewalls need to allow access.

When you create the JDBC connection in ServiceNow you will need a username and password to connect to the database instance. I'd create a new ServiceNowJDBC account just for this, and give it just the read-only permissions it requires to do the job.

If you've got a SQL guru you might find it easier to do much of the transforming & formatting in a SQL view, then link to that view. Just an idea.

[AndyLock]

Hey Surendar,

What sort of database are you connecting to: MySQL; SQL Server; Oracle? For these three you can just use native JDBC instead of ODBC.

JDBC isn't as good as ODBC for performance or memory intensive loads, but JDBC is platform independent.

If you're connecting to something else can you elaborate?

Have you already tried to configure a JDBC connection to your database from https://<yourinstance>.service-now.com/nav_to.do?uri=%2Fsys_data_source_list.do (or enter sys_data_source_list.do into the filter navigator)?

Here's an alternative: If your external database has a web service to consume then you can set up System Web Services in ServiceNow. It's a lot more fiddly to set up (IMHO) but is rewarding to do and gives you near real-time data 😄

GettingStartedWithREST

Andy

[surendarm]

Hi Andy,

Thank you for the response.

We are trying to connect ServiceNow with Progress database and this doesn't have a web service to consume.

Progress database has only ODBC connection available to interact with.

And OOTB, ServiceNow doesnt have an option to include 'Progress' similar to 'MySQL' 'Oracle'.

What setups I would need to take to connect ServiceNow to this Progress database via ODBC connection to pull information into ServiceNow.

Any inputs are much appreciated.

Thanks in advance.

Surendar M

[AndyLock]

Hi Surendar

Sorry for the late reply, but I don't have any 'proper' advice for you as I've never used Progress- except:

• perhaps try using one of the existing SQL connectors;
• can you schedule/copy the data from Progress to a free version of MS SQL using SSIS, then link from Service Now?
• can Progress schedule/export the data to csv/xml to be collected later by ServiceNow?

Hope you find a fix.

Andy

[Jeffrey Siegel]

Im trying to do the same thing, did you ever get this to work?  my destination is an Informix database, and i keep getting errors when MySQL, Oracle, and MSSQL try to access the database.  i setup an ODBC connection via System DSN, and need to figure out how to have servicenow access this server via my midserver and pull data.