How to connect ServiceNow in SSIS


This article guides you through connecting to the ServiceNow API in SSIS. The ZappySys ServiceNow connector facilitates seamless integration and management of ServiceNow data.


  • SSIS PowerPack: Download and install the ZappySys SSIS PowerPack from the Customer Download Area or get the trial version.

  • ServiceNow Account: Ensure you have a ServiceNow account to access ServiceNow data.


Steps to get ServiceNow Credentials: To get your Instance name, Username and Password:

  1. Log in to your ServiceNow and go to ServiceNow Developers.
  2. Click on your profile icon.
  3. Select your instance.
  4. Click on “Manage instance password” or similar link.
  5. On the opened page, you should see the Instance name, Username, and Password.

Connect with ServiceNow Connector in SSIS:

  1. Add a Data Flow task to your SSIS package.

  2. Inside the Data Flow, add an API Source component.

  3. Configure a new connection within the API Source by selecting the ServiceNow connector and proceeding to the next step.

  4. Enter your instance name, user name, and Password, and test the connection.

  5. Save the configuration by clicking OK.

  6. Choose a table/endpoint and preview the data.


Save your credentials securely for future use.


Following these steps, you can seamlessly connect to ServiceNow within SSIS, leveraging the ZappySys tool for efficient data retrieval and integration. For assistance or inquiries, contact our support team via chat on our website or through email at


For more detailed information, refer to our ServiceNow connector article.