Here we will explore how to create and use your own Custom API Connector.
An API Connector, based on ZappySys API Connector Framework, provides reading and writing capability from and to an API with almost no coding required.
Create API Connector for SSIS
Integrate virtually any REST/SOAP API with SSIS for read/write operations
Inside an SSIS package, in a Data Flow Task use the ZappySys SSIS PowerPack drag-and-drop connectors — API Source and API Destination — to receive and send data to an API with little configuration.
Run it in:
Let's get started:
Proceed to PrerequisitesCreate API Connector for ODBC applications
Integrate virtually any REST/SOAP API with ODBC-compliant applications (for reading and writing)
Use an ODBC data source based on the ZappySys API ODBC Driver (part of ODBC PowerPack) to communicate with an API in your:
Reporting application
SQL Server
ETL tool
Code
Other applications
- Microsoft Excel, Access, or other ODBC application