Uploaded image for project: 'Solution Center'
  1. Solution Center
  2. SOL-318

How to connect Microstrategy Analytics Desktop to an EXASOL database

    XMLWordPrintable

    Details

    • Type: Explanation
    • Status: Published
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Solution:
      Hide

      How to connect Mictrostrategy Analytics Desktop with your Exasol database:

      Prerequisites:

      First you have to download and configurate the ODBC driver:

      • Download the ODBC driver from the official Exasol Homepage.
      • Follow the instructions and install the driver.
      • Run the installed file "ODBC Data Sources Administrator"
      • Choose "System DSN" in the taskbar.
      • Add a new connection by clicking "Add" on the right side and select the EXAsolution Driver, press finish afterwards.
      • Fill in the necessary information to connect with your database:
        • Data Source Name
        • User Name, Password
        • Connection String
      • You can now test your connection by clicking the "Test connection" button at the bottom of the window.
      • If a window pops out with the text: "Test successful", you can finish the configuration by clicking "OK".

      How to create a connection to the Exasol database:

      • Run Microstrategy Analytics desktop.
      • Click "Create Dashboard" on the upper left:
      • A new window will appear, click on "Import Data":
      • Select "Database" as your data source:
      • Click on the "New connection" icon:
      • A new window will appear: Click on "DSN Connections"
      • Insert the necessary data to proceed:
        • Your DSN (the DSN name you created in your ODBC driver)
        • DBMS: EXASolution 4.x
        • Database info: User, Password
        • Name your connection.
      • Press OK afterwards:
      • The window will close and you will see your available connections under the topic "Database connections" on the upper left of your window.
      • Click on your favourite connection once and you will be connected to it.
      Show
      How to connect Mictrostrategy Analytics Desktop with your Exasol database: Prerequisites: First you have to download and configurate the ODBC driver: Download the ODBC driver from the official Exasol Homepage . Follow the instructions and install the driver. Run the installed file "ODBC Data Sources Administrator" Choose "System DSN" in the taskbar. Add a new connection by clicking "Add" on the right side and select the EXAsolution Driver, press finish afterwards. Fill in the necessary information to connect with your database: Data Source Name User Name, Password Connection String You can now test your connection by clicking the "Test connection" button at the bottom of the window. If a window pops out with the text: "Test successful", you can finish the configuration by clicking "OK". How to create a connection to the Exasol database: Run Microstrategy Analytics desktop. Click "Create Dashboard" on the upper left: A new window will appear, click on "Import Data": Select "Database" as your data source: Click on the "New connection" icon: A new window will appear: Click on "DSN Connections" Insert the necessary data to proceed: Your DSN (the DSN name you created in your ODBC driver) DBMS: EXASolution 4.x Database info: User, Password Name your connection. Press OK afterwards: The window will close and you will see your available connections under the topic "Database connections" on the upper left of your window. Click on your favourite connection once and you will be connected to it.
    • Category 1:
      3rd Party Tools - Vizualization & Analytics
    • Category 2:
      Clients, Interfaces & Drivers - ODBC

      Attachments

        Issue Links

        1. createDashboard.png
          createDashboard.png
          5 kB
        2. DSNConnection.png
          DSNConnection.png
          6 kB
        3. ImportData.png
          ImportData.png
          6 kB
        4. NewConnectionIcon.png
          NewConnectionIcon.png
          7 kB
        5. SelectDatabaseAsSource.png
          SelectDatabaseAsSource.png
          10 kB

          Activity

            People

            • Assignee:
              CaptainEXA Captain EXASOL
              Reporter:
              CaptainEXA Captain EXASOL
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: