Introduction
When working with SSIS, developers often need to connect to APIs, cloud platforms, or specialized data sources. While generic connections (such as Microsoft’s HTTP or FTP) can get the job done, they often require complex configurations, custom scripts, and troubleshooting challenges related to authentication or pagination.
The ZappySys SSIS PowerPack provides a suite of specialized connectors (ZS connectors) that simplify these tasks. These connectors offer a friendly interface, require less manual configuration, and handle common challenges automatically, making ETL development faster, easier, and more reliable.
Prerequisites
- Download and install the ZappySys SSIS PowerPack.
Problem with Generic Connections
When using generic connections in SSIS, developers often encounter:
- Complex authentication setup (OAuth, API keys, tokens).
- Limited visibility into request/response details.
- Longer learning curves due to reliance on scripting or custom code.
Connectors
HTTP Connector
If you open the Connection Manager and create a new connection, you will notice both the ZS-HTTP connection and the Microsoft HTTP connection.
With the Microsoft HTTP connection, you can enter credentials and some proxy settings.
With the ZS-HTTP connection, you have additional options, including basic authentication, dynamic token, static token, JWT token, and more.
For example, under the Dynamic Token tab, you can specify the request needed to fetch a token.
You can also configure how the token should be retrieved and refreshed.
OAuth Connection
While there is no out-of-the-box OAuth support in SSIS, the ZS-OAuth connection allows you to authenticate using both versions of OAuth 1 and 2. They both offer built-in options for popular services, including Google, Amazon, Microsoft, and others.
If the service is not listed, you can use the Custom OAuth option and select the required grant type.
Additionally, letbs allow you to add additional request data, callback URLs, timeouts, and more.
API Connector
The ZS-API connector includes ready-to-use templates for popular services, such as Google, Amazon, SharePoint, Mailchimp, and more. You can check the full list here.
Pagination
When working with REST APIs in SSIS, pagination can be a challenge. With generic components, you need to configure them manually by setting up loops and handling “next page” logic yourself.
With the ZS API components, pagination is built in and works automatically. Just point the connector to your API, and it retrieves all pages behind the scenes.
We have an article about pagination here that explains the available options in detail. Here’s a quick look at the pagination configuration screen:
Conclusion
Generic SSIS connection configurations require complex configuration and manual work to handle authentication and error management. By contrast, ZappySys connectors simplify these processes with a straightforward, user-friendly interface that makes configuration faster and less error-prone.
While generic connections leave developers struggling with scripting and manual loops, ZappySys components handle these details behind the scenes, freeing teams to focus on delivering value.
Explore our SSIS PowerPack for more information and download and install it to start building smarter, faster, and more scalable solutions.
References
Contact us
If you encounter any issues or have specific questions, reach out to our support team via live chat or support ticket using our email support@zappysys.com.