Advanced ETL Processor 3.4.0.3
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, SQLite 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.
+ Documentation update
+ Documentation update
+ Support for Dynamic SQL for ETL transformations was introduced
- Various bug fixes
+ Support for QVX_QV_DUAL fields type was introduced
- Addressed some issues related to working with MS Sql Server Compact edition
- Various bug fixes
+ First Record flag, Last Record flag, First Record flag for file/table/sheet, Last Record for file/table/sheet were added to Reader parameter data trasformation function
+ Sequence and Running total transformation function improvements
- Various bug fixes
+ Support for themes
+ Documentation update
- Text writer unicode fixes
- Various bug fixes
- XML XSLT transformation fix
- Some auto format issues were addressed
- Minor interface tweaks
- Memory leaks and AV fixes
Added Get Variable, XML XSLT transformation, Validate XML function
Interface Update
Various bug fixes
Added clear log check box to transformation progress dialog
Added open open execution log button
Added Clone Row, Base64 Encode, Base64 Decode, GUID, Random transformation functions
Various bug fixes
This release changes the way the Data Validator works
It allows the user to validate and transform the data at the same time.
To update:
Open Data Validator and map validation rules to output fields.
Save Data transformation.
Repeat for all transformations
...Advanced ETL Processor Professional is a...Codeless Automation Tool. It transfers...or file. Complete automation of business processes...SMTP, File operations, SQL scripts, Zip and...Unzip, ETL Task scheduler and...files, Oracle, MS SQL Server, Interbase/Firebird, MySQL,...PostgreSQL, SQLite, MS SQL Server Compact or...
...Build Complex Data warehouses and Automate...Entire Business Processes Transfer Data...or file. Complete automation of business processes...SMTP, File operations, SQL scripts, Zip and...Unzip, ETL Task scheduler and...files, Oracle, MS SQL Server, Interbase/Firebird, MySQL,...SQLite or any ODBC compliant database. Since...
...Now You Can Load 14,347 Records A...Easy-To-Use Visual Importer ETL If you regularly...export, transform or load database data, Visual...Importer ETL is designed to...Using Visual Importer ETL Standard version 4.9.1.4,...you can load a delimited text...file into MS SQL Sever via BCP...around with your data to get it...
...Visual Importer ETL Enterprise is a...building high performance data integration solutions, Including...extraction, transformation, and load (ETL) packages for...data warehousing and business automation. Visual Importer...ETL Enterprise includes graphical...building and debugging automation packages; Plus automation...
...Data Exchange Wizard Loads...or export data from/into ANY database....files,XML, Oracle, MS SQL Server, Interbase/Firebird, MySQL,...OleDB, SQLite, MS SQL Server Compact or...ANY ODBC compliant database. Great...use and learn Data Exchange Wizard may...may also execute SQL statements before and...primary key distinguishes Data Exchange Wizard from...