Advanced ETL Processor Enterprise

Name: Advanced ETL Processor Enterprise
Works on: windows

Windows 7 and above

Version: 5.9
Last Updated: 25 Apr 2017
Release: 11 Apr 2017
Category: Internet > Servers

Rate this software:
1628 downloads

View Screenshots(19)

Comments

Download

Liked it? Tell others:

Advanced ETL Processor Enterprise Tags

automate business transfer database codeless automation automation automate sql etl

Advanced ETL Processor Enterprise Details

Works on: Windows 10 | Windows 8.1 | Windows 8 | Windows 7 | Windows 2012
File Format: zip

SHA1 Hash 32bit version: 3ef01c420446d8e5022c907110e35fd2133fcacd
Size 32bit version: 49.19 MB

SHA1 Hash 64bit version: 054fc35a6b471515d17d2013dcf6d5538df63299
Size 64bit version: 55.89 MB

Rating: 2.130434782 out of 5 based on 23 user ratings

Publisher Website: External Link
Downloads: 1628
License: Demo / Trial Version

Advanced ETL Processor Enterprise is a demo software by DB Software Laboratory and works on Windows 10, Windows 8.1, Windows 8, Windows 7, Windows 2012.
You can download Advanced ETL Processor Enterprise which is 49.19 MB in size and belongs to the software category Servers.
Advanced ETL Processor Enterprise was released on 2017-04-11 and last updated on our database on 2017-04-25 and is currently at version 5.9.
We also have Advanced ETL Processor Enterprise 64bit version which is 55.89 MB in size and will work on x64 computers.

Thank you for downloading from SoftPaz! Your download should start any moment now. It would be great if you could rate and share:

Rate this software:
Share in your network:

Advanced ETL Processor Enterprise Description

Extraction:
Multiple Delimited or Fixed width Text files
Multiple Excel files + Multiple Excel Spreadsheets
Multiple MS Access Databases 3.0-2007
Multiple DBF/Foxpro Files
Any ODBC compliant database
Full support for ODBC connection strings
MS SQL Server
MySQL
PostgreSQL
Interbase/Firebird
Oracle
Multiple Tables
SQL Select Statements as a Datasource
File system
OLE DB
POP3 + SSL
XML
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
Transformation:
51 Transformation Functions
String Transformation
Number Transformation
Date Transformation
Multiple Date Formats
Sorting
Grouping
Deduplication
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)
Customised Transformation
Loading:
Multiple Data Targets
Delimited or Fixed width Text files
MS Access Databases
Microsoft Excel Files
DBF Files
Oracle database (using OCI API)
Full support for Oracle Instant Client
MS SQL Server (using BCP API)
MySQL
PostgreSQL
Interbase/Firebird
Any ODBC compliant database (Using ODBC API)
Full support for ODBC connection strings
OLE DB
SMTP + SSL
XML
File System
Generate Sql Insert Script
Oracle:
There are two ways of loading available:
Oracle direct path loading
Conventional path
SQL server:
This software uses the same API as Microsoft BCP/DTS/SSIS service.