JSON Components
via SSIS Productivity Pack
Easily work with JSON data in SSIS as if it were column data with the JSON Processing Components, found within the SSIS Productivity Pack.
What other applications can you sync with JSON?
Click here for more solutions.
Data Integration Made Easy
JSON Processing Components
There are five JSON Processing components available for working with JSON Data: Source, Destination, Extract Component, Merge, and Extract Task.
With JSON components, developers have full flexibility and control over their JSON data structure. Developers are able to add, select and deselect nodes and structure their data as needed for input or output.
In our 2023 Release Wave 2, we added the new "JSON Extract Task", which can be used for sending an HTTP request and receiving a response.
The JSON components, part of the SSIS Productivity Pack, supports as many data inputs and outputs as needed.
SSIS JSON Source/Extract
The SSIS JSON Source component allows developers to retrieve JSON documents from an HTTP URL or a local file. From there the component will then break up the structure and produce column data which can be consumed by downstream SSIS pipeline components. With JSON Source component developers are able to integrate with virtually any web API including those REST APIs with OAuth2 authentication requirements.
Also available is a JSON Extract component which is a transformation component that can be used to extract any complex JSON document or column data already in SSIS pipeline by transforming it into tabular data structure which can be further consumed by downstream SSIS pipeline components.
Either component will support as many outputs as needed based on the JSON structure to transform all necessary data into column data to use as required in the downstream pipeline.
SSIS JSON Destination/Merge
Using SSIS JSON Destination, developers are able to merge input data based on the JSON data structure defined in the component. You can then specify the component to write the merged JSON document to a local file or you can send it to a HTTP URL to perform a RESTful service call.
Also available is JSON Merge component which is a transformation component that can be used within an ETL project to merge input data into JSON hierarchical structure to use in downstream pipeline.
Either component will support as many data inputs as needed to create the desired JSON hierarchical structure. The transformed JSON data can then be used for many scenarios including sending to a REST web service, or save to a file stored locally or in the cloud.
New SSIS JSON Extract Task
The JSON Extract Task is an SSIS control flow task component used for sending an HTTP request and receiving a response. A common use case for this component is downloading a file.
JSON Component
is available in the
SSIS Productivity Pack
JSON Components: Data Integration Made Easy
Our solution is easy to use, offering code-less integration between the JSON Components and virtually any other application or database system. Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), a performant and flexible ETL platform, allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integration within a matter of minutes.
JSON Components are available within the JSON & XML Processing components of our SSIS Productivity Pack, a large collection of premium and unique ETL tools to enable greater development productivity. We also offer several additional connectivity solutions to easily integrate JSON Components with applications such as Microsoft Dynamics 365, SharePoint, Salesforce, and many more.
See our full product offerings for more information.
Other SSIS JSON/Web Services Components
Our JSON & XML Processing components make it easy to integrate with different services within the ETL process. Each component available has been specifically developed to expand and enhance data migration and integration processes. In addition to JSON, the JSON & XML Processing components include:
XML
