Get ServiceNow data into a Microsoft SQL Server database

sbosch
Kilo Explorer

‎04-23-2015 02:34 PM

Hi all,

I am trying to import tables directly from the ServiceNow database into a Microsoft SQL Server database.   I have been using the linked server method as per the following article: Using ODBC Driver in SQL Server - ServiceNow Wiki.   However, this method has limitations in terms of how much data you can bring in at once.   When I bring in a large amount of data(which is a requirement), I get this error:

OLE DB provider "MSDASQL" for linked server "SERVICENOW_PRAXPROD" returned message "[DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]Disk Cache file size limit has reached[10215]".

As per the help on the wiki, I went into the ServiceNow ODBC Management Console and set the ServuceSQLDiskCacheMaxSize to the maximum allotted size (1048575).   I am still having trouble bringing these tables over to the Microsoft SQL Server.

Any thoughts, SN Community?

Thank you in advance.

Labels:
0 Helpfuls
  • 3,715 Views
1 REPLY 1

Michael Kaufman
Giga Guru

‎04-27-2015 09:29 PM

You may have to adjust your sql statements to limit how many records are imported at once.   I had to write a few sql statements at a client once to get around this issue.



I have had problems with Linked servers in the past, as the odbc account hits ServiceNow constantly and causes performance degradation.   You don't really notice it initially, but when you have a couple 100K incidents years later, it really gets bad.   Maybe you are querying a small table though and that isn't an issue.



If you are trying to replicate the entire ServiceNow database, there are vendors that specialize in that.   Most don't use the odbc driver due to these issues.   You can buy their product or get some ideas on how they do the replication.



Mike


0 Helpfuls