December 5, 2002 at 7:31 am
I need to select an ETL tool
We build medical data marts and a few datawarehouses.
We run primarily SQL Serverbut alos use Sybase and Oracle.
We have built our own OLAP tool.
Cognos is our front end reporting tool.
I need to select an ETL tool. Any opinions or good places to start my search.
December 5, 2002 at 7:43 am
can you enlighted us dummies as to what ETL is?
Edited by - don1941 on 12/05/2002 8:35:04 PM
December 5, 2002 at 7:49 am
December 5, 2002 at 7:54 am
ETL stands for Extraction, Transformation and Loading (ETL).
A few years back around 4 now. I worked on a proof of concept using a tool called ETI Extract by Evolutionary Technology Internation (http://www.eti.com/home/home.htm).
Anyway this tool, was a point and click source to target mapping tool. After the mappings where defined you would push a button and it would generate the code. You also could customize the tool to build any kind of code you wanted. You might want to check this one out.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
December 5, 2002 at 8:36 pm
I know of several sites that use a product called Business Objects. I don't have any 1st-hand experience but it would be worth at least looking at.
December 6, 2002 at 1:59 am
Business Objects is NOT an ETL tool. Its main purpose is a reporting tool. I do know they acquired an ETL tool manufacturer : ACTA Technologies.
Don't know anything about their tool though.
Anyway, since you're using Cognos, you allready have a reporting tool. But they too have an ETL tool in their suite. I think it is called Transformation Server (but I'm not sure).
December 9, 2002 at 12:37 am
Maybe I'm looking at a small scale, but any chance DTS could help out ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 9, 2002 at 1:02 am
We developed our own ETL tool.
And have used it at several clients of use.
More info: Contact Cronos.
December 9, 2002 at 6:42 am
Good ETL tools are very costly. If your requirements are not large then using DTS is a good solution. The main difference is that a good ETL tool can allow you to produce you mechanism quickly with little manpower, whereas a bespoke DTS solution would require more man power.
HOw much data, how complex are the transforms?
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
December 9, 2002 at 11:43 am
ETL tools of the past are : DataStage now part of the Ascentials suite w/ IBM; Sagent; and Ab Initio [ a new comer] ... all above $80k Good luck
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply