How to connect ServiceNow in SSIS

SSIS PowerPack API Connectors
1

Introduction

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

Prerequisites

  • 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

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.
    image
    image1436×620 79.2 KB

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.

    ServiceNow Connector
    ServiceNow Connector868×715 25.3 KB

  5. Save the configuration by clicking OK.

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

    ServiceNow example
    ServiceNow example888×605 39.7 KB

Considerations

Save your credentials securely for future use.

Conclusion

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 support@zappysys.com.

Reference

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