爱尔兰精灵网址进入

書(shū)名： Business Intelligence with MicroStrategy Cookbook
作者名： Davide Moraschi
本章字?jǐn)?shù)： 404字
更新時(shí)間： 2021-07-23 15:31:59

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:

Click on Start | Administrative Tools | Data Sources (ODBC) and select the System DSN tab.
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).
Click on the Add… button, scroll down the list to select SQL Server Native Client 11.0 and click on Finish.
In the Create a New Data Source to SQL Server window, type these values:
- Name: metadata
- Server: (localdb)\v11.0
Click on Next and then on Next again.
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.
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.
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:

http://at5.us/Ch1V10

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

Business Intelligence with MicroStrategy Cookbook