MicroStrategy ONE

Connect via DSN (Driver)

For both analytical requests and MicroStrategy metadata operations, MicroStrategy Secure Enterprise uses the MicroStrategy ODBC Driver for Db2 Wire Protocol. This driver is shipped with MicroStrategy releases.

Configuration consists of three parts: (1) Creating a new database instance, (2) Creating a database connection that points to the DSN, and (3) configuring and storing credentials for the login.

Create a DSN

  1. Launch the MicroStrategy Connectivity Wizard.

    • For Linux: [MicroStrategy Installation Folder] /BIN/Linux/bin/mstrconnectwiz

    • For Windows: [MicroStrategy Installation Folder] /BIN/x64/MAMDCW.exe

  2. Click Next.
  3. Choose MicroStrategy ODBC Driver for Db2 for Linux, UNIX, and Windows.

  4. Click Next.
  5. Enter your connectivity information for Db2 and click Finish.

Create a New Database Instance

  1. Launch MicroStrategy Developer.

  2. Create a new database instance.

  3. Enter the database information.

     

  4. Under Database connection, click New.

  5. Under Default database login name, click New.

  6. Right-click your project and select Project Configuration.

  7. Go to Database Instances > SQL Data warehouses and select the Primary Database Instance for the Project (Db2).

  8. Click OK.
  9. Select your project again and go to the navigation bar to choose Schema > Warehouse Catalog. Ensure connection is successful.

  10. Test the connectivity of the database instance using Workstation. If your environment has been prepared in Server Mode, skip steps 1 - 3.
    1. Start the dashboard server.
    2. Copy the MicrostrategyLibrary.war file and restart the Tomcat server.

    3. Connect to the Intelligence Server in the Library Admin panel.

    4. Add a new environment connection in Workstation and log into your project.

    5. Next to Datasets, click Add External Data.
    6. Choose Database > Select Tables.
    7. Click Next.
    8. Click Add Data Source.
    9. Select DSN Data Sources.
    10. Enter the database information and click Save. You should successfully connect to the data source.