ETL Tools Overview |

ETL Tools Overview

Whatever you do and whatever your business is sooner or later you would need to work with the databases:

Transfer data from one database into another
Load data into the database from various files
Export data from the database
Generate reports

Transform and Validate Data
Automate business processes
Process Emails
Sort and de-duplicate Data

We supply a wide range of ETL tools which will satisfy your every need and suit any customer.

All our ETL tools have no limitations, so you can load the data today and solve all the data quality problems right now.

Advanced ETL Processor - Data Flow Diagram

What is ETL?

ETL stands for for extract, transform, load, three database functions that are combined into one tool to pull data out of one database and place it into another database.

Extract - the process of reading data from a database.
Transform - the process of converting the extracted data from its previous form into the form it needs to be in so that it can be placed into another database. Transformation occurs by using rules or lookup tables or by combining the data with other data.
Load - the process of writing the data into the target database.

ETL is used to migrate data from one database to another, populate data marts and data warehouses and also to convert databases from one format or type into another.

ETL Products:

Visual Importer

Loads data into ANY database from Text, Excel, MS Access, DBF files, Oracle, MS Sql, MySql, PostreSQL, Interbase/Firebird or any ODBC compliant database, run sql before and after loading the data

This Wizard Loads/Exports data from/into various data sources such as delimited and fixed width files or ODBC data source into/from Oracle, MS SQL Server, MySql, PostreSQL, Interbase/Firebird or any ODBC compliant database
Uses native API, Capable of performing calculation during import, may also execute SQL statements before and after Import or Export.
Integrated expression builder, comprehensive error log, rejected records file. Source Data Filtering

Visual Importer Professional

In addition users can design Import, Export and SQL scripts, add them to the Package and schedule it for execution on regular basis. Visual Importer Professional stores all information in the repository. Unlike DTS, SSIS and Oracle Warehouse builder Visual Importer Professional can receive emails and process attachments as well. All FTP operations also supported. By combining simple Package Items together Visual Importer Professional helps small businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.

Recommended product for development environment.

Visual Importer Enterprise

Combines Powerful features of Visual Importer and Visual Importer Professional plus Execution agent - windows service.

Recommended product for enterprise environment.

Advanced ETL Processor

Designed for those users who want not just only load or export data but also perform complex validations and transformations, data grouping, de-duplication and sorting.

Advanced ETL Processor Professional

Codeless Automation Tool.

Users can design Data transformations and Sql script add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis

By combining simple Package actions together Advanced ETL Processor Professional helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.

Advanced ETL Processor Professional supports complex enterprise environments including database, file, smtp, pop3 and ftp servers.

Recommended product for development environment.

Advanced ETL Processor Enterprise

Combines Powerful features of Advanced ETL Processor and Advanced ETL Processor Professional plus Execution agent - windows service.

Recommended product for complex enterprise environment.

More information about ETL tools:

ActiveX Components:

It is hard to imagine any modern business application not working with the databases. We designed two ActiveX components you can use right now instead of wasting time developing your own import and export routines

VImpX

ActiveX which imports data into various databases from flat files, Excel, DBF,MS Access Databases, pivot tables or ODBC data sources.
Very fast and reliable. Uses native API (OCI API,BCP API,ODBC API) Capable of performing calculations during import, may also execute SQL statements before and after import.
Integrated expression builder, comprehensive error log, data preview, rejected records file.

DEWizardX

This ActiveX helps to load and export data from/into various datasources such as delimited and fixed width files or ODBC data source into/from Oracle, MS SQL Server or any ODBC compliant database
Uses native API, Capable of performing calculation during import, may also execute SQL statements before and after Import or Export

Reporting:

Active Business Intelligence Portal

Active BI Portal is a business intelligence software that provides an integrated solution for designing and deploying reports and web forms over the internet and Intranet.

Active BI Portal consists of two parts Active BI Portal Manager which works on Windows only and server part which is collection of PHP scripts and can be run on Windows, UNIX or Linux.

Active BI Portal uses roles based security model. Every portal user must be a member at list one of the users groups and have menu assigned. Combination of group access rights and user group membership defines list of documents user can get access to. Active BI Portal works with all major commercial and open source databases.

Table data editing:

Let's face the fact sometimes it is not possible to automate everything and very often we have to edit the data manually

Active Table Editor

Imagine the following situation you have accounting software package and would like to design some additional reports. You know the database structure pretty well and created some mapping tables for the reports. Now you need to give the end users ability to change the mapping tables, print and export the data. You may use Oracle SQL plus or MS SQL Server Management studio to do that but these tools far too complicated for the users.
This is where Active Table Editor may step in to give you a helping hand

Freeware:

Database Browser

This easy to use tool allows you to connect to any database and browse or modify data ,run sql scripts, export and print data.