Exporting to SQL - What's the smart alternative to a data lake?

Dean Consulting
Mega Contributor

‎11-24-2023 02:14 AM

Hello, Folks

 

A quick one. I'm seeking a smart approach to extracting a selection of tables (Incident, Problem, Change) from SNow to an SQL database. From that database we can use PowerBI or similar tool to create reports. 

 

The organisation has a global instance of SNow, and we in the UK are only interested in our tables (36 we are interested in). Performance is important as we don't want to cause problems for others globally. Currently, we perform a manual extract of around a dozen tables to a SL database each morning - that's not the way to do things. We are offered the opportunity to have a datalake view set up, but it is extremely expensive.

 

Would the Scheduler role help? Could we effectively schedule a download of the 36 tables daily? Would DataPump be the way to go? Would Performance Analytics do the job? 

 

Trying to figure it out.

 

Thanks, folks!

 

 

Labels:
0 Helpfuls
  • 414 Views
1 REPLY 1

-O-
Kilo Patron
Kilo Patron

‎11-24-2023 04:13 PM

ServiceNow supports ODBC type of access, where one installs the ServiceNow ODBC driver on a server or computer and one can access ServiceNow data in read-only mode as one would access any ODBC data source.

From there one can create a simple ODBC integration downloading deltas each day, or even more frequently into a local PostgreSQL, MariaDB, or any kind of SQL Database.

ServiceNow ODBC driver.

It uses SOAP at its base, but maybe it is the perfect fit for this.

0 Helpfuls