SSIS JSON Integration Pack

SSIS JSON Integration Pack

SSIS JSON Integration Pack is your complete toolset to automate JSON integration scenarios in SSIS (e.g. Consume/Produce/Parse). Using simple drag and drop interface you can read data from JSON files or JSON Web Service (i.e. REST API). It includes JSON Source Connector, Export JSON File Task, JSON Parser Transform and JSON Generator Transform.

Features

  • Read JSON data from any REST API Web Service using methods such as GET/POST.
  • Read JSON data from single or multiple JSON files (use of wildcard allowed. e.g. c:\data\*.json)
  • Support for Path expression to extract data from any level (e.g. Extract Orders nested under Customer Node).
  • Support for passing custom headers to API Web service
  • REST API Paging support to loop through multiple requests (see)
  • Parse source JSON String/Documents into multiple columns/rows.
  • Ability to de-normalize nested JSON data into flat structure
  • Create simple or nested JSON documents inside DataFlow Task using simple drag and drop approach
  • Ability to create nested JSON from Multiple datasets
  • Ability to create single JSON document for all input records or create one document for each input row from ROOT dataset
  • Export multiple tables/views to JSON files (e.g. Sales% or do SalesJan|SalesFeb)
  • Export SQL query output to JSON file
  • Inbuilt Layout Editor for creating complex JSON with nested structure (Document Array, Value Array, Nested attributes
  • Automatically Split exported JSON data into multiple files by Size or Number of records
  • Automatically Split exported JSON data into multiple files by Split By Column (e.g. SplitBy=Country will create new file for each country)
  • Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Articles/Tutorials: JSON related articles
Download Buy View All Tasks

SSIS JSON Source Connector (JSON File, REST API)

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

SSIS JSON Generator Transform

SSIS JSON Generator Transform SSIS JSON Generator Transform can be used to generate single or multiple JSON documents from any type of datasources (e.g. SQL Server, MySQL, Flat File, Excel) inside dataflow task.
Read more

SSIS JSON Parser Transform

SSIS JSON Parser Transform SSIS JSON Parser Transform can parse JSON string into multiple columns and rows (Helpful to extract data from raw JSON string stored as database column or coming from other source).
Read more

SSIS Export JSON File Task

SSIS Export JSON File Task SSIS Export JSON File Task can be used to generate simple or complex JSON files out of relational data source such as SQL Server, Oracle, MySQL. In few clicks you can create desired JSON Shape from single or multiple tables (Parent/Child Nested Documents).
Read more

SSIS OAuth Connection Manager

OAuth Connection Manager OAuth Connection Manager can be used along with JSON Source 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 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