Release Notes

Version 2.0.2.10505 [Aug 08, 2022]

FIX: ZappyShell DB Command Builder - Change to Output Format doesnt update Mapping Designer in Custom layout (You always see JSON format related right click menu items)
FIX: ZappyShell DB Command Builder - Connection Dialog box does not list ODBC DSN in the dropdown
FIX: ZappyShell DB Command Builder - Indent Output (Pretty Print) option does not work
FIX: ZappyShell DB Command Builder - Load Settings does not work
FIX: ZappyShell DB Command Builder - Mixed Mode authentication fails to generate Preview in Custom Layout - Throw error in JSON/XML Sample Data Preview : Login failed for user 'xxx'.
FIX: ZappyShell DB Command Builder - Reset Settings option does not work
FIX: ZappyShell DB Command Builder - UI Layout Issue
FIX: ZappyShell DB Command Builder - Using ODBC option on Build Connection Dialog box Crashes the UI
FIX: ZappyShell DB Command Builder - When you choose custom layout and keep source SQL Blank it generates wrong Command Line

NEW: ZappyShell DB - Add options for custom escape rule (Replace certain source characters before writing to the output file)
NEW: ZappyShell DB - Allow \x0022 as double quote escape sequence in argument value
NEW: ZappyShell DB - Provide Command Line Builder UI for ease of use
NEW: ZappyShell DB - Allow multi line SQL in Script file (Prefix line with ^ to indicate line continuation)

NEW: ZappyShell Redshift - Added export command. Now you can export redshift data to CSV, JSON or Excel format from table or sql query.
NEW: ZappyShell Redshift - Added sqlexec command. Now you can execute any sql command for redshift database (e.g. CREATE / DROP / INSERT).
NEW: ZappyShell DB - Added --pretty-print option to indent output.
NEW: ZappyShell DB - Added --throw-err-if-nodata option to throw error if no data returned from sql query/table.
FIX: ZappyShell Redshift - Table name with schema is not working for parameter --target-table (if you ommit schema from --target-table then works fine).

NEW: Added mkkey command to generate new AES or RSA encryption key
NEW: Added encryption feature for redshift import command. Now you can load encrypted data to redshift by just specifying encryption key using --enc-key parameter for import command.
NEW: Added encryption support for S3 put command. Just specify encryption key using --enc-key and algorithm type (use --enc-aes or --enc-rsa) parameters and any files uploaded will be encrypted on your computer before sending to AWS.
NEW: Added encryption support for S3 get command. Just specify encryption key using --enc-key and algorithm type (use --enc-aes or --enc-rsa) parameters and any files downloaded will be automatically decrypted on your computer.

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

This is the first release of ZappyShell Command line Tools

www.zappysys.com | Products | All copyrights reserved. ZappySys LLC.