Strategy One

Connect via DSN (Driver)

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

This section describes the driver configuration and the settings that are known to enhance the performance of MicroStrategy when connecting to Oracle.

How to Configure the DSN Driver

Configuration consists of three steps: (1) create a database connection, (2) create a database instance, and (3) configure and store credentials.

  1. Launch the MicroStrategy Connectivity Wizard.

  2. Choose MicroStrategy ODBC Driver for Oracle.

  3. Enter your connectivity information for the Oracle and click Finish.

  4. Open MicroStrategy Developer and go to Administration > Configuration Manager > Database Instances.

  5. Right-click the panel and select New > Database Instance.

  6. In the General tab, enter your database information.

  7. Click New.
  8. In the Database Connections dialog, click New.

  9. Create your database login and click OK.

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

  11. Go to Database Instances > SQL Data warehouses.

  12. Use the drop-down to select the primary database instance for the project. Use the Oracle DSN you created above.

  13. Click OK.

  14. Click your project, then from the navigation bar, click Schema > Warehouse Catalog.

  15. Use the dialog to retrieve tables.

  16. You can test the DSN connectivity of the database instance in Workstation. To test, you must add your environment URL to the client.

    How do I add my environment connection URL?

    1. Start the dashboard server.

    2. Copy the MicroStrategyLibrary.war to the webapps folder in your Tomcat directory.

    3. Restart the Tomcat server.

    4. Open the Library Admin page and connect the Intelligence Server.

    5. Open MicroStrategy Workstation and add a new environment connection.
    6. Click Create a New Dashboard.
    7. Click New Data.
    8. Click Database.
    9. Choose Build a Query, Type a Query, or Select Tables and click Next.
    10. Click New Data Source.

    11. Choose DSN Data Sources and select your Oracle DSN.

    12. Click Save. You should be able to successfully connect and retrieve tables.