Advanced ETL Processor 32 Bit v.


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, SQLite, QVD, QVX, Salesforce, Brightpearl,RSS Google Spreadsheets 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.

Move data between any database automatically. Advanced ETL Processor 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.

etl, powerful etl tool, oracle, ms sql server, bcp, sql loader, odbc, data transformation, extract transform load, business automation

  • Advanced ETL Processor 32 Bit
  • 17 May 20
  • DB Software Laboratory Limited
  • Win2000, WinXP, Win7 x32, Win7 x64, Windows 8, Windows 10, WinServer, WinOther, Windows2000, Windows2003, Windows Server 2000, Windows Server 2003, Windows Server 2008, Windows Server 2008r2, Windows Server 2012, Windows Tablet PC Edition 2005, Windows Media Center Edition 2005, WinVista, Windows Vista, WinVista x64
  • Shareware
  • 15.79 Mb
  • 1815
  • $340.00
Latest Versions History
Version Date Released Release Notes 10.03.2020 + Added: colors to notes + Added: "Complex JSON" check box to JSON datasource - Fixed: issues with aborting joiner tranformation on error + Added: Support for PostgreSql 12 22.01.2020 + Added: IMAP4 as data writer connection - Fixed: IMAP4 reader shows UID correctly now 17.11.2019 - Fixed: SplitRegX transformation function bug - Fixed: Lookup transformation function bug 10.10.2019 + Added: Select Objects with no links menu option + Added: Select Inputs menu option + Added: Select Outputs menu option + Added: Select Linked Objects menu option 16.09.2019 + Added: Ability to pull license from the license server - Fixed: Last record flag issue for files with two lines 26.08.2019 + Added: Case sensitive option to Lookup transformation object - Fixed: Issues with joining empty files 11.05.2019 + Added: Syslog datasource - Fixed: JSON Data reader AV 22.04.2019 Improved: Software Installation Process Improved: Thrird Party Components Update Fixed: Minor Python Integration Issues 04.09.2018 + Added: Loading data into Google Spreadsheets + Improved: JSON null values handling + Improved: Third party components update + Improved: transformer fields metadata - Fixed: Issues with loading data into Varchar(MAX) fields (SQL Server) 08.08.2018 + Added: Added Get Excel Cell Value Dynamic transformation function + Improved: Object selection visibility + Improved: Third party components update 17.07.2018 + Improved: Up to two times faster loading data into SQL Server - Added: Support for TLS 1.2 SQL Server connections + Improved: Made Calculation dialogue box resizable - Fixed: Issues with exporting data into csv and tab files from grids 15.06.2017 + Added : Support for SFTP Private Keys - Fixed : Issues with QVX Files reading 21.05.2017 - Fixed : Issues with loading version info - Fixed : Tableau Datetime fields processing issues - Fixed : Fixed QVD reading issues 07.01.2017 + Improved: Query Builder components update + Improved: SSL components update + Added : FTP Files list as datasource 27.08.2016 + Improved : MySQL Error handling - Fixed : BDE Datasource issues - Fixed : Problems with reading delimited text files when delimiter is more than one character log - Fixed : Problems with clone row transformation object - Fixed : Problems with reading data from Salesforce 24.07.2016 + Improved : JDBC Processing + Improved : JDBC Errors Handling - Fixed : Problems with reading data from unicode files - Fixed : Problems with AM/PM Date conversion 29.05.2016 + Third party components update + Support for the new functions introduced in the Excel 2016 January Update + New : Support SSL v2, v3, v1_1 and v1_2 was introduced + New : Support for opening xls versions from 2 to 4 13.05.2016 - Address issues with Change Date Static,Change Date Dynamic and If WeekDay functions - Addressed Salesforce data update issues

Review Advanced ETL Processor 32 Bit

  • captcha

Other software of DB Software Laboratory Limited
  • Active Table Editor  v. 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 ...
  • Advanced ETL Processor 64 Bit  v. ETL Processor 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 32 Bit  v. Complex Data warehouses and Automate Entire Business Processes, Transfer data from ANY Database into ANY Database or file,Use FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, Task scheduler and comprehensive logging.

New Database Management software
  • Advanced Data Generator  v. test data generator tool with data library to generate life like data. Ability to generate complex data for volume testing, demo data for presentations or performance testing.
  • Geodata Germany  v.25.00The database contain geodata of the Federal Republic of Germany with geo referenced towns, municipalities, town quarters, administrative units, postal codes, telephone preselections, nature areas, landscapes, climatic zones for proximity searches ec.
  • DataNumen SQL Recovery  v.5.2DataNumen SQL Recovery is a powerful tool to repair and recover corrupt SQL Server MDF database files.
  • Cisdem ContactsMate for Mac  v.5.6.0Cisdem ContactsMate for Mac can manage, edit and fix dozens of problems from mac contacts, also export Mac Address Book to some formats for easy backup or sync.
  • FeyWriter  v.3.9.0FeyWriter is a most efficient CD/DVD burning software that includes plenty of features and options for saving any type of data. It can be used by anyone regardless of their experience and offers data and audio burning, dual-layer DVD and disc images.
  • Canvas Draw for Mac  v. your workflow with a diverse content creation tool able to combine adaptable text, image, object, and effect elements in a single document.