SSIS API Destination

SSIS API Destination

API Destination can be used to write data (Insert/Update/Delete/Lookup) or row by row lookup from popular API Data Sources (see list here) using predefined Connector File without learning internals of API Calls. This component allows you make API calls and read API data as Flat Table. If API support this component can send data in BULK.

Features

  • In few clicks write data to Popular Online Services (e.g. Zendesk, OData, Zendesk, Zoho CRM, Google Sheets, BigQuery, Jira, Amazon MWS, SharePoint and growing…  (see list here))
  • No need to learn Complex API Configurations / Pagination / Authentication details
  • Support for Source to Target Mapping
  • Allow many BULK write operations (CRUD) such as (i.e. Insert, Update, Delete, Lookup, Select)
  • Intuitive UI for easy step by step configuration without having API knowledge
  • Easily modify existing connector file based on your need.
  • Allows to create and use your own reusable connector file for custom API (or you can consider using our generic JSON Source or XML Source)
  • Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
See also
SSIS API Source
JSON Source Connector (File, REST API)
JSON File Destination (Create JSON File)
XML Source (File, SOAP, REST API)
XML Destination (Create XML File)
CSV File Source (Flat File or Web API)
CSV file Destination
Download Help File Buy View All Tasks

Prebuilt Connector Files

ScreenshotsUseful LinksSystem Requirements

Drag and drop API Destination on Data Flow Designer

SSIS Data Flow Task - Drag and Drop

SSIS Data Flow Task – Drag and Drop

SSIS API Destination - Drag and Drop

SSIS API Destination – Drag and Drop

Create new API connection

SSIS API Destination - Create API Connection

SSIS API Destination – Create API Connection

Create new API Connection

Create new API Connection

Choose [OData] from Popular Connectors dropdown and Click Continue

Choose Inbuilt API Connector

Choose Inbuilt API Connector

Search Connector Online

Search Connector file Online

Search Connector file Online

 

This example doesn’t need any authentication so leave everything else default

API Connection Screen

API Connection Screen

SSIS API destination - Configuration (Select Table, Parameters)

SSIS API destination – Configuration (Select Table, Parameters)

Configure Columns Tab to review output columns

API Source Output Columns - Check / Uncheck Columns you want for downstream

API Source Output Columns – Check / Uncheck Columns you want for downstream

Configure API destination Mapping settings

Configurate the Mappings tab

 

 

Execute the package and verify data in the file (used in Trash Destination)

Execute Package - Reading data from API Source and load into target

Execute Package – Reading data from API Source and load into target

 

References

See Also

Click here to learn more about System Requirements
Download View All Tasks Like This