Description from the Publisher:
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. |
Advanced ETL Processor 2.2.3
 Free download
Most popular product from this category
Database Converter Tool
MS Access to MySQL database conversion software has the ability to translate complete or selected records of tables from one DB to other. File converting tool facilitates users to migrate cluster or non-cluster indexes, primary, unique, foreign keys.
Geodaten German Admin (Deutsch)
Geodata of the Federal Republic Germany with municipalities, postal codes, ec.
PostgreSQLDirect .NET Data Provider
An enhanced data provider for PostgreSQL-based database applications development that offers both high performance native connectivity to the PostgreSQL database and a number of innovative development tools and technologies.
Classic Menu for Access 2007
Show Classic Menus and Toolbars on the Ribbon of Microsoft Access 2007. Supports all languages that are supported by Microsoft Access 2007.
Microsoft Access Database Converter
Microsoft Access to MySQL conversion software provides simple and easy wizard style interface to migrate MS Access database server to MySQL database file format with all keys, schema, data types, values, indexes and constraints attributes etc.
xSQL Profiler
Monitor multiple SQL Servers from one location - powerful filtering and scheduling capabilities. Up and running in minutes, no agents to install. Use for performance, auditing and compliance. Supports SQL Server 2000/2005/2008.
MDB2SQL Enterprise
MDB2SQL automates Microsoft SQL Server support for Microsoft Access-based applications without the need to rewrite your existing code.
Aspose.BarCode for Reporting Services
Aspose.BarCode for Reporting Services allows rendering of barcode images in Microsoft SQL Server 2000 and 2005 Reporting Services. It supports 25 linear and 2D barcode symbologies, DPI resolution settings & rendering barcodes into image formats etc.
DreamCoder for MySQL Enterprise
DreamCoder for MySQL is a powerful software solution for MySQL Database administration and development. Our very intuitive interface will save you time and money.
MS SQL Field Box
MS SQL Field Box is a small tool which allows you to view MS SQL Server database structure and paste table or field names in your favorite editor using mouse or keyboard hotkeys. It is another way of using "IntelliSense" technology :) |
|
Home |
Submit a file |
New |
Categories |
Our awards |
Link to us |
Links
