SSIS JSON Export Task - Generate JSON file from SQL Server, MySQL or Oracle Tables

preview_player
Показать описание
Generate JSON file from relational Database such as SQL Server, MySQL, Oracle in few clicks.

◾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 Compression and Append
◾Create Multi content JSON documents
◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
Рекомендации по теме
Комментарии
Автор

how do we connect this export js task to web api destination block ?

pvksmaheeth