filmov
tv
SSIS API Destination - Write or lookup data from API Data Sources using predefined Connector File

Показать описание
If your connector is not listed as API Connector in the above page then try using our universal Web API Destination Component below
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 using predefined Connector File without learning the 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 a few clicks write data to Popular Online Services (e.g. Zendesk, OData, Zendesk, Zoho CRM, Google Sheets, BigQuery, Jira, Amazon MWS, SharePoint and growing)
* 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 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
Related Searches:
===========================================
Make API call using Predefined Connector File
Reading data from API Destination and load into target
Make API call using SSIS API Destination
Create API Connector
How to write data from API Service