|
Version : 2.1.1 Size: 3312 K Price : 300 Downloads : 0 OS : Win98,WinME,WinNT 4.x,WinXP,Windows2000,Windows200 Contact : support@dbsoftlab.com Publisher: DB Software Laboratory  Download Now Buy Now |
||
| Publisher's Description | |
| Advanced ETL is a business intelligence tool that provides solution for Extracting, Validating, Transforming and Loading data between different data sources and targets. Extraction: * Multiple Delimited or Fixed width Text files * Multiple Excel files + Multiple Excel Spreadsheets * Multiple MS Access Databases * Multiple DBF Files * Any ODBC source * Multiple Tables 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: * 36 Transformation Functions * String Transformation * Number Transformation * Date Transformation * 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 * Sql scripts execution before and after loading * Delimited or Fixed width Text file * MS Access Database * Microsoft Excel File * DBF File * ODBC source (Using ODBC API) * Oracle 7-10G database (using OCI API) * SQL server 7- 2005 (using BCP API) * ODBC source (Using ODBC API) Related program search keywords :ETL,Powerful ETL tool,Oracle , MS Sql server, BCP, sql loader, ODBC, ETL, Data T |
|
|
|