Advanced ETL Processor 2.3.0

Version: 2.3.0

Downloads:40

Hits:6133

SourceNO

Link Broken:Report It!

Package:Without source

Price:$199

More info Download

Description

Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database automatically. A unique technology called "What You See Is What You Load" saves a lot of time during testing and design of validation and transformation processes. It shows you how the data will be transformed and loaded into the data warehouse or database without actually loading it. At any time, you can press the 'Preview' button and see what the results of an ETL flow would look like.

Advanced ETL Processor can help you extract data from an Excel file, validate date formats, sort data, deduplicate it and load it into the database, run stored procedure or SQL script, once loading is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS, Advanced ETL Processor can also add new and update old records based on the key defined by user.

The program can extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables.

It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database.

If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

Related:

Bcp - Etl - Etl Data Transformation - Ms Sql Server - Odbc - Oracle - Powerful Etl Tool - Sql Loader

User Reviews:

Write Review *
Your name *
Email *
(Your comments will be reviewed by our staff before they are posted)
Rate this product *
Captcha Image
Enter code from image *

 

Related:

Visual Importer 4.9.0

Visual Importer loads data into any database from Text, Excel, MS Access, DBF files or any ODBC compliant database. It is easy to use and was...

By: dbsoftlab.com Homepage

Shareware

VImpX 4.9.0

Loads data into Oracle,SQL Server,ODBC from flat files, cross tables or ODBC. Very fast and reliable. Uses naitive API (OCI API,BCP API,ODBC API)...

By: dbsoftlab.com Homepage

Shareware

DEWizardX 3.6.0

This ActiveX helps you to load and export data from/into various datasources such as delimited and fixed width files or ODBC data source into/from...

By: dbsoftlab.com Homepage

Shareware

Visual Importer Professional 7.7.0

Visual Importer Professional automates the process of loading data into any database. It enables the user to design Import, Export and SQL scripts,...

By: dbsoftlab.com Homepage

Shareware

SQL Server Repair Toolbox 1.0.0

SQL Server Repair Toolbox is able to repair data for Microsoft SQL Server databases created under all major versions. Repair data type, table data...

By: Seva Bobrov Homepage

Shareware

dbForge Studio for SQL Server 5.5

GUI tool for SQL Server development, management, data reporting and analysis

By: Devart Homepage

Shareware

SQL Server Comparison Tool 1.2

SQL Server Comparison Tool is a Windows program for analyzing, comparing and documenting SQL Server databases. It's an ideal tool for Database...

By: AlfaAlfa Software

Freeware

Sql Backup Free 1.0.1

Sql Backup Free creates full MS SQL Server database backups on schedule, compresses backup files, sends them to a local, network folder, HDD drive...

By: Mike Shilov Ruslan Sudentas Homepage

Freeware

Universal SQL Editor 1.3.2

Intellisense enabled SQL editor for DB2, Oracle, SQL server, Sybase, etc. with SQL formatter.

By: Ming Software Homepage

Shareware

Navicat for SQL Server Database Client for Mac OS X - Compatible with Mac OS X Snow Leopard! 9.1.5

Navicat SQL Server GUI is a graphical tool for managing, monitoring, and developing your MS SQL database. This new version supports Excel Import,...

By: navicatgui Homepage

Shareware