Command line tools to export Data to JSON, Excel, CSV, PDF (from MySQL, Oracle, DB2, SQL Server)

Command line for Data Export to JSON, XML, Excel, CSV

Export relational data (e.g. MySQL, SQL Server, Oracle, DB2) to CSV, JSON, XML, Excel (xlsx), PDF or HTML file format
Comes with easy to use Command Line Builder (UI)
Export single or multiple tables using one command
Export single or multiple sql queries using one command
Support of MAP file to execute complex multi line queries not possible to type on command line
Support for file compression (file is compressed in *.gz)
Support for timestamp place holders in file path (e.g. specify file name as MyFile_{{YYYY}}_{{MM}}_{{DD}} to replace placeholder dynamically at runtime.
Automatically split large dataset into multiple files using max row count per file setting (see –splitrows option).
Automatically split large dataset into multiple files using max filesize setting (see –splitsize option)
Split dataset into multiple files based on group by column (e.g. Groupby Country column will create file for each country)
Support for multiple encodings (e.g. ASCII, UTF8, UTF16, UTF32, UTF7)
Support for pattern to query tables/views name with specific pattern (e.g. CUS% will export table name starting with CUS)
Support for adjusting output format for date
Support for escape sequence
Support for OLEDB drivers, ODBC drivers and ADO.net driver

Download

Help File

Buy

Data export to CSV file

Create CSV files with header or without header
Support for custom column separator
Support for custom row separator
Support for quoted value
Support for data append to exiting CSV File
Check this article to learn How to convert JSON / XML to CSV (Read from REST API)

Data export to Excel file

Export data to excel on specific tab
Export data to 2003, 2007, 2010 or 2013 format
Support for file splitting based on file size, row count or group by column
Support for large dataset (Yes you can export more than 65000 records)
Support for exporting to specific location in existing or new workbook. e.g. –excel-offset B5 will output dataset of 5th row of column B)
Export simple or complex JSON from multiple tables/queries (e.g. nested customer info with orders)
Support for data append to exiting Excel File
Check this article to learn How to convert JSON / XML / CSV to Excel (Read from REST API)

Features: Data export to JSON file

Automatically create JSON file structure from table or query
Create more complex JSON with nested attributes, array, nested document array using flexible Map File
Support for Server side Lookup for very large dataset with nested dataset joins
Support for Multi content JSON format
Support for escape sequence (e.g. new line replaced by \r\n as per JSON specification)
Support for data append to JSON File (only in Multi-Content mode)
Check this article to learn How to convert XML / CSV / Excel to JSON (Read from REST API)

Features: Data Export to PDF

Automatically create PDF file from any data source
Adjust print mode and paper size for exported PDF file

Screenshots

Export multiple tables to JSON / CSV / XML / Excel File (Simple Mode ) – Command line builder UI

Command Line Builder – Export Data to JSON, XML, CSV, Excel from multiple SQL Tables (ODBC, OLEDB, ADO.net Connection)

Command Line Builder for JSON, XML, CSV, Excel – Target Options (Append, Compress to GZip)

Command Line Builder – Additional Options for Export JSON, XML, CSV, Excel File

Generate Complex JSON / XML using Custom Layout – Command line builder UI

Using Custom Layout for Complex JSON / XML Output

Layout Editor to define Structure of JSON / XML Output

Exported JSON File Output – Generated from ZappyShell db.exe command line (Using Custom Layout File)

Export and Split Files By Row Count / Size – Command line builder UI

Split CSV, JSON, XML, Excel Data into Multiple files (Split by Rowe Count or Size)

Export table or query output to JSON files (automatically split into multiple files)

Export SQL Server Table to JSON files (split automatically using group by column)

Export table or query output to Excel files (automatically split into multiple files)

Export SQL Server Table to Excel files (split automatically using group by column)

Export table or query output to PDF files (automatically split into multiple files)

Export MySQL Table data to PDF Files

Export table or query output to CSV files (automatically split into multiple files)

Export Oracle Data to CSV files (split automatically using group by column)

Export table or query output to Excel file on multiple tabs (automatically split into multiple tabs)

Export SQL Server Table to Excel tabs (split automatically using group by column)