Create ODBC DSN for Analysis Services

  • We will be using the data from the Sample Access database provided by Microsoft Analysis Services in our tutorial.
  • Analysis Services will connect to this Access Database thru ODBC DSN
  • Go to Start menu. Click on Settings/Control Panel/Administrative Tools/Data Sources (ODBC)
  • Go to System DSN Tab and click on Add

ODBC Data Source Administrator

  • Choose Microsoft Access Driver and Click on Finish

Create new ODBC data source

  • In the following dialog box, choose name (MSTUTORIAL) and description.
  • Next click on the Select button and choose the fileĀ  ‘C:\Program Files\Microsoft Analysis Services\Samples\foodmart 200.mdb’ and click OK.

ODBC Setup

  • In the next section we will point to this MSTUTORAIL DSN to create a Data Source for the Analysis Services.
Copyright 2005-2016 KnowledgeHills. Privacy Policy. Contact .