Advanced ETL Processor Professional 6.3.6.9 (Site License) (x86/x64)


Advanced ETL Processor Professional 6.3.6.9 (Site License) (x86/x64)
(x86/x64) English | File size: 144 MB

Advanced ETL Processor Professional is a straightforward and reliable piece of software designed to automate all your business processes. It saves you time so you can concentrate on the main aspects important for your company.


Connect to a repository of choice
Using this ETL utility you are able to perform complex data validation and transformation actions, create Insert statements from any data source and simply load data from files into BLOB fields.

The main window provides a number of settings for the three stages of reading, transformation and writing. This is facilitated by the main tool bar and a list of available objects.
The left panel located in the Design tab enables you to connect to whatever repository you want, then handle any kind of database be it Oracle, Microsoft Access, SQL Server, MySQL, PostgreSQL or Excel spreadsheets. The program provides a mechanism by which a number of different systems and protocols can interact in order to help you process a number of tasks from start to finish. It can handle a number of different functions and services such as processing databases, e-mail protocols and Office documents.

Integrate multiple data sources and execute SQL statements
The Maintain tab enables you to organize all the available databases, analyze ODBC drivers and start the execution agent. Also, you are able to create a new repository by selecting the application type such as Visual Importer, then specify details such as name, file and user credentials.

You can navigate to the 'Execution Log' tab if you want to analyze the activities of individual processes during their execution. It displays the file type and the description for each process.

What's more, by accessing the 'Run SQL' tab you can view all the available connections and execute your own SQL statements. This way, the utility lets you easily integrate data from multiple data sources or split data from one database to many files.

To end with
Being designed to automate everyday routine tasks, Advanced ETL Processor Professional is a reliable and effective solution when it comes to generating reports, saving attachments, sending e-mails and exporting data from any database.

FEATURES :

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

SYSTEM REQUIREMENTS :
MDAC
MS Access ODBC driver
MS Access 2007 ODBC driver
FoxPro ODBC driver
SQL ODBC driver
Interbase client
SQLITE
Oracle Client
BDE Drivers
Tableau API
Jet 4.0

Whats New:
Updates: official site does not provide any info about changes in this version

HOMEPAGE
https://www.etl-tools.com/


Advanced ETL Processor Professional 6.3.6.9 (Site License) (x86/x64)

Download From Rapidgator


https://rapidgator.net/file/00ee081365e5673993c6e3e5e73e1017
https://rapidgator.net/file/fbfa1fea4bbca9d159d42182d8b7dc0b


Download From Nitroflare


http://nitroflare.com/view/25EF39E7218DDBC/BaDshaH.Advanced_ETL_Processor_Professional_6.3.6.8_%28Site_License%29_%28x64%29.rar
http://nitroflare.com/view/036D3E983D614C4/BaDshaH.Advanced_ETL_Processor_Professional_6.3.6.8_%28Site_License%29_%28x86%29.rar


Add comment

The author will be very pleased to hear feedback about your news.

    • bowtiesmilelaughingblushsmileyrelaxedsmirk
      heart_eyeskissing_heartkissing_closed_eyesflushedrelievedsatisfiedgrin
      winkstuck_out_tongue_winking_eyestuck_out_tongue_closed_eyesgrinningkissingstuck_out_tonguesleeping
      worriedfrowninganguishedopen_mouthgrimacingconfusedhushed
      expressionlessunamusedsweat_smilesweatdisappointed_relievedwearypensive
      disappointedconfoundedfearfulcold_sweatperseverecrysob
      joyastonishedscreamtired_faceangryragetriumph
      sleepyyummasksunglassesdizzy_faceimpsmiling_imp
      neutral_faceno_mouthinnocent
reload, if the code cannot be seen

Comments 0