Results 1 to 3 of 3

Thread: Analysis Services Newbie Question re: Data Sources

  1. 04-21-2007, 01:19 PM #1
    e-vincent
    e-vincent is offline Registered User
    Join Date
    Apr 2007
    Posts
    16

    Analysis Services Newbie Question re: Data Sources

    Which "data source" option in SSAS is best when hitting data contained in the MSSQL Server 2005 RDBMS? Also, assuming that it is not "ODBC," how does the best option differ from ODBC?

    I'm a newbie to AS, just getting started, and trying to correlate the concepts with my Oracle (minimal) and DB2 (a little more) experience, as I need to get up to speed on SSAS for a new client project ...

    Thanks!
    Reply With Quote Reply With Quote
  2. 04-21-2007, 06:46 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Better to use native sql client.
    Reply With Quote Reply With Quote
  3. 04-23-2007, 12:56 PM #3
    Island1
    Island1 is offline DBJ Author
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    Data Source Selection, Etc.

    First of all, congratulations for choosing the integrated Microsoft BI solution! You will find that it meets, and very often exceeds, the capabilities of any integrated solution on the market today.

    The data source option for your needs will be the default, SQL Native Client. SQL Native Client is designed to leverage the power of MSSQL Server 2005, and, to answer your extended question further, acts to combine the features of the ODBC and OLE DB providers that preceded it.

    Let us know how you’re new project progresses!

    Bill
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules