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, de-duplicate it and load it into the database, run stored procedure or Sql script. Once loading is completed send email to the administrator.
Extracting data from:
- Multiple Delimited or Fixed width Text files
- Multiple Excel files + Multiple Excel Spreadsheets
- Multiple MS Access Databases
- Multiple DBF Files
- Multiple Tables
- OLE DB Datasource
- Any ODBC compliant database
- MS Sql Server
- Oracle
- MySQL
- PostgreSQL
- Interbase/Firebird
- POP3 + SSL (Receives Emails)
- File System
- XML
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
- Email Server (Sends Emails)
- OLE DB
- File System
- XML
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 different 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 attachments
- Compress files
- Decompress 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
- Check disk space
- Debug packages
- 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
- De-duplicate 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
- Load files into the database
- Export blob data into separate files
- Extract Emails
Every package execution is logged, In the event of an error, the Advanced ETL Processor Professional generates a detailed and explanatory report, giving the user ultimate control of accuracy of the data.
Questions?
