Advanced ETL Processor Enterprise 4.2.3.6
Automate entire business processes and spend more time in the bar
Advanced ETL Processor Enterprise 4.2.3.6 Publisher's description
Advanced ETL Processor Enterprise is a business automation software. It transfers from any database into any database or file.
Complete automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, ETL Task scheduler and comprehensive logging. Works directly with Excel, MS Access, DBF and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL or any ODBC compliant database.
Since Advanced ETL Processor Enterprise is a codeless most of the tasks performed without writing a single line of code Advanced ETL Processor Enterprise is designed to automate everyday routine tasks. 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 loading is completed send email to the administrator. Every package execution is logged, If something went wrong Advanced ETL Processor Enterprise writes detailed message into the log and writes a record into rejected records file. The Enterprise version includes execution agent, which can be run as a Windows service.
Here are some key features of "Advanced ETL Processor Enterprise":
Data Sources:
* Multiple Delimited or Fixed width Text files
* Multiple Excel files + Multiple Excel Spreadsheets
* Multiple MS Access Databases + Multiple Tables
* Multiple DBF Files
* Any ODBC Compliant Database
* MS SQL Server
* Oracle
* Multiple Source Files
* Multiple Source Tables
* SQL Select Statement as a Data source
Data Targets:
* Oracle 7-11g database
* MS Sql Server 7-2008
* Any ODBC Compliant Database
* Delimited or Fixed width Text file
* MS Access Database
* Microsoft Excel File
* DBF File
* Multiple Data Targets
Loading method:
* Adding Records
* Updating Records
* Deleting Records
* Adding new and Updating old Records
* Adding new Records only
* User definable date formats
* Transformation Functions
* Execution of Sql script Before the loading
* Execution of Sql script After the loading
Transformations:
* 38 transformation functions
* String Transformation
* Number Transformation
* Date Transformation
* Multiple Date Formats
* 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
* Generating surrogate key values
* 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)
* Customised Transformation
Validation:
* 190 Validation Functions
* String Validation
* Number Validation
* Date Validation
* Time Validation
* Validation Against list of values
* Regular Expressions: Post codes, Phone Numbers, VAT Numbers ETC
Additional Transformations:
* Sorting
* Grouping
* Deduplication
* Summarizing multiple rows of data (e.g., total sales for each store, and for each region)
* Transposing or pivoting (turning multiple columns into multiple rows or vice versa)
* Other usefull features
* Full Support for Unicode
* Rejected Records File
* Transformation Log
* Command Line interface
* Data Preview
Repository:
* MS Access
* MS Sql Server
* Oracle 7-11
* MySql
* Interbase
* PostgreSQL
Advanced Objects:
* Projects
* Directories
* ODBC Connections
* SQL Server Connections
* Oracle Connections
* SMTP Connections
* POP3 Connections
* Data Transformations
* Email Templates
* Sql Scripts
* Reports Designer
* Scheduler
* Execution Logging
* Packages
* Backup Repository
* Restore Repository
Package Objects:
* Data Transformations
* Exports
* Sql Scripts
* Check Files
* Compare Files (creation date, file size or MD5)
* File Operations (copy,delete,rename,etc)
* External applications
* Email Notifications
* Ftp operations Uploads, Downloads, Create Remote directory, Delete File
* Zip (zip and unzip with password)
* Pop 3 Email receiver
* SQL Data Check
* FTP Operations
* Backup Repository
* Pause
* Check Date
* Reports
Execution Agent:
* Runs as Windows service
Limitations: 30 days trial
|
| Antivirus information |
| Downloadsky has downloaded and tested Advanced ETL Processor Enterprise on 2011-1-10 2:17:48 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 Enterprise: 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 Enterprise 4.2.3.6
