|
|
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)
Anti Virus Report
Download Advanced ETL Processor (3.2 MB) |
Released by DB Software Laboratory
Last updated: 2008-01-16
|
|
|
Active BI Portal is business intelligence software that provides an integrated solution for designing and deploying reports and web forms over the internet and intranet. Active BI Portal works with all major commercial and open source databases.
|
|
|
This Easy to use tool allows user to connect to any database and browse or modify data ,run sql scripts, export and print data.
|
|
This Easy to use tool allows user to connect to any database and browse or modify data ,run sql scripts, export and print data. And the most important thing it is Freeware.
|
|
|
This Wizard helps you to load and export data from/into various datasources such as delimited and fixed width files or ODBC data source into/from Oracle, MS SQL Server or any ODBC compliant database
|
|
|
This ActiveX helps you to load and export data from/into various datasources such as delimited and fixed width files or ODBC data source into/from Oracle, MS SQL Server or any ODBC compliant database
|
|
|
Powerful ETL Tool. Loads data into Oracle,SQL Server,ODBC from flat files, cross tables, ODBC or Excell.
Very fast and reliable.Capable of performing calculation during import, may also execute SQL statemts before/after import.
|
|
Powerful ETL tool. Imports data into Oracle ,SQL Server, ODBC Databases (Datawarehouses) from flat files or ODBC datasources.
Very fast and reliable. Uses naitive API.
Repository: MS Access, Oracle, MS Sql Server, Interbase, MySql, PostgreSQL
|
|
|
Powerful ETL tool. Imports data into Oracle ,SQL Server, ODBC Databases (Datawarehouses) from flat files or ODBC datasources.
Very fast and reliable. Uses naitive API.
Repository: MS Access, Oracle, MS Sql Server, Interbase, MySql, PostgreSQL
|
|
Loads data into Oracle,SQL Server,ODBC from flat files, cross tables or ODBC.
Very fast and reliable. Uses naitive API (OCI API,BCP API,ODBC API) Capable of performing calculation during import, may also execute SQL statemts before/after import.
|
|
|
Advanced ETL is a business intelligence tool that provides solution for Extracting, Validating, Transforming and Loading data between different data sources and targets.
|
|
