Advanced ETL Processor Enterprise 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 Tables
- Multiple DBF Files
- Multiple Tables
- Any ODBC compliant database
- OLE DB
- MS SQL Server
- MySQL
- PostgreSQL
- Interbase/Firebird
- Oracle
- File System
- POP3 + SSL
- XML
And Loading it into:
- Multiple Data Targets
- Delimited or Fixed width Text file
- MS Access Databases
- Microsoft Excel Files
- DBF Files
- Oracle databases
- MS SQL Servers
- MySQL
- PostgreSQL
- Interbase/Firebird
- Any ODBC compliant database
- File System
- SMTP + SSL
- Insert Statement
- 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 Data from ANY database
- FTP Downloads and Uploads + SSL
- 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
- Check Disk space
- 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
- 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
- Process Unicode Data
- Generate XML
- Generate Sql Insert Script Using any Table or File
- Process EMAILS
- Send EMAILS
- Load images into database
- Export blobs into separate files
- Run as windows service
Every package execution is logged, In the event of an error, the Advanced ETL Processor Enterprise generates a detailed and explanatory report, giving the user ultimate control of accuracy of the data.
Questions?
