» » Defining DSNs Defining DSNsAfter you install an ODBC driver, you can define one or more data sources for it. The DSN should provide a unique description of the data, for example, PayrollProjectMetadata or PayrollWarehouse.The DSN is the name for a pointer used by a client application (in this case MicroStrategy) to find and connect to a data source.
![](/uploads/1/2/6/6/126695919/180024118.jpg)
Multiple DSNs can point to the same data source and one DSN can be used by different applications.You can define a data source connection with a DSN by using:.The MicroStrategy Connectivity Wizard—configures connectivity to data sources by creating a DSN that uses a MicroStrategy-branded ODBC driver (see ).The Microsoft ODBC Data Source Administrator—creates a DSN for an ODBC driver that is not MicroStrategy-branded (see ). It is strongly recommended you use the MicroStrategy Connectivity Wizard when creating a new DSN for a MicroStrategy-branded ODBC driver. Use the Microsoft ODBC Data Source Administrator only if you intend to use a driver that is not MicroStrategy-branded.If you create DSNs using the Microsoft ODBC Data Source Administrator, you must create system DSNs. Otherwise, MicroStrategy interfaces will not recognize them. Creating a DSN for a data sourceIf a DSN does not already exist in your empty metadata repository or the repository installed with MicroStrategy, you can add or create a new one.The MicroStrategy Connectivity Wizard is a tool designed specifically to configure connectivity to data sources by creating a DSN that uses a MicroStrategy-branded ODBC driver.
To create a DSN 1If you are creating a DSN:.On Windows, perform the following steps:—Log in to the system as an administrator.—From the Start menu, point to Programs, then MicroStrategy Tools, and then select Connectivity Wizard. The Welcome page of the Connectivity Wizard opens.On Linux using the Connectivity Wizard interface, perform the following steps:—In a Linux console window, browse to HOMEPATH where HOMEPATH is the specified home directory during installation.—Browse to the folder bin and type./mstrconnectwiz, and then press ENTER. The Welcome page of the Connectivity Wizard opens.On Linux from the command line, then perform the following steps:—In a Linux console window, browse to HOMEPATH where HOMEPATH is the specified home directory during installation.—Browse to the folder bin and type./mstrconnectwiz -h, and then press ENTER.This command displays command line operation syntax and examples for different database platforms. Create your command based on the syntax and examples displayed. Once you perform your command, the DSN is created and you can skip the rest of this procedure.
For detailed steps on how to use the command line version of this tool, see in. A list of database drivers is displayed.
Create an ODBC Data Source Name (DSN) on Linux. This article describes how to create an ODBC data source name (DSN) on Linux. The example create a SQL Server data source name on Oracle Linux 7 using the EPEL yum repository. Install the ODBC driver manager and a SQL Server driver.
The list available for Windows is different than the list available for Linux. For a list of the available ODBC drivers for Windows and Linux that are certified for Intelligence Server and different DBMS types, see.3Select a database driver with which to create a DSN and click Next. The Driver Details page opens.Only a few databases can contain metadata repositories. For details, refer to the MicroStrategy Readme. Only DSNs created to connect to these databases can be used to connect to metadata repositories.
4Enter the information in the appropriate fields for connecting with the selected database driver. The information to enter varies depending on the database platform that you selected.
![Oracle odbc.ini example Oracle odbc.ini example](/uploads/1/2/6/6/126695919/911622817.gif)
For more information, see.5Click Test to verify the connection. The Test Connection dialog box opens.6Enter the User Name and Password to connect to the database.7Click Connect to test and verify the connection. If the test is performed successfully, the connection with the database is established. If the test fails, verify the correct connection information with your database administrator and make any required changes to the information you provided in the previous steps.8Click Close, and then Finish to create the new DSN. If you already have an existing DSN with the same name as the one you provided, a message box appears. You have the following options:.Select Yes to make sure the DSN points to the location you are expecting. This overwrites the existing DSN.Select No to save the DSN with a different name.9Repeat the above steps to create as many DSNs as you require.
At a minimum, create one for your metadata and one for your warehouse.Managing ODBC and data sources with Microsoft ODBC Data Source AdministratorThe Microsoft ODBC Data Source Administrator manages database drivers and data sources on Windows. The Microsoft ODBC Data Source Administrator utility creates a log with which to trace calls to data sources and to view, create, and edit DSNs. The utility is available from Microsoft and is usually included with the purchase of an ODBC driver.It is strongly recommended that you use the Connectivity Wizard when creating a new DSN for a MicroStrategy-branded ODBC Driver. Use the Microsoft ODBC Data Source Administrator only if you intend to use a non-MicroStrategy driver.If you choose to create DSNs using the Microsoft ODBC Data Source Administrator, they must be system DSNs. Otherwise, MicroStrategy interfaces cannot recognize them.To create a DSN using the Microsoft ODBC Data Source Administrator 1Log in to the machine as an administrator. This gives you the ability to create a system-wide DSN, rather than a user-specific DSN.2In most Windows systems you can access the ODBC Data Source Administrator from the Control Panel. Refer to your third-party Microsoft documentation for steps to access the ODBC Data Source Administrator tool.3Click the System DSN tab.
A list displays all the existing system data sources and their associated drivers.To view all the installed ODBC drivers, click the Drivers tab. The Create New Data Source dialog box opens.5Select the desired driver and click Finish. A driver setup dialog box is displayed.It is recommended that you select a MicroStrategy ODBC driver.
These drivers, whose names start with MicroStrategy, were installed when you installed the MicroStrategy application on the computer. 6Enter the information in the appropriate fields to create a data source for the selected database driver.The information to enter varies depending on the database platform that you selected, which is discussed in. 7Click OK to create a new DSN.
![](/uploads/1/2/6/6/126695919/180024118.jpg)