Softpedia >Mac >Developer Tools >Data Explorer >  Changelog

Data Explorer Changelog

What's new in Data Explorer 4.0-31374

Mar 3, 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 Data Explorer 4.0-29149 (Feb 17, 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 Data Explorer 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 Data Explorer 4.0-22377 (Dec 24, 2014)

  • Changed:
  • 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 Data Explorer 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 Data Explorer 3.3 (Apr 19, 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
  • 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 error validation, added new data types, improved handing of the not standard formatting.
  • 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
  • Added Windows and OS/X installers
  • Bug fixes

New in Data Explorer 3.2 (Apr 19, 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”
  • 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
  • Added new search 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

New in Data Explorer 3.1 (Apr 19, 2013)

  • Added graphical UI for interactive data set transformations
  • Added graphical UI for statistical functions
  • Added charts
  • Added support for multiple open ETL scenario editors
  • Added support for multiple open files in the Content Manager
  • Added support for filtering and sorting for non-SQL data sources
  • Added standard data viewer functionality (filtering, sorting, transformations, functions) to the Excel file viewer
  • Added auto-update functionality
  • Added ability to select an alias from available Oracle TNS connections
  • Added automatic split on multiple files with grouping by key fields when exporting data sets to the different file formats
  • Added automatic index creation to the Data Migration application
  • UI and usability changes across all applications
  • Bug fixes