Advanced ETL Processor 3.2.2.16
Extract, transform, validate and load data into ANY database
Advanced ETL Processor 3.2.2.16 Publisher's description
Advanced ETL Processor will extract data from any database, transform, validate it and load 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.
Here are some key features of "Advanced ETL Processor":
* Multiple Delimited or Fixed width Text files
* Multiple Excel files + Multiple Excel Spreadsheets
* Multiple MS Access Databases
* Multiple DBF Files
* Translating coded values (e.g., if the source system stores 1 for male and 2 for female, but the warehouse stores M for male and F for female)
* Deriving a new calculated value (e.g., sale amount = qty * unit price)
* Joining together data from multiple fields
* Summarizing multiple rows of data (e.g., total sales for each store, and for each region)
* Generating surrogate key values
* Transposing or pivoting (turning multiple columns into multiple rows or vice versa)
* Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)
* Customized Transformation
Limitations: 30 days trial period
|
| Antivirus information |
| Downloadsky has downloaded and tested Advanced ETL Processor on 2011-1-10 1:30:03 with some of Today's best antivirus engines and you can find below, for your convenience, the scan results: |
| Kaspersky: | Clean |
| NOD 32: | Clean |
| Bitdefender: | Clean |
|
| NO SPYWARE |
| NO ADWARE |
| NO VIRUSES |
|  Advanced ETL Processor: does not contain any adware or spyware, certified by download sky. |
|
| Related press releases |
Advanced Usability, Productivity and Flexibility in Report Sharp-Shooter 5.0. [2010-12-3 22:38:01]
11/23/2010 - Perpetuum Software LLC announces the release of Report Sharp-Shooter 5.0. Report Sharp-Shooter is a .Net reporting tool for the creation of reports for Windows Forms, ASP.NET and Silverli... |
| Abacre Limited announces the release of new major version 6.0 of Advanced Find and Replace software [2010-11-9 17:34:29]
St. Petersburg, Russian Federation - October 28, 2010 - Abacre Limited announces the release of new major version 6.0 of Advanced Find and Replace software
Save Precious Time Searching and Replacing ... |
| Clock-on-Tray 2010 Combines Advanced Tray Clock with PIM Features [2010-9-29 16:09:53]
A new personal information manager lets users track time and manage events, tasks and notes from the system tray
Sept. 7, 2010 – Posibolt Software today introduces Clock-on-Tray 2010, a full-featured... |
| More advanced options and whois servers database update with new SoftFuse Whois 2.6! [2010-6-25 13:09:03]
What if you want to get all detailed information about a specific domain name? Administrative, technical or billing contacts of the domain owner, domain's IP, hosting provider, creation date, expirati... |
| Moyea PlayerBox 2.0 Comes with New Pricing and Advanced Settings [2009-12-14 14:15:25]
On October 20, 2009, Moyea Software announced Moyea PlayerBox 2.0 with more advanced settings and flexible pricing. You can now present the output player by the free edition of Moyea PlayerBox to your... |
| New Scrapbook MAX 2.0 Digital Scrapbooking Software Combines Ease of Use with Advanced Graphics Technology [2009-11-13 11:29:23]
(WINNIPEG) - Scrapbook MAX 2.0 is the first digital scrapbooking software program to combine the latest advances in precision graphics technology with an interface designed specifically for digital sc... |
| Digital Flow Software Announces Release of Advanced DHTML Popup Pro 2.50 [2009-11-10 9:59:16]
Fully updated, powerful Advanced DHTML Popup 2.50 boasts both enhanced functionality and an upgraded user interface. The program is available in both professional and lite versions.
October 10 2009... |
| Advanced SMTP Server is a local SMTP server program for Windows [2009-10-29 16:40:26]
Advanced SMTP Server is a system-tray local SMTP server program for Windows that lets you send email messages directly from your computer to recipient mailboxes. Along with a subscription-based mass m... |
| K7 Computing Launches K7 TotalSecurity Version 10.0 with Advanced Protection Features [2009-8-20 17:01:51]
19th August 2009, Chennai, India – K7 Computing, one of the leading Information Security companies, recently announced its release of K7 TotalSecurity Version 10.0, an Internet Security Software with ... |
| AnyGantt: Advanced Gantt Editing Capabilities Now Available at a Reasonable Price [2009-8-4 11:56:27]
AnyChart has introduced the new version of its comprehensive charting solution AnyGantt, enabling creation of interactive and informative Gantt charts supporting animation. The new version delivers a ... |
|
|
|
| CacheDir |  CacheDir displays the contents of the Microsoft Internet Security and Acceleration (ISA) Server 2004 cache. Using CacheDir.exe, you can mark items as obsolete, which should not be served from the cache.
You can use this |
|
| BitNami SugarCRM |  BitNami SugarCRM is a professional application which allows users to manage their customers relationships.
SugarCRM can easily be customized and integrated with other software to allow companies to build a |
|
| Web Log Suite |  Web Log Suite is a GUI / command line powerful log analyzer. Highly detailed and easily configurable reports can be generated in various languages output to screen, email, ftp, file or network directories.
It will give |
|
| DBComparer |  DBComparer is a handy and reliable utility designed to find the differences between two two databases and to update the target database.
DBComparer is completely portable and easy to use. Just run the exe file and start |
|
| Connected Field |  You can now create cascading master-detail relationships between two or more lookup fields in SharePoint lists and document libraries. Filter your city column values by the selected country, it is as easy as it should be |
|
| Smart List Lite |  Make benefit of all the features of Smart List Pro for free! Add tab and column permissions, custom input validation, view permissions and more. This product is not limited in functionality, only in the number of rules y |
|
| CompactView |  CompactView is a simplem, accessible and very easy-to-use tool that was designed specifically for viewing Microsoft SQL Server Compact Edition (SQLCE) database files.
Now you can make use of this handy tool to view and |
|
| JumpBox for the Alfresco Content Management System |  Alfresco is an Open Source Enterprise Content Management (ECM) system that provides features for Document Management, Collaboration, Records Management, Knowledge Management, Imaging and content management.
With the Jum |
|
|
Servers 
Advanced ETL Processor 3.2.2.16
