Strategy One

Set Up a Data Source

To access a dataset from Strategy Workstation and use it to build reports and dashboards, you must have a data source connector and a Microsoft ODBC (Open Database Connectivity) or Oracle JDBC (Java database connectivity) driver installed on your computer.

Follow the procedures listed below to configure set up a data source.

Verify the Connector is Installed

  1. Open the Workstation page.

  2. Click Data Sources.
  3. Locate your connector in the list of supported data sources. If your connector is not in the list, contact support.

Install the Driver

To complete the data source set up, you need to install additional components.

  1. Navigate to the driver provider and download the ODBC or JDBC drivers.
  2. Save the driver files in the locations listed below.

Default Location for ODBC or JDBC Drivers and Driver Files for Windows

Strategy components require 64-bit drivers to achieve ODBC connectivity. The ODBC driver manager and support libraries are often installed in the C:\WINDOWS\SYSTEM or C:\WINDOWS\SYSTEM32 directories. Refer to the third-party documentation for the ODBC support and driver files locations.

JDBC drivers are installed in the location specified during their installation process. Save the driver files in the same location as the Strategy JDBC drivers. On a 64-bit Windows environment, these drivers are saved in C:\Program Files (x86)\Common Files\MicroStrategy\JDBC.

Default Location for ODBC Drivers and Driver Files for Linux

Strategy components require 64-bit drivers to achieve ODBC connectivity. The ODBC driver manager and support libraries are often installed in INSTALL_PATH/lib, where INSTALL_PATH is the Install Directory that you selected in the Install Wizard .

ODBC and JDBC drivers are installed in the locations specified during their installation process. Save the driver files in same location as the Strategy ODBC and JDBC drivers. ODBC drivers are located in INSTALL_PATH/lib and JDBC drivers are located in INSTALL_PATH/JDBC, where INSTALL_PATH is the directory that you selected in the Install Wizard.

Default Strategy Installation Paths

Strategy is installed by default in the file paths listed below.

Windows C:\Program Files (x86)\Common Files\MicroStrategy

Linux /opt/mstr/MicroStrategy/install

Related Knowledge Base Articles