How to read ServiceNow data in MS SQL/SSRS/Java using ZappySys Data Gateway?
In this section we will learn how to configure and use ServiceNow Connector in the API Driver to extract data from the ServiceNow.
Create Data Source in ZappySys Data Gateway based on 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 password
Steps 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.