Toolsverse-Data management tools

Data Explorer offers the following benefits:

  • Easy data integration and ETL. Don’t write a single line of code unless you want to.
  • Visual ETL designer accelerates the time it takes to design, develop and deploy complex ETL scenarios.
  • One click any-to-any data migration.
  • Universal database development. Use the same tool to develop SQL for a wide range of databases.
  • Broad connectivity to any type or source of data with native support for most databases and NoSQL data sources.
  • Ability to view, edit, discover, export and transform data regardless of format and location.
  • Parallel processing to ensure high performance and scalability.
  • Ability to use Data Explorer in the desktop, client-server and Web modes.
  • Ability to schedule and monitor in real time ETL and SQL tasks.

"We have used Toolverse Data Explorer to assist in a complex migration of a legacy application to a cloud based environment. Data Explorer has allowed us to quickly develop an efficient and repeatable migration strategy and their support team have been excellent in dealing with our questions.

Finbar Murphy
Datatecnix - http://www.datatecnix.co.uk/


Easy Data Integration and ETL

Easy Data Integration and ETL

Design, develop, execute and schedule complex data integration and ETL scenarios in easy-to-use IDE. Drag and drop heterogeneous data sources from the objects browser to designer. Discover dependencies and metadata on the fly.

ETL scenarios are created using XML-based language, but you don’t need to write a single line of code unless you want to. Data Explorer includes a visual ETL designer: every action completed in designer automatically and in real time produces high quality code in editor and vice versa.

Once created, scenarios can be executed in background or scheduled. You can also use compact and embeddable ETL framework.

Data Explorer supports scheduling and monitoring of ETL tasks as well as audit and role-based security. Administrators can limit access to particular connections and scenarios.

Read more about ETL and data integration development in Data Explorer.


ETL engine

ETL engineData integration, data migration and ETL components of the Data Explorer are powerd by built-in ETL engine.

Features of the ETL engine:

  • Automatic data type translation
  • Data streaming
  • Parallel processing to ensure high performance and scalability
  • Real time data movements and data transformations
  • Batch processing
  • Support for bind variables
  • Creating schema objects on the fly using source as a pattern. For example, a table can be automatically created if it doesn’t exist
  • Column transformations: calculate value, add column, exclude column, change data type
  • Dataset transformations: filter, sort, join, minus, intersect, de-normalization, de-duplication, matrix transformation, XLT transformations
  • Dimension transformations: add dimension, extract dimension
  • Data quality features and validation using SQL, JavaScript, other scripting languages and Regex
  • Support for pluggable scripting languages such as JavaScript and Ruby
  • Using of databases specific features: stored procedures and functions, language constructs, cursors, temporary tables, exception handling, external tools
  • CLOB and BLOB support
  • Common tasks such as OS commands, support for file-based operations such as copy, delete, rename, etc, sending emails

Read more about Toolsverse ETL Framework.


One Click any-to-any Data Migration

One Click any-to-any Data Migration

Data Migration cannot be easier. Just drag and drop all your data sources, regardless of format and location, specify destination and click “Migrate” button.

Schema objects such as tables, indexes and files will be automatically created and data copied to destination.

There is no other tool on the market which supports migration of a heterogeneous SQL and Non-SQL data sources to any destination with zero programming effort.

Read more about one click data migration.


Universal Database Development

Universal Database Development

Design, develop, execute, schedule and profile SQL and stored procedures for wide selection of databases. Browse and search database objects and metadata.

Use drag-and-drop to create complex queries or write SQL in the SQL-dialect-aware editor.  Format SQL and use built-in code snippets for most popular SQL databases.

Take advantage of fully integrated ETL engine which can help you automate many database development tasks, such as data mining, data migration, data preparation and data cleaning.

What makes Data Explorer unique among similar tools is an ability to run in the client-server and Web modes so connections and other resources can be shared between developers and easily monitored by administators.

Database development features of Data Explorer:

  • Background error parsing: syntax errors in your SQL are detected and highlighted offline, even before SQL is executed
  • Extensive support for database specific features for most widely used databases, including support for specific flavors of SQL, running SQL in an external tool,  explain plan,  auto trace and much more
  • Ability to execute SQL with parameters
  • Ability to execute stored procedures and functions right from the Objects Browser
  • Ability to display output parameters, including cursors, returned by stored procedures
  • Ability to capture and display dbms output
  • Centralized server-based deployment when all sensitive information (such as database credentials) are stored on the server and all SQL queries are executed by server component (Web and client-server modes only)
  • Ability to schedule and audit execution of SQL queries (Web and client-server modes only)
  • Ability to assign roles and rights to developers (Web and client-server modes only)

Read more about database development in Data Explorer.


Data Discovery

Data Discovery Data Explorer allows you to view, edit, discover, export and transform data regardless of format and location.

It is more than just simple CRUD and pretty pictures:

  • Easy access to the databases, spreadsheets and structured data formats
  • Blend data from multiple heterogeneous sources
  • Support for multidimensional datasets
  • Discover dependencies between data
  • One click export
  • In memory transformations and on-the-fly calculations
  • Ad-hoc queries

Read more about data discovery features of Data Explorer.


Built-in Scheduler

Built-in Scheduler

The scheduler is built-in with the Data Explorer Entreprise edition.

When Data Explorer is used in the client-server or Web modes you can schedule and monitor SQL and ETL tasks. Select a task to schedule, enter cron-based time pattern and specify connections and parameters.

You can schedule as many tasks as you want and you can monitor scheduled tasks in real time.  Tasks can be suspended, rescheduled or removed.

Tasks are executed by the server component based on the predicted time but you can also execute any task at any time regardless of the schedule.

You can configure scheduler to notify you by email when task is finished.

Read more about built-in scheduler.


Web application and supported operating systems

Supported operating systems and browsers

What makes Data Explore unique among other offerings is that, in addition to the traditional desktop, there is a fully functional Web application.

Web application includes all functionality of the desktop client, such as: ETL and data integration, database development and data discovery. It is 100% HTML+JavaScript and it works in any modern browser.

Data Explorer supports the unique features of each operating system. It looks and feels like a Mac application on a Mac and it distinctively Windows-like on Windows.


Data Connectivity

Out of the box, Data Explorer comes with a wide selection of connectors for various SQL and Non-SQL data sources. Database connectors natively support database-specific SQL syntax (for example Oracle PL/SQL), metadata catalogs, connectivity options and parameters. Non SQL connectors can write (and in most cases read) data and metadata from most popular file-based formats. There is an open API, so it is possible to add new connectors as plugin modules. The built-in connectors include:

Connector

Metadata

Native SQL parser and code generator

Write

Read

Oracle

Entire Oracle metadata catalog

Yes, PL/SQL, Oracle specific SQL

Yes

Yes

MS SQL Server

Entire MS SQL Server metadata catalog

Yes, Transact-SQL, SQL Server specific SQL

Yes

Yes

MySQL

Entire MySQL metadata catalog

Yes, MySQL stored procedure language, MySQL specific SQL

Yes

Yes

PostgreSQL

Entire PostgreSQL metadata catalog

Yes, pg/SQL, PostgreSQL specific SQL

Yes

Yes

DB2

Entire DB2 metadata catalog

Yes, SQL PL, DB2 specific SQL

Yes

Yes

Sybase ASE

Entire Sybase ASE metadata catalog

Yes, T-SQL, Sybase ASE specific SQL

Yes

Yes

Informix

Entire Informix metadata catalog

Yes, SPL, Informix specific SQL

Yes

Yes

Generic JDBC

Only supported by JDBC driver

No

Yes

Yes

Generic ODBC

Only supported by ODBC driver

No

Yes

Yes

Excel ODBC

Yes

No

Yes

Yes

Access ODBC

Yes

No

Yes

Yes

XML

Yes

N/A

Yes

Yes

XML with transformation

Yes

N/A

Yes

Yes

JSON

Yes

N/A

Yes

Yes

Delimited text

Yes

N/A

Yes

Yes

Fixed-length text

Yes

N/A

Yes

Yes

Excel XLS

Yes

N/A

Yes

Yes

Excel XLSX

Yes

N/A

Yes

Yes

HTML

No

N/A

Yes

No

PDF

No

N/A

Yes

No


I/O

Explore, create and update your data regardless of location. In addition to IP based JDBC connectivity, Data Explorer can read and write data using File, FTP, SFTP and HTTP protocols. Standard mail SMTP protocol is also supported. There is an open API, so it is possible to add new protocols as plugin modules.


Intuitive and Easy-to-Use UI Intuitive and Easy-to-Use UI

The UI is slick, modern and easy-to-use. There is a single Objects Browser which puts all information in one place and there is a global universal search across all object types. Most tasks can be performed using drag-and-drop and wizards but there is a powerful language-aware code editor which supports ETL language and most SQL dialects.


Editions and Pricing

While we created Data Explorer as an universal data-management tool, we understand that each user needs may vary. You might not need a particular functionality at the moment so why pay more? With that in mind we offer four editions of the Data Explorer:

Features

SQL

ETL

Pro

Enterprise

Pluggable SQL and Non SQL connectors

Yes

Yes

Yes

Yes

Pluggable I/O processors

Yes

Yes

Yes

Yes

Objects browser, global search, drag and drop, wizards, visual designers, code-aware editors

Yes

Yes

Yes

Yes

Data Integration and ETL Development

No

Yes

Yes

Yes

One Click Data Migration

Yes

Yes

Yes

Yes

Universal Database Development

Yes

No

Yes

Yes

Data Discovery

Yes

Yes

Yes

Yes

Built-in Scheduler

No

No

No

Yes

Role-based security and audit

No

No

No

Yes

Web-based User Interface

No

No

No

Yes

Ability to work in the client-server mode

No

No

No

Yes

Ability to deploy to the cloud

No

No

No

Yes

Flexible License

No

No

No

Yes

Support

By email

By email

By email

By email

Price

$150/per developer

$150/per developer

$250/per developer

$500/per developer or subscription

Our flexible enterprise level license allows you to configure Data Explorer and pay only for components that you need. For example if you are only interested in data integration and ETL development, don't need database development capabilities but still want to schedule and run tasks on the server (required enterprise license) you can request a flexible license which costs much less. Alternatively the subscription is available for an enterprise level license. Please contact us for more information.


Deployment Options

Choose deployment option based on your budget and requirements.

Deployment

What it is

Available in

Desktop

Traditional desktop application. No server

All editions

Client-server

Desktop client + server component deployed to the Java Servlet compatible Web container

Enterprise edition

Web

Web application deployed to Java Servlet compatible Web container

Enterprise edition

Cloud

Web or desktop client + server component deployed to the cloud provider of your choice

Enterprise edition


Support

Standard email support available at no charge. We will answer your questions and help you to setup and configure Data Explorer. We offer a premium support uppon request. Read more about Toolsverse support options.


Buy Toolsverse Data Explorer

Buy Data Explorer Today

Fully integrated Universal Database Development, Data Discovery, Data Integration and Data Migration IDE.