Toolsverse-Data management tools

Data Explorer

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

Start developing complex data integration and ETL scenarios, SQL scrips and stored procedures today. When working with databases take advantage of integrated ETL engine which can help you automate many database development tasks. Easily migrate data and schema objects from any source to any destination.

Data Explorer offers the following benefits:

  • Easy data integration and ETL. You don’t need to write a single line of code unless you want to.
  • One click any-to-any data migration.
  • Universal database development.
  • Ability to view, edit, discover and transform data regardless of format and location.
  • Intuitive, drag and drop user interface.
  • Ability to use Data Explorer in the desktop, client-server and Web modes.
  • Ability to schedule and monitor ETL and SQL tasks using built-in scheduler.

Easy Data Integration and ETL

Easy Data Integration and ETLDesign, 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 two way ETL editor and designer: everything you do in the designer automatically and in real time produces high quality code in editor and vice versa. Once created scenarios can be executed in background, scheduled, or executed by compact and embeddable ETL framework. When running in the client-server or Web modes Data Explorer supports scheduling and monitoring of the ETL tasks as well as audit and role-based security. Administrators can limit access to the particular connections and scenarios.

 

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


ETL engine

Data integration and ETL component of the Data Explorer is powerd by built-in ETL engine.

Features of the ETL engine:

  • Automatic data type translation
  • Data streaming
  • Parallel extract and load
  • 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 table can be automatically created if it doesn’t exist
  • Column transformations: calculate value, add, remove, change data type
  • Dataset transformations: filter, order by, set operations, de-normalization, de-duplication, matrix transformations, 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: 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 MigrationData 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 using best algorithm possible.  Simply put, there is no other tool on the marker which supports migration of the 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 DevelopmentDesign, 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.  Use unique features of the Data Explorer which you cannot find anywhere else such as scheduling and audit of the SQL tasks, centralized server-based deployment when all sensitive information such as database credentials stored on the server and all SQL queries executed by server component, assign roles and rights to the developers in your team using built-in role base security.

Some unique features of the Data Explorer available to developers:

  • 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 external tool,  explain plan,  auto trace and much more
  • Ability to execute SQL with parameters. Entered parameters are stored between sessions
  • 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 for some databases
  • Ability to schedule and audit SQL (Web and client-server modes only) and run SQL in background
  • 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 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 in easy to use GUI

Read more about data discovery features of the Data Explorer.


Built-in Scheduler

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.  If you choose to you will be notified my email when task is finished. System automatically logs all sensitive information including input and output parameters, statuses and exceptions.

 

Read more about built-in scheduler.


Role-base security and audit

The role-based security is automatically activated in the client-server and Web modes. Once logged in, user only has access to the objects and activities allowed by administrator. Multiple roles can be assigned to the user and multiple permissions can be assigned to the role. There are pre-configured roles and you can create your own roles. Administrator can assign different levels of access to the Connections, Scenarios and other objects as well as particular activities, such as create ETL, develop SQL, etc. System-wide audit is activated by default. You can enable or disable audit for certain events. The audit log includes who, what and when as well as how long, status, output and exception log.

 

Read more about security and audit.


Supported operating systems and browsers

Supported operating systems and browsers Data Explorer is a Java application so it works everywhere Java works. We put an extra effort to make sure it supports unique features of each operating system. For example, It looks and feels like a Mac application on Mac and it distinctively Windows-like on Windows. In addition to native look and feels Data Explorer comes with a set of modern cross-platform skins. What makes Data Explore unique among other offerings is that, in addition to the traditional desktop, there is a fully functional Web UI. It is 100% HTML+JavaScript with a backend written in Java. Web version of the Data Explorer works in any modern browser.


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 PostgeSQL metadata catalog

Yes, pg/SQL, PostgeSQL 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.


Compare Editions and Pricing

While we created Data Explorer as a universal data-manipulation tool we understand that each user mileage may vary. You might not need a particular piece of the functionality at the movement 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

Ability to deploy to the cloud

No

No

No

Yes

Support

By email

By email

By email

By email

Flexible License

No

No

No

Yes

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 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 (require enterprise license) you can request a flexible license which costs much less. Alternatively the subscription is available for enterprise level license. Please contact us for more information.


Deployment Options

Choose deployment option depending 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


Compare to other Data Integration and ETL Tools

On the specs sheet Data Explorer is right there with the best in class systems.  In terms of performance it supports everything from data streaming and multithreading to high volume load technics provided by target databases and in memory transformations. What makes Data Explorer unique is that it gives seasonal ETL and data integration developer a choice. You can use drag and drop and wizards or you can go down to the code level. You can create scenarios 100% independent from data formats or you can use unique database features.  You can run and schedule ETL and data integration scenarios from Data Explorer or you can embed them in your application using compact and portable ETL framework.


Compare to other Database Development Tools

Once again, feature-by-feature Data Explorer is comparable to any leading database development tool. So why switch or choose Data Explorer in the first place? One of the main advantages of the Data Explorer is a level of integration between core components: database development, data integration and data discovery. You don't have to jump between different tools and interfaces to run SQL queries, discover data and dependencies between data, migrate data between databases, write and execute ETL and data integration scenarios. All data and tools are one mouse click away. Now, if you add some truly unique features of the Data Explorer such as client-server and Web, built-in scheduler, roles-based security and audit, one click any-to-any data migration you will be hard pressed to find better universal database development tool.


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 by inquire. Read more about Toolsverse support options.


Buy Sencha Complete

Buy Data Explorer Today

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