JSON SSIS Components (SSIS Productivity Pack)

JSON in SSIS is made easy with the JSON components available in KingswaySoft's SSIS Productivity Pack. The SSIS Productivity Pack includes four JSON components, two to transform existing JSON data into column data, the others to transform column data into JSON structure.

These SSIS JSON components offer developers 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. Also included as an HTTP Connection Manager that supports working with virtually any REST API including those with OAuth2 authentication.

SSIS JSON Source

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 that 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 within an ETL project to extract JSON data from various sources.

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

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 an 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 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 for many scenarios including sending to a REST web service or save to a file stored locally or in the cloud.

For more information, visit www.kingswaysoft.com/json

Licensing

We offer three licensing levels: Free Developer's License, Trial License, and a Commercial Subscription License.

1. Free Developer's License: You do not need to acquire a license if you only want to test out the software functionality within the development tools (SSDT-BI, BIDS - Business Intelligence Development Studio, or Visual Studio). After installation, the software will operate under the free developer license by default. With the developer license, you can create and develop data flows within the development tools (SSDT-BI, BIDS, or Visual Studio), including executing test loads without requiring a commercial license. To recap, The free developer license is fully-functional within the development tools (SSDT-BI, BIDS, or Visual Studio). The only limitation is the inability to run the software outside the development tools.
2. Trial License: If you want to evaluate whether the software functions properly outside of the development tools (SSDT-BI, BIDS, or Visual Studio), you can acquire a trial license using the License Manager program which is installed along with the software. To request a Trial License, please open the License Manager program (on your new server) and select “Change License Key”. You can leave the license field empty in this case. Once the other fields are completed, the “Request a Trial License” button will be enabled for your activation. After you have acquired a trial license, you will be able to run SSIS packages on a scheduled basis, or from any other Windows process such as command line. The trial software will operate fully-functional for the trial period, which is generally 14 days. When the trial period expires, the software will revert to the free developer license.
3. Commercial Subscription License: A commercial license is required when executing unattended jobs (SQL Agent Job, dtexec command line, etc.). Various subscription terms are available.