ETL Tools

by Michael V. Cocozz » Thu, 28 Sep 2000 04:00:00

Any recommendations on ETL tools that hook into the SQL Server Repository?

1. criteria for Copy management tools / ETL-tools

Dear friends,

Considering the prices of copy management tools (CM-tools) AKA ETL-tools
from f.i. ETI, Prism and the like, I would like te have some criteria
upon which I can make my selection.

So far I came up with the following minimum functionalities:
- Extraction/replication of data from the databases from the
sourcesystems;
- Filtering en cleansing of the extracted data;
- Consolidation of the data;
- moving the data to the targetsystems;
- loading the data into targetdatabase;
- All these processes must be scheduled.

Non-functional:
- price;
- user-friendliness;
- technical openess (databases, platforms, BI-tools)

I found some info at http://www.kismeta.com/extract

Am I missing functions, are there any other criteria I should use?

TIA,

Pim Wennekes

2. Setting Permissions

3. ETL tool

4. WHERE clause help!

5. ETL Tool Selection Sagent V Informatica

6. Help with delete query

7. Looking for an ETL tool from MS SQL 2k to oracle 8i

8. Espera de recursos