Softpedia >Windows >Internet >Servers >Database Utils >Toolsverse Data Explorer Enterprise >  Changelog

Toolsverse Data Explorer Enterprise Changelog

What's new in Toolsverse Data Explorer Enterprise 5.7-86126

Jun 7, 2017
  • Added:
  • Ability to connect to the web services, which are using one-step OAuth1 authentication
  • Ability to read Excel spreadsheets using worksheet index (in addition to the worksheet name)
  • Ability to use JavaScript preprocessor when reading text documents in the XML, CSV and JSON formats
  • Improved and fixed:
  • Bug fixes and performance improvements in the ETL engine

New in Toolsverse Data Explorer Enterprise 5.7-85697 (May 22, 2017)

  • Added:
  • Ability to run SQL on any data set, including files and responses from the web services
  • Ability to use XLS style-sheet as a connection parameter to transform any XML
  • New parameters for CSV, XML and JSON formats
  • Improved and fixed:
  • Bug fixes and performance improvements in the ETL engine
  • Third-party libraries upgraded to the latest versions
  • Improved SQL parsing and code formatting for all supported SQL dialects
  • Improved CSV, JSON and XML parsing

New in Toolsverse Data Explorer Enterprise 5.5-80987 (Feb 28, 2017)

  • Added:
  • Connector for HL7 2x and HL7 FHIR
  • Connector for HL7 MLLP
  • Connector for Google Analytics
  • Connector for Google Cloud Storage
  • Support for OAUTH2 (token-based) authentication in HTTP connector
  • Support for change replication in ETL engine
  • Ability to use wild-card file names for the source
  • Ability to add configurable suffix to the destination file name
  • Simplified APIs for accessing and modifying data set fields (including nested)
  • New parameters for XML and JSON formats
  • MkDir command added to the File Manager ETL task
  • Improved and fixed:
  • Bug fixes and performance improvements in the ETL engine
  • Third-party libraries upgraded to the latest versions
  • Significantly improved SQL parsing and code formatting for all supported SQL dialects
  • Improved JSON and XML parsing
  • Fixed memory leak in Redis connector
  • Improved visual query builder

New in Toolsverse Data Explorer Enterprise 5.0-72473 (Sep 21, 2016)

  • Added:
  • New modern Look and Feel
  • Over 10 new transformations
  • Connectivity to Snowflake, Amazon S3, Redis, POP3 and SMPT
  • Support for GZIP and password protected ZIP files
  • Support for merge (upsert) SQL statements for MS SQL Server, PostgreSQL and MySQL
  • Improved and fixed:
  • Performance when using JavaScript transformations improved by at least 500%
  • Performance when using bind variables improved by at least 50%
  • Improved support for native database data types for all supported SQL dialects
  • Improved support for REST and SOAP web services
  • Significantly improved SQL parsing and code formatting for all supported SQL dialects
  • Fixed 200+ bugs

New in Toolsverse Data Explorer Enterprise 4.0-31374 (Mar 2, 2015)

  • Changed:
  • Improved support for proxy servers
  • Significantly improved SQL parsing and code formatting for all supported SQL dialects
  • Improved user experience when working with ETL Designer
  • Improved support for Mac OS
  • Improved support for key-value denormalization transformation
  • Latest Java version is bundled with Windows distro
  • Bug fixes and performance improvements
  • Added:
  • Support for NTLM-based authentication
  • Ability to merge CSV files of the different structure
  • Ability to stream data when performing merge of the CSV files

New in Toolsverse Data Explorer Enterprise 4.0-29148 (Feb 10, 2015)

  • Changed:
  • Improved performance and reliability of the ETL engine by adding context-sensitive optimizer
  • Improved support for Web services
  • Improved support for XML files
  • Improved support for JSON files
  • Improved support for Excel XLSX files
  • Improved user experience when working with ETL Designer
  • Improved XML code formatter
  • Improved user experience when working with files
  • Improved logging and error reporting
  • Bug fixes and stability improvements
  • Added:
  • Support for SOAP-based Web Services
  • Ability to configure connections for the REST and SOAP Web Services
  • Ability to execute XQuery on XML-based datasets
  • Support for XQuery added to the ETL Designer
  • Ability to perfrom normaliztion and denormalization of the key-value datasets
  • Support for key-value normaliztion and denormalization tasks added to the ETL Designer
  • Ability to execute JavaScript anywhere in the ETL scenario
  • Ability to populate dataset inline, from any fragment of text, using given connector, such as JSON, XML, etc
  • Ability to use pre-defined header and footer in the File Merge task
  • Ability to tokenize connection URL and Properties as well as task variables
  • JavaScript, JSON, HTML and CSS code formatters
  • New ETL code snippets and examples

New in Toolsverse Data Explorer Enterprise 4.0-22541 (Dec 27, 2014)

  • Changed:
  • JRE 1.8 is now bundled with Windows version of the Data Explorer
  • Features of the older version of JavaScript engine (Rhino) are now supported by the Data Explorer when running on JRE 1.8
  • Improved performance of the ETL engine
  • Improved handling of the HTTP(s) connections
  • Improved support for REST based Web services, specifically PUT and DELETE requests
  • Improved user experience when working with long URLs and dataset names
  • Improved user experience when working ETL Designer, specifically handling of the XML special characters
  • Improved update notifications
  • Improved automatic update
  • Added:
  • Ability to partition dataset based on combination of key columns or maximum number of rows
  • Support for partitioning task added to the ETL Designer
  • Ability to merge text files into the single file
  • Support for file merge task added to the ETL Designer
  • New ETL code snippets and examples

New in Toolsverse Data Explorer Enterprise 4.0-22377 (Dec 24, 2014)

  • Changed:
  • JRE 1.8 is now bundled with Windows version of the Data Explorer
  • Older version of JavaScript engine (Rhino) is now supported by Data Explorer running on JRE 1.8
  • The way Data Explorer manages HTTP(s) connections
  • Improved support for REST based Web services
  • Improved user experience when working with long URLs and dataset names
  • Added:
  • Ability to partition dataset based on combination of key columns or maximum number of rows
  • Support for partitioning task added to the ETL Designer
  • Ability to merge text files into the single file
  • Support for file merge task added to the ETL Designer
  • New ETL code snippets

New in Toolsverse Data Explorer Enterprise 4.0-21700 (Oct 3, 2014)

  • Fixed:
  • Excel XLS and XLSX workbooks were not created when some columns presented in the source were excluded from the destination
  • Delimited and fixed length text files were not properly created when some columns presented in the source were excluded from the destination
  • When Connection parametrs were updated in the Objects Browser, Data Integration Studio was not properly creating corresponding connection
  • Oracle error "ORA-12899: value too large" when running explain plan for the large queries
  • Added:
  • Ability to skip empty rows when reading delimited and fixed length text files
  • Support for skiping empty rows added to the ETL Designer and Text Connection Properties Editor

New in Toolsverse Data Explorer Enterprise 3.3-54987 (Apr 5, 2013)

  • Added direct links to the Online support resources and User Guide
  • Added Enterprise license and changed the way system checks and displays license information
  • As a part of this effort the following functionality was removed from the free edition of the Data Explorer and from the Data Migration suite:
  • Client-server and WEB modes
  • Data Set Export
  • Improved ETL syntax validation in the ETL editor and ETL Runner
  • Added support for long column names to the ETL framework
  • Added ability to add column to the destination on the fly and calculate its value using JavaScript or SQL
  • Added ability to use destination variable names in the JavaScript to calculate a variable value
  • Improved connectors for Excel, text and XML files.
  • Improved performance of the ETL engine
  • Added ETL code snippets for all new ETL features
  • Improved error handing in the client-server mode. Fixed major serialization bug.
  • Usability and user experience improvements across all applications
  • Bug fixes

New in Toolsverse Data Explorer Enterprise 3.2-52630 (Feb 4, 2013)

  • Added ability to set a filter in the nodes browser (for example filter tables by name)
  • Added new search parameters such as “starts with”, “ends with” and “case sensitive”
  • Added new search modifiers
  • The full least of modifiers:
  • case - search is case sensitive
  • exact - search exact string
  • start - string must start with
  • end - string must end with
  • regexp - use regular expression
  • root - search from the root node
  • Improved auto-updated functionality
  • Fixed bug with a silent update, added direct link to the download.
  • Fixed a bug which was causing automatic transaction commit in some cases

New in Toolsverse Data Explorer Enterprise 3.1-48967 (Feb 4, 2013)

  • Added graphical UI for interactive data set transformations
  • Added graphical UI for statistical functions
  • UI and usability changes across all applications
  • Bug fixes

New in Toolsverse Data Explorer Enterprise 2.0.2 (Feb 4, 2013)

  • Added Order Data Set Transformation
  • Added Transpose Matrix Transformation
  • Added Filter Data Set Transformation
  • Added Remove Duplicates Transformation
  • Added Union of the Data Sets Transformation
  • Added Join Data Sets Transformation
  • Added Denormalize Data Set Transformation
  • Added ETL snippets for the new transformations