Advanced ETL Processor Professional

Name: Advanced ETL Processor Professional
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:
1643 downloads

View Screenshots(18)

Comments

Download

Liked it? Tell others:

Advanced ETL Processor Professional Tags

etl processor codeless automation automate database automation automate sql etl

Advanced ETL Processor Professional Details

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

SHA1 Hash 32bit version: c0fd0040866341f277686e7df3585ef887e54caf
Size 32bit version: 45.11 MB

SHA1 Hash 64bit version: 6d3266cc19103ec3ccc285d1a4c38cf82cc91222
Size 64bit version: 50.15 MB

Rating: 2.217391304 out of 5 based on 23 user ratings

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

Advanced ETL Processor Professional 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 Professional which is 45.11 MB in size and belongs to the software category Servers.
Advanced ETL Processor Professional 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 Professional 64bit version which is 50.15 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 Professional Description

Extraction:
Multiple Delimited or Fixed width Text files
Multiple Excel files + Multiple Excel Spreadsheets
Multiple MS Access Databases
Multiple DBF Files
Any ODBC compliant database
Full support for ODBC connection strings
OLE DB Datasource
MS SQL Server
MySQL
PostgreSQL
Interbase/Firebird
Oracle
Multiple Tables
POP3 + SSL
File System
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:
15 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 7-11g database (using OCI API)
Full support for Oracle Instant Client
SQL server 7-2008 (using BCP API)
MySQL
PostgreSQL
Interbase/Firebird
Any ODBC compliant database (Using ODBC API)
Ole DB
Full support for ODBC connection strings
Generate Sql Insert Script
SMTP + SSL
XML
File System
Oracle:
There are two ways of loading available:
Oracle direct path loading
Conventional path
SQL server:
This software uses the same API as Microsoft DTS service