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 connections) can get the job done, they typically involve 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.
Additional tabs allow you to configure extra 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:
This makes development faster, reduces errors, and helps you build ETL packages with far less effort.
More Connections
Beyond HTTP, OAuth, API, and SFTP, the SSIS PowerPack includes connectors for PostgreSQL, MongoDB, Excel, Amazon services, and additional data sources. Each connection comes with multiple tabs for advanced configurations and error handling.
Conclusion
Generic SSIS connections often require complex configurations and manual work to handle authentication, pagination, or error management. By contrast, ZappySys connectors simplify these processes with straightforward setup, automatic pagination handling, and a more friendly user interface that makes configuration faster and less error-prone.
While generic connections leave developers struggling with scripts and manual loops, ZappySys components take care of these details behind the scenes, freeing teams to focus on building 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.