How Toolsverse products solve your problems:
Task: Database development tasks, including but not limited to: running, and profiling SQL queries and scripts, creating stored procedures, functions and other database objects, running scripts in the external tool, exploring database-specific objects such as packagers, triggers, sequences, etc, visualizing data using grid, form and charts views, exporting data to various file formats such as text, XML and all versions of the Excel.
Recommended solution: Data Explorer ETL edition.
Good solution: Data Explorer free edition.
Task: Administer database and run sql queries remotely from any device with a web browser (tablets included).
Recommended solution: Web version of the Data Explorer ETL edition. It includes all of the functionality of the desktop version. Additionally you can limit access to the certain resources such as databases and other data sources.
Task: Database development and ETL tasks when it is require to share resources such as connections, code snippets, ETL and data migration, scenarios, etc. and limit access to the certain resources such as database connections, etc.
Recommended solution: Client-server version of the Data Explorer ETL edition. It includes all of the functionality of the desktop version. Additionally you can share resources and limit access to the certain resources.
Best solution: Data Explorer Enterprise. In addition to all features of the Data Explorer ETL edition Enterprise edition includes a full year of the premium support and does not limit number of workstations where Data Explorer can be installed.
Task: Visualize and explore data in the various databases and file formats, run complex transformations such as de-normalization, pivot, de-duplication, set operations, matrix transposing, etc, execute statistical functions on data sets, compare, filter and order data sets, export data to the various file formats such as text, XML and Excel.
Example 1: There are data in the two different production databases (Oracle and DB2) used by different departments. The goal is to create a quarterly financial report by combining data from both databases and save it as a delimited text file. With the Data Explorer, someone with knowledge about these databases can run queries and have results open in two separate tabs. One can then perform union transformation and combine them. The last step will be exporting data set to the delimited text file.
Example 2: There is an Excel spreadsheet with standardized test scores. Each student occupies multiple rows in the worksheet (one per specific test taken). There are also duplicated rows (the spreadsheet is generated by third-party application). The goal is to remove duplicates first and then de-normalize data so there will be just one row with the scores for all tests taken by each student. The task must be performed by someone who doesn't have any programming skills. Using Data Explorer, you can complete this task in three simple steps: 1) Open Excel spreadsheet and use graphical UI to perform clean-up transformation which removes duplicates 2) Use pivot transformation to de-normalize data 3) Use export to Excel to save spreadsheet.
Recommended solution: Data Explorer ETL edition. You can even view and edit files directly in local file system, WEB, FTP or SFTP.
Task: Manage content (files and folders) in the local and remote locations such as WEB, FTP or SFTP. View, edit, delete, rename, copy and move files and folders. Visualize and explore data in the file-based data sets such as text, XML, Excel, etc.
Example1: Сopy files from the SFTP site to your local hard drive.
Example 2: View an Excel spreadsheet in the remote FTP server, filter, sort and apply transformation and statistical algorithms to the worksheets.
Recommended solution: Data Explorer ETL edition. It is the only tool on the market which includes content management, data visualization and data discovery functionality.
Task: Migrate data from one database or file-based data source to another. Automatically create tables and indexes.
Example 1: Copy entire production database from MySQL to Oracle and automatically create all tables and indexes in the process.
Example 2: Copy data from multiple Excel spreadsheets and text files to the PostreSQL database and automatically create non-existing tables or delete data from the existing tables in the PostreSQL database.
Recommended solution: Data Migration Suite. Does not require programming skills.
Good solution: Toolsverse ETL Framework. Command line tool, requires programming skills.
Best solution: Data Explorer ETL edition. In additional to the functionality of the Data Migration Suite, the Data Explorer ETL edition includes ETL integrated development environment and redistributable ETL framework.
Task: Integrate data from the various heterogeneous systems.
Example 1: Convert data in the legacy system to the brand new Oracle database.
Example 2: Create daily Excel reports using data from the several production systems
Example 3: Load multiple comma-delimited text files into MS SQL Server database.
Recommended Solution: Toolsverse ETL Framework. Command line tool which can be embedded or executed remotely. The framework supports all jdbc-based data sources, file based formats such as delimited text,fixed-lenth text,xml, xml with transformation and all versions of Excel files. It is possible to write custom connectors for the data sources which are not supported yet.
Best Solution: Data Explorer ETL edition. Includes comprehensive data discovery and data visualization suite as well as rich ETL integrated development environment.
Task: Create and execute complex ETL scenarios for moving data from OLTP to OLAP database.
Recommended solution: Toolsverse ETL Framework. Command line tool which can be embedded or executed remotely. ETL Framework natively supports advanced features of the most popular relational databases such as bulk load, temporary tables, cursors, external tools, etc. It is extremely fast and natively supports data streaming.
Best solution: Data Explorer ETL edition. Includes rich ETL integrated development environment and data migration suite. Redistributable ETL framework is also included.
Task: Create, maintain and execute ETL scenarios of any kind.
Example 1: ETL scenario which routinely copies configuration data from the production environment to the QA (for debugging and testing purposes).
Example 2: Copy data from an Excel spreadsheet to the PostgreSQL database and automatically create all tables in the process
Example 3: Integrate data from various production databases, validate and clean up data in the process.
Recommended solution: Data Explorer ETL edition. It is a convenient way to develop and maintain all your ETL scenarios in one place.
Good solution: Toolsverse ETL Framework.
Task: All of the above in the rapidly changing environment where it is required to share resource, limit access to the certain resources, install software in the unlimited number of workstations and receive a full year of the premium support.
Recommended solution: Data Explorer Enterprise. In addition to all features of the Data Explorer ETL edition Enterprise edition includes a full year of the premium support and does not limit number of workstations where Data Explorer can be installed.
Task: Embed ETL framework into existing program.
Recommended solution: Eclipse project for ETL framework. Includes full source code, examples, java doc, tests, build scripts and third party libraries.