SQL Server Performance

DataMart

Discussion in 'Analysis Services/Data Warehousing' started by pil, Mar 29, 2004.

  1. pil New Member

    Hi all,<br />As I am actually using sql-server for my thesis, I would like to know if Sql Server is able to "generate" datamarts (in any case of output) ?<br /><br />Do I have to use Reporting Services for that or Sql-Server got a service to do that ?<br /><br />Many thanks if you have something on this topic, I will really appreciate it !! [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Later !<br /><br />jP.
  2. bradmcgehee New Member

    I am not sure what you are asking.

    SQL Server, with its Analysis Services, has the ability to create and manage datamarts. And, if you like, you have the option of using Reporting Services to access that data.

    If this is not the answer you are looking for, then perhaps you can try to rephrase your question.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  3. stevefromOZ New Member

    There is a 'tool' from MSft for SQL2K and AS called SSABI (usually said 's-ah-be' and stands for Sql Server Accellerator for BI - business intelligence).

    It uses excel spreadsheets to allow user input of source data, then generates DTS packages (ie ETL code for loading DB), creates the datamarts and AS models/cubes for you also. If you go to the sql server site on msft.com, you'll find a link.

    Otherwise, as Brad has said, it's a lot of people work to actually design, build and then maintain a datamart.

    HTH,

    Steve
  4. pil New Member

    OK, many thanks for all these informations.<br />I saw on ms.com all details on DTS Services and it answers all my questions [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />I'm going to use DTS and see if it gather all my needs.<br />Thanks again and have a good day,<br />pil.<br /><br />jP.
  5. satya Moderator

Share This Page