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

Command line for Data Export to JSON, Excel, CSV

  • Export relational data (e.g. MySQL, SQL Server, Oracle, DB2) to CSV, JSON, Excel (xlsx), PDF or HTML file format
  • 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
OverviewScreenshotsUseful 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

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

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)

Features: Data Export to PDF

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

Download

 

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 Excel file on multiple tabs (automatically split into multiple tabs)

Export SQL Server Table to Excel tabs (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)

  • .net framework 3.5 or higher must be installed
  • Supported Client Operating Systems: Windows 7, Windows 8, Windows 8.1
  • Supported Server Operating Systems: Windows Server 2003/R2, Windows Server 2008/R2, Windows Server 2012/R2