SSIS Web API Integration Pack (Call REST API, XML SOAP Web Service), Consume JSON/XML data in SSIS

SSIS Web API Integration Pack (Call REST API, SOAP Web Service)

SSIS Web API Integration Pack is your complete toolset to automate REST API/Web API/SOAP/OAuth/OData Service integration in SSIS. Using simple drag and drop interface you can consume data from any Web Service in few clicks (XML or JSON format). You can also send Ad-hoc request to any web server including file upload requests. It includes JSON Source Connector, XML Source Connector and REST API Task.

Features

  • Consume any RESTful Web API (like this) or XML SOAP Web Service (like this) in few clicks
  • Send Ad-hoc Http Web Request (e.g. GET, POST) and save response into SSIS variable or file
  • Filter, Pivot, De-normalize nested XML or JSON into flat document just like regular database table
  • Read data from JSON/XML files or RESTful API services (such as Twitter, Zendesk)
  • Support for JSONPath style expression to extract sub-documents or array
  • Support for OAuth 1.0 and 2.0 security standard which is adopted by major cloud services (e.g. Google API, Facebook, Salesforce, Dynamics CRM, Office 365, MailChimp and many more)
  • Support for OData format (see)
  • Support for Basic authorization (Passing UserID and Password to REST API Service)
  • Support for looping through multiple files using wild card pattern (e.g. *.json).
  • Support for HTTP Request with Custom Headers.
  • Support for REST API Paging (3 different methods) – Loop through multiple requests (explained here and here)
  • Support for very large JSON files
  • Support for Pivoting (Convert Columns to Rows)
  • Ability to output and indent raw JSON from inner array
  • Support for SSL3 and TLS 1.2 protocol for encryption
  • Support for passing cookies
Download Buy View All Tasks

SSIS JSON Source (File, REST API, OData Connector)

SSIS JSON Source (File, REST API, OData Connector) SSIS JSON Source Connector can be used to extract and output JSON data stored in local JSON files, JSON data coming from REST API webservice calls (Web URL) or direct JSON String. Component also supports JSONPath to filter data from nested array/sub-documents. This component is optimized to work with very large files. Read more

SSIS XML Source (SOAP Web Service, XML File Connector)

SSIS XML Source (SOAP Web Service, XML File Connector) SSIS XML Source can be used to consume multiple XML files or XML formatted response from SOAP Web service or REST API Web Service. It supports advanced filtering along with flexible approach to configure request parameters for web service. Read more

SSIS REST API Web Service Task

SSIS REST API Web Service Task (GET, POST HTTP Web Request) SSIS REST API Web Service Task can be used to automate any HTTP Web Requests (e.g. GET, POST, PUT, DELETE). You can pass credentials using Basic Authorization or OAuth 2.0. You can save response extracted using this task to SSIS variable or file. Read more

SSIS OAuth Connection Manager

OAuth Connection Manager OAuth Connection Manager can be used along with JSON Source, XML Source or REST API Task to communicate with REST API Services which supports OAuth Security Protocol (e.g. Twitter, Facebook, Linkedin, Google, Microsoft). This connection manager handles complex authorization flow to obtain initial Token and renewing token automatically once its expired.
Read more

SSIS HTTP Connection Manager

OAuth Connection Manager HTTP Connection Manager can be used with JSON Source, XML Source or REST API Task to call any HTTP Web Service (GET, POST etc). It allows you to set various properties of HTTP Connection such as Timeout, Proxy, UserId/password etc.
Read more
Download View All Tasks