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 data?
Click here for more solutions.
Data Integration Made Easy
JSON Processing Components
There are five JSON Processing components for working with JSON Data: Source, Destination, Extract, Merge, and Extract Task.
With the 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.
Use the JSON Extract Task for sending HTTP requests and receiving a responses.
The JSON components, part of the SSIS Productivity Pack, support as many data inputs and outputs as needed.
JSON Source & Extract
The 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 that can be consumed by downstream SSIS pipeline components. JSON Source component allows developers to integrate JSON data with virtually any web API, including REST APIs with OAuth2 authentication requirements.
The JSON Extract component is a transformation component that can be used to extract any complex JSON document or column data already in your SSIS pipeline by transforming it into tabular data structure, which can be then consumed by downstream SSIS pipeline components.
Either component supports multiple outputs as needed, based on the JSON structure, to transform all required data into columnar format for use in the downstream pipeline.
JSON Destination & Merge
The JSON Destination component allows developers 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 an HTTP URL to perform a RESTful service call.
The JSON Merge component is a transformation component that can be used within an ETL project to merge input data into JSON hierarchical structure for use in the 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 in many scenarios including sending it to a REST web service, or save it to a file stored locally or in the cloud.
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. It is designed to streamline communication with web services. It goes beyond simple file downloads, giving you the flexibility to send a wide range of HTTP requests, including GET, POST, PUT, DELETE, and PATCH.
This component makes it easy to interact with any REST API. You can define the request method, add query string parameters and headers, and configure a request body. It processes JSON responses and allows you to extract values using JPath queries for storage in SSIS variables. Its versatility makes it ideal for automating API calls, integrating with web services, and dynamically fetching data in ETL workflows.
Premium JSON Components
are available within
SSIS Productivity Pack
JSON Data Integration Made Easy
Our solution is easy to use, offering code-less integration for JSON data 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.
Premium JSON Components are available in 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 data with applications such as Microsoft Dynamics 365, SharePoint, Salesforce, and many more.
See our full product offerings for more information.
More 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
