SQL Server Performance

Third party tools for data warehousing

Discussion in 'Analysis Services/Data Warehousing' started by riya, Sep 7, 2005.

  1. riya New Member

    Can you please let me know what are best Third party tools for data warehousing ?


    Regards

    Riya
  2. satya Moderator

    There is no straight answer for this question, as the DW is a huge task and if you can assign what issues you're facing with SQL Analysis Services then we can look at it to resolve.

    Also search under Third party tools section for further information.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. johnson_ef Member

    Riya,

    We can use Analysis Server from Microsoft front.

    Instead of that, I knew something related to that even though its very huge area,

    These are the tools which you can check it.

    Cognos http://www.cognos.com/),
    Informatica http://www.informatica.com/)
    Business Objects http://www.businessobjects.com/ )

    -Johnson
  4. mmarovic Active Member

    Third party tool for what? ETL tool, OLAP server, OLAP client, Report server, data mining tool...
  5. ranjitjain New Member

    Riya,
    Cognos, proclarity all these tool provides you with the dashboard tool.
    For presentation of cubes data you can use them so that you dont have to write MDX queries. These tools itself codes them in the background.
    For ETL SQL SERVER DTS is best in many ways.
    You can even full process your Analysis Server Database.
    So you better refine your question with what as asked by Mirco.
  6. Raulie New Member

    Just to name a few major players in the DW 3rd party world.

    ETL:
    -Informatica
    -Oracle Warehouse Builder
    -Ascential DataStage
    -Cognos decisionStream

    OLAP/BI:
    -MicroStategy
    -ProClarity
    -Business Objects
    -Hypherion

    In ETL Informatica and OWB are the big dogs and for BI it's MicroStrategy and Business Objects of course there are dozens more to choose from.

    This is a DW Forum for strictly SQL Server so I don't think it is appropriate to discuss each one them in detail. I would recommend you contact the Sales Reps for these products to get further details on them.

    The advantage that SQL Server has here is that the ETL/BI products come free as part of the product. SQL Server's DW products currently are ideal for Small to MidSize DW environments, correction there are existing Terabyte warehouses running on SQL Server 2000 hopefully this trend will increase with the advent release of 2005. We currently use SQL Server to build and house our downstream DataMarts which pull from our Enterprise DataWarehouses that feed into our cubes.

    License fees for a product such as Informatica are very costly, however Informatica is a top choice when you are pushing the limits in your ETL.




    Raulie


Share This Page