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

OverviewUseful LinksSystem Requirements

Feature Compare FREE Edition Standard Edition

Commands for Data Export [4 commands]

Click here to see all commands

Premium support (Phone call, Web meeting) Export MySql data to JSON,excel,csv,pdf,html Export MySql data to JSON,excel,csv,pdf,html
Advanced options (not available in FREE version):

  • Support for splitting data in more than 25 files
  • Support for files bigger than 100MB
  • Support for multi threaded operations
Export SQL Server data to CSV, JSON, Excel, PDF, HTML Export SQL Server data to CSV, JSON, Excel, PDF, HTML
Data Export commands:

Export oracle data to CSV, JSON, Excel, PDF, HTML Export oracle data to CSV, JSON, Excel, PDF, HTML

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 – 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 for JSON, XML, CSV, Excel – Target Options (Append, Compress to GZip)

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

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

Using Custom Layout for Complex JSON / XML Output

Layout Editor to define Structure of 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)

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)

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)

Download
  • Supported Client Operating Systems: Windows 7, Windows 8, Windows 8.1