Integration - Importing data from SQL Server into ServiceNow

[jameslg75]

Hello,

We would like to import data from a SQL Server DB into our instance via JDBC through a MID Server. The issue is, before querying, we need to execute a stored proc on the instance which stages the data.   This needs be done on a scheduled basis, Schedule Import Set.   I tried to look for examples to see if execuing a stored proc is possible, but with little success.   Any help would be sincerely appricated.

Thanks

[pankaj_puniani]

Hi Jamie,

You can have 2 Data sources , first jdbc data source (run Stored proc against SQL Server on JDBC datasource by selecting specific SQL in   Query field & text to execute procedure in 'SQL Statement' field) and second jdbc datasource will do the actual query. Then create Schedule imports for both datasources, with datasource 1 schedule import as a parent of datasource2 schedule import. Hope it helps.

Regards,

Pankaj

[tantony]

Pankaj,I have a similar situation but the data from first   scheduled import   decides whether the second scheduled import   should run or not. Will the pre-import script of second scheduled import   have access to data imported from first(parent) scheduled import. I use a MID Server to import data from a remote MySql table.