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

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:

主站蜘蛛池模板: 富顺县| 宁德市| 黔南| 从江县| 通州区| 罗田县| 沙雅县| 榕江县| 莱阳市| 青海省| 河源市| 威海市| 武邑县| 合肥市| 会昌县| 新河县| 龙胜| 新泰市| 嫩江县| 宜城市| 曲阳县| 岳阳县| 长海县| 墨脱县| 泽普县| 迁西县| 宁德市| 龙江县| 卓资县| 宣城市| 九江市| 保康县| 佛冈县| 东乡| 清原| 波密县| 通江县| 长岭县| 阿尔山市| 西安市| 临颍县|