SSIS API Source

SSIS API Source

API Source can be used to read data 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.

Features

  • In few clicks read data from 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
  • 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 Destination
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 Source on Data Flow Designer

SSIS Data Flow Task - Drag and Drop

SSIS Data Flow Task – Drag and Drop

SSIS API Source - Drag and Drop

SSIS API Source – Drag and Drop

 

Create new API connection

SSIS API Destination - Create API Connector

SSIS API Destination – Create API Connector

OR use this method

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

 

How to read data from API Service

Select the Connection, the Endpoint, and fill in the inputs it needs. Preview the data

Select the Connection, the Endpoint, and fill in the inputs it needs. Preview the data

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

 

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

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