What can Advanced ETL Processor Pro do?
| |
Advanced ETL Processor 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 what our customers use this ETL tool for include:
| | Extracting data from:
And Loading it into: - Multiple Data Targets
- Delimited or Fixed width Text files
- MS Access Databases
- Microsoft Excel Files
- DBF Files
- Oracle
- MS SQL Server
- MySQL
- PostgreSQL
- Interbase/Firebird
- Any ODBC compliant database
- OLE DB
Validation: 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 ALL 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
- Generate XML
- Transform Unicode Data
- Generate Sql Insert Script Using any Table or File
| | Every package execution is logged, In the event of an error, the Advanced ETL Processor generates a detailed and explanatory report, giving the user ultimate control of accuracy of the data. | |
|
