官术网_书友最值得收藏!

Creating ODBC DSN for metadata and data warehouse

Now that we have two databases, we need to tell MicroStrategy how to find and how to connect to them. Being in a Windows world, all the connections are done through ODBC, 32-bit ODBC to be correct.

Tip

You should be aware of this if you happen to install MicroStrategy on 64-bit Windows—the connectivity tier runs on 32 bits, the ODBC drivers are 32-bit drivers, and you won't find them in the default 64-bit ODBC Administrator (hint: look in the SysWOW64 folder).

Getting ready

You need to have completed the previous recipe to continue.

How to do it...

We will create the two DSN:

  1. Click on Start | Administrative Tools | Data Sources (ODBC) and select the System DSN tab.
  2. You will find some DSNs already created for you by the setup; we need to create two more (yes, you're right: one for the metadata and one for the data warehouse).
  3. Click on the Add… button, scroll down the list to select SQL Server Native Client 11.0 and click on Finish.
  4. In the Create a New Data Source to SQL Server window, type these values:
    • Name: metadata
    • Server: (localdb)\v11.0
  5. Click on Next and then on Next again.
  6. Click the checkbox labeled Change the default database to and in the drop-down list underneath, select metadata. Leave all the remaining default values and click on Next and on Finish.
  7. Click on Test Data Source… and look at the message: if it says TESTS COMPLETED SUCCESSFULLY!, you're good to go. Click on OK and then on OK again.
  8. Repeat all the steps to create another DSN to the data warehouse, this time with the following values:
    • Name: datawarehouse
    • Server: (localdb)\v11.0
    • Change the default database to: AdventureWorksDW2008R2

How it works...

Every interaction with the relational DBMS is done through ODBC. MicroStrategy ships with a list of out-of-the-box drivers for the most common databases. Nevertheless, you may use other ODBC drivers if so you wish, provided that they work in 32 bits.

There's more...

In our recipes, we will connect to a SQL Server instance, so we need to use the Microsoft provided Native ODBC. If, for example, you use Oracle in your BI environment, you will find the provided Oracle Wire driver being very convenient and light-weight. The company behind the shipped drivers is DataDirect.

Note

You can watch a screencast of this operation at:

主站蜘蛛池模板: 乌兰县| 井冈山市| 赫章县| 黄陵县| 金门县| 沧源| 江安县| 建平县| 常德市| 西吉县| 闸北区| 华蓥市| 布尔津县| 西平县| 溆浦县| 平果县| 那曲县| 牙克石市| 穆棱市| 涟水县| 广昌县| 通河县| 迁西县| 兴义市| 松潘县| 特克斯县| 外汇| 赣州市| 安丘市| 北辰区| 海林市| 乌兰察布市| 古蔺县| 芜湖县| 阿克陶县| 秭归县| 太康县| 纳雍县| 磴口县| 湖口县| 蕉岭县|