How to insert rows from ServiceNow into a 3rd Party MS SQL Server database using JDBC and MID Server?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-21-2020 03:46 PM
I need to insert/update data from ServiceNow into a table within 3rd Party MS SQL Server Database using JDBC and MID Server. I am not sure where to start? There is a Service Account which has the required privileges on the SQL Server Database to insert and update records and the MID server is used to query the records as well however I need to send the records back once updated and I am not sure where and how to put that configuration/script. I have read other articles/responses with similar intent but a little lost where to start.
- Labels:
-
Integrations
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-21-2020 04:01 PM
For starter, the following page may be of interest.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-21-2020 05:58 PM
Thank you Hitoshi for your response. I have explored that option as well as a more of last resort. It does requires DBA to configure ServiceNow as ODBC source. I am specifically looking for possible options for sending records out from ServiceNow using JDBC and/or MID Server without using export sets. I am also unsure whether setting up ServiceNow as Linked Server would still use MID Server for communication or not. Does Linked Servers option use MID Server for data transfer?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-13-2021 01:18 PM
Were you able to figure this out
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-20-2025 12:51 AM
Hi @Hitoshi Ozawa, @Niamul Arifin, @Shishir Pandey,
Wanted to ask if anyone found the solution for this implementation?
