SQL Server ServiceNow Connector
In this article you will learn how to integrate
Using ServiceNow Connector you will be able to connect, read, and write data from within SQL Server. Follow the steps below to see how we would accomplish that.
Driver mentioned in this article is part of ODBC PowerPack which is a collection of high-performance Drivers for various API data source (i.e. REST API, JSON, XML, CSV, Amazon S3 and many more). Using familiar SQL query language you can make live connections and read/write data from API sources or JSON / XML / CSV Files inside SQL Server (T-SQL) or your favorite Reporting (i.e. Power BI, Tableau, Qlik, SSRS, MicroStrategy, Excel, MS Access), ETL Tools (i.e. Informatica, Talend, Pentaho, SSIS). You can also call our drivers from programming languages such as JAVA, C#, Python, PowerShell etc.
If you are new to ODBC and ZappySys ODBC PowerPack then check the following links to get started.
Video Tutorial - Integrate
ServiceNow data in SQL Server
This video covers following and more so watch carefully. After watching this video follow the steps described in this article.
- How to download / install required driver for
ServiceNowintegration in SQL Server
- How to configure connection for
- Features about
API Driver(Authentication / Query Language / Examples / Driver UI)
ServiceNowConnection in SQL Server
Create Data Source in ZappySys Data Gateway based on ZappySys API Driver
Download and install ZappySys ODBC PowerPack.
Search for gateway in start menu and Open ZappySys Data Gateway:
Go to Users Tab to add our first Gateway user. Click Add; we will give it a name tdsuser and enter password you like to give. Check Admin option and click OK to save. We will use these details later when we create linked server:
Now we are ready to add a data source. Click Add, give data source a name (Copy this name somewhere, we will need it later) and then select Native - ZappySys API Driver. Finally, click OK. And it will create the Data Set for it and open the ZS driver UI.ServiceNowDSN
When the Configuration window appears give your data source a name if you haven't done that already, then select "ServiceNow" from the list of Popular Connectors. If "ServiceNow" is not present in the list, then click "Search Online" and download it. Then set the path to the location where you downloaded it. Finally, click Continue >> to proceed with configuring the DSN:ServiceNowDSNServiceNow
Now it's time to configure the Connection Manager. Select Authentication Type, e.g. Token Authentication. Then select API Base URL (in most cases, the default one is the right one). More info is available in the Authentication section.
Authenticate using ServiceNow instance username and passwordSteps to get ServiceNow Credentials
To get your Instance name, Username and Password:
- Log in into your ServiceNow and go to https://developer.servicenow.com/dev.do.
- Click on your profile icon.
- Select your instance.
- Click on "Manage instance password" or similar link.
- In the opened page you should see Instance name, Username and Password.