Post reply

ETL tools

  • December 5, 2002 at 7:31 am

    #58215

    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

    #443281

    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

    #443283

    http://www.datawarehousing.com/papers/MimnoArticle.pdf

  • December 5, 2002 at 7:54 am

    #443285

    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

    #443400

    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

    #443422

    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

    #443701

    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

    #443703

    We developed our own ETL tool.

    And have used it at several clients of use.

    More info: Contact Cronos.

    http://www.cronos.be

  • December 9, 2002 at 6:42 am

    #443727

    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

    #443821

    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