Advanced ETL Processor Professional 5.7.1.3
Work with: Text, XML, Excel, Access, DBF, Foxpro, ODBC, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, SQLite, POP3, SMTP, File System, FTP, SSL, Unicode, RSS, Windows Event Log, Google Spreadsheets, SalesForce, BrightPearl and QlikView files.
Since Advanced ETL Processor Pro is a codeless most of the tasks performed without writing a single line of code
Advanced ETL Processor Pro is designed to automate complex business processes. Typical usage of it would be extract data from Excel File, Validate Date Formats, Sort data, deduplicate it and load it into the database, run stored procedure or Sql script. Once transformation is completed send email to the administrator.
Every package execution is logged, If something went wrong Advanced ETL Processor Pro writes detailed message into the log and adds a line into rejected records file.
- Addressed problems with "If in List" Function
Compare values function was added
IF Functions were introduced
Total number of functions now 500+
Comments were added to Literal function
Various bug fixes and interface improvements
Documentation update
Addressed some regular expressions bugs
Dedupicator Lookup and InLinst functions are up to 20 percent faster
Ability to link output fields was introduced
Hints were added to Lookup object
Better object selection for packages and mappings
Support for HL7 was introduced
+ Added Epoch to Date Function
+ Added Date to Epoch Function
+ Interface improvements
+ Documentation update
- Various bug fixes
+ Improved support for BDE
+ Logging improvements for Connection type, connection name and connection details
- Agent bug fixes
- Various bug fixes
- Various bug fixes
+ OLE Reports Dialog is resizable now
- Various bug fixes
+ Performance improvements for MS SQL Server Connection
+ Various Bug Fixes
+ Documentation Update
+ Documentation Update
- Fixed set variables bugs
- Various bug fixes
...Easy-To-Use Visual Importer ETL If you regularly...data, Visual Importer ETL is designed to...Using Visual Importer ETL Standard version 4.9.1.4,...file into MS SQL Sever via BCP...around with your data to get it...with almost all data formats you might...Tables * MS Sql Server * Oracle...Sql * PostgreSql *...
...Advanced ETL Processor extracts data from...of validation and transformation processes. It shows...you how the data will be transformed...loaded into the data warehouse or database...results of an ETL flow would look...like. Advanced ETL Processor can help you...extract data from an Excel...stored procedure or SQL script, once loading...
...Visual Importer ETL Enterprise is a...building high performance data integration solutions, Including...(ETL) packages for data warehousing and business...automation. Visual Importer ETL Enterprise includes graphical...building and debugging automation packages; Plus automation...of business processes such as...
...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...
...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,...PostgreSQL, SQLite or any ODBC...