| Popularity: |  |

Publisher's 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.
Advanced ETL Processor works directly with Excel, MS Access, DBF and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL or any ODBC compliant database.
Another benefit of using Advanced ETL Processor its unique ability to load data from multiple files or even tables using mask
If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.
Size: 8.32MB
Cost: $340.00
| Advanced ETL Processor Update Alert |
|
|
| We will only send you email if a new version of Advanced ETL Processor is available. We respect your right to privacy. You may unsubscribe at any time. |
|
What's New in this Release: 7 new ETL Transformation functions were added
In Place Replace
Encode Xml Element
Decode Xml Element
Encode Xml Attribute
Decode Xml Attribute
Encode Xml String
Decode Xml String
Total number of Data transformation functions is now 48
Documentation Update+minor bug fixes
Platform: WinXP,Windows2000,Windows2003,Windows Vista Ultimate,Windows Vista Ultimate x64,
License: Free To Try
Category:
Business::Databases & Tools
Date Added: Jan 14, 2009
Last check for an update: Mar 18, 2010
Last version date: Feb 25, 2010
Downloads Total : 1
Downloads last 10 Days: None
Page Visit: 15
Malware Status: Clean
Link to Advanced ETL Processor sample code
Table2Text |
Command line Utility. Exports data from any table via ODBC into text file. Great performance - thousands of records per second. Usage example table2text.exe DSN=odbcdsn;USER=username;PASSWORD=password;FILE=c:\test.csv
Visual Importer Enterprise |
Visual Importer Enterprise automates loading data into ANY Database from ANY Database or file. Plus automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip. Works directly with most Databases
Database Browser |
This Easy to use tool allows user to connect to any database and browse or modify data ,run sql scripts, export and print data. Works directly with Oracle, MS SQL Server, Interbase, MySQL and PostgreSQL plus full support for ODBC connection strings.
Data Exchange Wizard |
Data Exchange Wizard Loads or export data from/into ANY database. Full support for Excel, Access, DBF and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL or ANY ODBC compliant database. Thousands of records per second
VImpX |
Integrate VimpX Data import routine into own software package and save thousands on development. VImpX works directly with Excel, Access, DBF, Text files, Oracle, MS SQL Server, PostgreSQL, MySQL, Interbase plus any ODBC compliant database.
Advanced ETL Processor Professional |
Advanced ETL Processor Pro extracts data from any database, transforms, validates it and loads into another database completely automatically. At any time, you can press the ?Preview' button and see what the results of an ETL flow would look like.
Advanced ETL Processor Enterprise |
Advanced ETL Processor Ent transfers data from ANY Database into ANY Database or file. Complete automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, Task scheduler and comprehensive logging.
Visual Importer Professional |
Visual Importer Professional loads data into ANY Database from ANY Database or file. Plus automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip. Works directly with most Databases
Active Table Editor |
Design Data Entry Screens and Edit ANY table in ANY Database with ease. Control what users can edit and see. Design menus, Input forms, define security roles. Easy to use and highly customizable
DEWizardX |
Import/Export Routine is an essential part of any modern software application. By using DEWizardX you can cut a cost of development by thousands.
Active Business Intelligence Portal |
Active BI Portal is business intelligence software that provides an integrated solution for designing and deploying reports and web forms over the internet and intranet. Active BI Portal works with all major commercial and open source databases.