Advanced ETL Processor Pro 3.3.2.15
Updated on 15 Aug 2011
By Anthony Buckner
By Anthony Buckner
16.9 MB Safe To Install
Advertising
Specifications
License:
Time-limited trial (Free to try)
Updated:
Downloads:
324
Platform:
Windows All
Publisher:
DB Software Laboratory(more)
Website:
Unknown
User Reviews:
Other versions:
Do you like
Advanced ETL Processor Pro?
Advanced ETL Processor Pro?
Publisher's Descriptions
Advanced ETL Processor Professional is a Codeless Automation Tool.
Users can design Data transformations and Sql script add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basisBy 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.Since this software was designed to be a codeless one, you will be able to perform most of the tasks without writing even a single line of code.
Advanced ETL Processor Professional 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.
Some examples of people use this ETL tool for include:
ï¿ Extracting data from:
Multiple Delimited or Fixed width Text files
Multiple Excel files + Multiple Excel Spreadsheets
Multiple MS Access Databases
Multiple DBF Files
Any ODBC compliant database
MS Sql Server
Multiple Tablesï¿ And Loading it into:
Multiple Data Targets
Sql scripts execution before and after loading
Delimited or Fixed width Text file
MS Access Database
Microsoft Excel File
DBF File
Oracle 7-11g database
SQL server 7- 2005
Any ODBC compliant databaseï¿ Validation:
Deal With Dirty Data
Validate Post codes, Phone numbers,TAX Codes using regular expressions
Validate Date Formats
Validate Date and Time
Validate Numbers
Validate Strings
ï¿ Transformation:
Split, merge Fields
Split data and load it into diffrent tables
Add, replace, delete strings
Run custom transformations
Translate coded values
Derive a new calculated value
ï¿ Automation:
Load Data into ANY database
Export Data from ANY database
FTP Downloads and Uploads
Create or Delete directories on FTP server
Rename or delete files on FTP server
Send Emails with attachments
Receive Emails with attachments
Save attachmets
Compress files
Decomress zip files
Copy, move, rename, merge, delete files
Compare files using MD5, size or creation date
Check if file exist
Generate Reports
Execute Different part of package depending of the day of the week
Schedule packages for execution
Run bat files or execute any windows application
Edit and run SQL Scripts
Execute Packages from the command line
Add Records
Update Records
Delete Records
Add New and Update existing Records
Deduplicate Data
Sort Data
Group Data
Summarize Data
Pivot and UnPivot Data
Create surrogate keys
Run Sql script before and after loading data
Filter Source Data
Use Select Statement as a Data Source
Users can design Data transformations and Sql script add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basisBy 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.Since this software was designed to be a codeless one, you will be able to perform most of the tasks without writing even a single line of code.
Advanced ETL Processor Professional 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.
Some examples of people use this ETL tool for include:
ï¿ Extracting data from:
Multiple Delimited or Fixed width Text files
Multiple Excel files + Multiple Excel Spreadsheets
Multiple MS Access Databases
Multiple DBF Files
Any ODBC compliant database
MS Sql Server
Multiple Tablesï¿ And Loading it into:
Multiple Data Targets
Sql scripts execution before and after loading
Delimited or Fixed width Text file
MS Access Database
Microsoft Excel File
DBF File
Oracle 7-11g database
SQL server 7- 2005
Any ODBC compliant databaseï¿ Validation:
Deal With Dirty Data
Validate Post codes, Phone numbers,TAX Codes using regular expressions
Validate Date Formats
Validate Date and Time
Validate Numbers
Validate Strings
ï¿ Transformation:
Split, merge Fields
Split data and load it into diffrent tables
Add, replace, delete strings
Run custom transformations
Translate coded values
Derive a new calculated value
ï¿ Automation:
Load Data into ANY database
Export Data from ANY database
FTP Downloads and Uploads
Create or Delete directories on FTP server
Rename or delete files on FTP server
Send Emails with attachments
Receive Emails with attachments
Save attachmets
Compress files
Decomress zip files
Copy, move, rename, merge, delete files
Compare files using MD5, size or creation date
Check if file exist
Generate Reports
Execute Different part of package depending of the day of the week
Schedule packages for execution
Run bat files or execute any windows application
Edit and run SQL Scripts
Execute Packages from the command line
Add Records
Update Records
Delete Records
Add New and Update existing Records
Deduplicate Data
Sort Data
Group Data
Summarize Data
Pivot and UnPivot Data
Create surrogate keys
Run Sql script before and after loading data
Filter Source Data
Use Select Statement as a Data Source
Do you like Advanced ETL Processor Pro
Advanced ETL Processor Pro Disclamer
Please be aware FindMySoft.com accepts no responsibility for the file you are downloading. The same applies to the information provided about the software products listed.
We do not allow the inclusion of any Advanced ETL Processor Pro serial, keygen or crack and we disclaim any liability for the inappropriate use of Advanced ETL Processor Pro.
FindMySoft advises that Advanced ETL Processor Pro should be only used in accordance with the rules of intellectual property and the existing Criminal Code.
For your own protection ALWAYS check downloaded files for viruses.
We do not allow the inclusion of any Advanced ETL Processor Pro serial, keygen or crack and we disclaim any liability for the inappropriate use of Advanced ETL Processor Pro.
FindMySoft advises that Advanced ETL Processor Pro should be only used in accordance with the rules of intellectual property and the existing Criminal Code.
For your own protection ALWAYS check downloaded files for viruses.
Advertising
Popular News
The soon to be released Samsung Galaxy S3 is shaping up to be an event bigger commercial success than its predecessor, the Samsung Galaxy S2
Linux fans once again have the chance to take part in the annual Linux Foundation T-Shirt Design Contest, now in its 3rd edition
Your Rating
1.0
out
of
5
of
5
Rated By
2 Users
2 Users
Top Downloads
2.
Opera5.
Trillian8.
AIM9.
Skype10.
Ad-Aware12.
Nero13.
Google Earth14.
Picasa15.
Winamp16.
iTunes17.
RealPlayer18.
uTorrent19.
eMule20.
WinRAR21.
BitComet22.
WinZip23.
Shareaza24.
CCleaner25.
Recuva26.
Tweak UI27.
CuteFTP Home29.
Adobe Reader30.
NewsPiperBecome A Fan!
Link To Us!
Advanced ETL Processor Pro
HTML Linking Code
HTML Linking Code
Latest Reviews