Configure JSON & XML Workflows

Work with Hierarchical Data Structures

KingswaySoft's JSON & XML components let you navigate nested documents, map fields, and define data types through an intuitive editor. They also support unlimited hierarchy levels, attribute extraction, and reusable layouts, making it easier to handle complex structures in your data flows.

JSON Extract Editor interface showing data nodes and settings

Increased Efficiency

Get Structured Data from Complex Formats

Easily extract structured outputs from nested records and table-based sources using a visual editor built for SSIS workflows. The components support web-based and file-based formats, offering field-level control during extraction. You can define output schemas, rename and validate fields, and apply filters to shape your data. Ideal for document and web sources that require structured delivery for downstream processes such as data warehousing and analytics integration.

Document Workflow Integration

Move data across connected platforms
Document Source
Usage
JSON from REST APIs
Extract nested records and shape into flat tables
XML from business systems
Transform and route data into storage or analytics
Mixed-format integrations
Handle variable structures with reusable mappings

Use Across Document Workflows and Platforms

KingswaySoft

JSON & XML Processing Components

SSIS JSON Connector
JSON
SSIS XML Connector
XML
SSIS HTML Table Source Connector
HTML Table Source
SSIS Productivity Pack

Enable Complex Data Processing

Support document-style inputs, online data, and semi-structured formats
with components designed for flexible, high-volume integration work.

DownloadPurchaseHelp Manual

Familiar UI

A performant and flexible ETL platform

Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), 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 integrations within a matter of minutes.

Data flow diagram showing REST destination, error handling, and DataReader destinations.

More Resources

Download our Data Sheet for
SSIS Productivity Pack

SSIS Productivity Pack Data Sheet