- Business Intelligence with MicroStrategy Cookbook
- Davide Moraschi
- 404字
- 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
- Name:
- 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
- Name:
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.
- 新中國審計制度變遷
- Mastering System Center Configuration Manager
- Big Data Visualization
- 項目管理（第二版）
- Securing Hadoop
- Microsoft Dynamics CRM 2011 Scripting Cookbook
- Team Foundation Server 2013 Customization
- 風險導向審計準則實施效果研究
- 高級計量經濟分析及Stata應用
- 項目管理實務（第二版）
- 計量經濟學理論與應用：基于Eviews的應用分析
- Building Dashboards with Microsoft Dynamics GP 2016（Second Edition）
- 審計定價問題研究
- 審計學
- 績效考核與薪酬激勵精細化設計必備全書