Advanced ETL Processor 3.3.0.11 - Detailed Description Page

Program ID:

32480

Author:

DB Software Laboratory     All programs by this author

Downloads:

320

License:

Shareware [?]

Cost:

$340.00 US

Operating Systems:

Size:

8517K

Release Status:

update

Last Updated:

2012-01-25

Our Rating:

Users Rating:

    (total votes: 0)

Feedback:

Report broken download     Report spyware [?]

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 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.

Keywords: ETL, Powerful ETL tool, Oracle, MS Sql server, BCP, sql loader, ODBC, ETL, Data Transformation, Extract Transform Load, Business Automation, Shareware, Business, Databases & Tools, DB Software Laboratory, Advanced ETL Processor

Recent Changes: + Documentation update
+ 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

Install Support: Install and Uninstall

Supported Languages: English

Additional Requirements: Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003

DTM Data Comparer 1.09.18   (2012-02-08)   update
DTM Data Comparer is a visual tool for data comparison and synchronization

DTM Data Generator 1.37.01   (2012-02-08)   update
Intelligent test data generator for database testing: SQL, text, XML output

DTM Schema Comparer 1.08.00   (2012-02-08)   update
DTM Schema Comparer is a visual database schemas comparison/synchronization tool

Viobo MySQL to MSSQL Data Migrator Bus. 1.8   (2012-02-08)   update
Small tool for MySQL data migration to MSSQL. DBA experience is not necessary.

Viobo MSSQL to MySQL Data Migrator Pro. 1.8   (2012-02-08)   update
Tidy tool to migrate data from MSSQL to MySQL. NO DBA experience is required.

Viobo MySQL to MSSQL Data Migrator Pro. 1.8   (2012-02-08)   update
Small tool for MySQL data migration to MSSQL. DBA experience is not necessary.

Viobo MSSQL to MySQL Data Migrator Bus. 1.8   (2012-02-08)   update
Tidy tool to migrate data from MSSQL to MySQL. NO DBA experience is required.

myDBR Web Reporting 3.3.0   (2012-02-06)   update
Web reporting solution for MySQL, Microsoft SQL Server and Sybase

Database Tour 6.5.1.1022   (2012-02-06)   update
Cross-database tool

Database Tour Pro 6.5.1.1022   (2012-02-06)   update
Cross-database tool with integrated report builder

• All
  • All Categories
• Audio & Multimedia
  • Audio Encoders/Decoders
  • Audio File Players
  • Audio File Recorders
  • CD Burners
  • CD Players
  • Multimedia Creation Tools
  • Music Composers
  • Other
  • Presentation Tools
  • Rippers & Converters
  • Speech
  • Video Tools
• Business
  • Accounting & Finance
  • Calculators & Converters
  • Databases & Tools
  • Helpdesk & Remote PC
  • Inventory & Barcoding
  • Investment Tools
  • Math & Scientific Tools
  • Office Suites & Tools
  • Other
  • PIMS & Calendars
  • Project Management
  • Vertical Market Apps
• Communications
  • Chat & Instant Messaging
  • Dial Up & Connection Tools
  • E-Mail Clients
  • E-Mail List Management
  • Fax Tools
  • Newsgroup Clients
  • Other Comms Tools
  • Other E-Mail Tools
  • Pager Tools
  • Telephony
  • Web/Video Cams
• Desktop
  • Clocks & Alarms
  • Cursors & Fonts
  • Icons
  • Other
  • Screen Savers: Art
  • Screen Savers: Cartoons
  • Screen Savers: Nature
  • Screen Savers: Other
  • Screen Savers: People
  • Screen Savers: Science
  • Screen Savers: Seasonal
  • Screen Savers: Vehicles
  • Themes & Wallpaper
• Development
  • Active X
  • Basic, VB, VB DotNet
  • C / C++ / C#
  • Compilers & Interpreters
  • Components & Libraries
  • Debugging
  • Delphi
  • Help Tools
  • Install & Setup
  • Management & Distribution
  • Other
  • Source Editors
• Education
  • Computer
  • Dictionaries
  • Geography
  • Kids
  • Languages
  • Mathematics
  • Other
  • Reference Tools
  • Science
  • Teaching & Training Tools
• Games & Entertainment
  • Action
  • Adventure & Roleplay
  • Arcade
  • Board
  • Card
  • Casino & Gambling
  • Kids
  • Online Gaming
  • Other
  • Puzzle & Word Games
  • Simulation
  • Sports
  • Strategy & War Games
  • Tools & Editors
• Graphic Apps
  • Animation Tools
  • CAD
  • Converters & Optimizers
  • Editors
  • Font Tools
  • Gallery & Cataloging Tools
  • Icon Tools
  • Other
  • Screen Capture
  • Viewers
• Home & Hobby
  • Astrology/Biorhythms/Mystic
  • Astronomy
  • Cataloging
  • Food & Drink
  • Genealogy
  • Health & Nutrition
  • Other
  • Personal Finance
  • Personal Interest
  • Recreation
  • Religion
• Network & Internet
  • Ad Blockers
  • Browser Tools
  • Browsers
  • Download Managers
  • File Sharing/Peer to Peer
  • FTP Clients
  • Network Monitoring
  • Other
  • Remote Computing
  • Search/Lookup Tools
  • Terminal & Telnet Clients
  • Timers & Time Synch
  • Trace & Ping Tools
• Security & Privacy
  • Access Control
  • Anti-Spam & Anti-Spy Tools
  • Anti-Virus Tools
  • Covert Surveillance
  • Encryption Tools
  • Other
  • Password Managers
• Servers
  • Firewall & Proxy Servers
  • FTP Servers
  • Mail Servers
  • News Servers
  • Other Server Applications
  • Telnet Servers
  • Web Servers
• System Utilities
  • Automation Tools
  • Backup & Restore
  • Benchmarking
  • Clipboard Tools
  • File & Disk Management
  • File Compression
  • Launchers & Task Managers
  • Other
  • Printer
  • Registry Tools
  • Shell Tools
  • System Maintenance
  • Text/Document Editors
• Web Development
  • ASP & PHP
  • E-Commerce
  • Flash Tools
  • HTML Tools
  • Java & JavaScript
  • Log Analysers
  • Other
  • Site Administration
  • Wizards & Components
  • XML/CSS Tools