ETL Products Overview

Client Login

ETL Products Overview

Whatever you do and whatever you 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
Run some reports against the database

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, that means you can load your data today and solve all the data quality problems right now.

Advaced 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, to form data marts and data warehouses and also to convert databases from one format or type to another.

Not Just ETL

We believe that nowadays most of the customers do not just want to transfer the data from one table into another. Data could come from different sources such as ftp, file or email servers. We provide solutions which Automate entire process of working with data. It is the software which is easy to understand and to use.

ETL Products:

Visual Importer

Download Free Trial Now

Loads data into ANY database from Text, Excel, MS Access, DBF files or any ODBC compliant database, can run sql before and after loading the data

Data Exchange Wizard

Download Free Trial Now

This Wizard helps you to load and export data from/into various data sources 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.
Integrated expression builder, comprehensive error log, rejected records file. Source Data Filtering

Visual Importer Professional

Download Free Trial Now

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

Download Free Trial Now

Combines Powerful features of Visual Importer and Visual Importer Professional plus Execution agent which can be run as a windows service.

Recommended product for enterprise environment.

Advanced ETL Processor

Download Free Trial Now

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

Advanced ETL Processor Professional

Download Free Trial Now

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

Download Free Trial Now

Combines Powerful features of Advanced ETL Processor and Advanced ETL Processor Professional plus Execution agent which is run as a 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 routine

VImpX

Download Free Trial Now

ActiveX which imports data into Oracle ,SQL Server,ODBC 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

Download Free Trial Now

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

Download Free Trial Now

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 we just have to edit the data manually

Active Table Editor

Download Free Trial Now

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

Download Now

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

Testimonials

Currently we are using Visual Importer Ent to import our client’s customer RMA data into our SQL server for further processing and export same data to their ftp server.

We Process 3000 files daily, 24h x 365d

C Gandhi
Nesa-Canada