دانلود Advanced ETL Processor Enterprise v6.3.10.7 x64/x86 نرم افزار ادغام دیتا و خودکارسازی کار با آن ها

By combining simple Package actions together Advanced ETL Processor Professional helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.
- Perform complex data validation and transformation
- Create Insert statements from any data-source
- Receive and process Emails
- Send Emails
- Load data from files into blob fields
- Copy, move, rename and delete files
- Automate complex business processes
- Process Excel Files
- Automate FTP Tasks
- Create and Publish Tableau TDE files
- Generate reports
- Sort and de-duplicate data
- Export all data from the database
- Create Qlik QVD files
- and much more...

Using native API for Oracle(OCI), MS SQL Server(BCP), ODBC, MySQL, PostgreSQL, Interbase/Firebird gives Advanced ETL Processor great performance - thousands of records per second, plus most of the tasks performed, without writing a single line of code.

Advanced ETL Processor Professional
Code-less Automation Tool.
Users can design Data transformations and SQL script add them to the package together with a report, file, FTP, email and many more actions and schedule them for execution on regular basis

By combining simple Package actions together Advanced ETL Processor Professional helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.

Advanced ETL Processor Professional supports complex enterprise environments including database, file, smtp, pop3 and ftp servers

Design complex data transformations and SQL scripts add them to the package together with the report, file, FTP, email and many more actions and schedule them for execution on regular basis.

Here are some key features of "Advanced ETL Processor Professional":
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