Creating a DSN for a Data Source

After you install an ODBC driver (see Connecting to Databases and Data Sources), you can define one or more data sources for it. The DSN should provide a unique description of the data, for example, Payroll_Project_Metadata or Payroll_Warehouse.

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. Multiple DSNs can point to the same data source and one DSN can be used by different applications.

MicroStrategy provides a one-line command line version of the MicroStrategy Connectivity Wizard to create DSNs on Linux.

You can create DSNs using the MicroStrategy Connectivity Wizard on Windows and Linux machines, as described in Communicating with Databases.

To create a DSN on Linux from the command line

1. From a Linux console window, browse to HOME_PATH, where HOME_PATH is the directory that you specified as the home directory during installation.
2. Browse to the folder bin.
3. Type mstrconnectwiz -h, and then click Enter to display command line syntax and examples for different database platforms.

4. Create your command based on the syntax and examples displayed. For example, the command below creates a DSN for an Oracle database and tests login credentials:

   mstrconnectwiz ORCLW MyOracleDSN 12.34.56.78 orcl 1521 -u:OracleUser -p:OracleUserPasword