Access via ODBC
      Back to home
      1. Zetaris Support - Knowledge Base
      2. Connecting to Zetaris
      3. Access via ODBC

      Setup ODBC Driver

      How to connect to Zetaris via ODBC.


      To connect through ODBC, you will need to install the ODBC driver.

      ODBC is available for Windows clients only

      Resources

      Download  resources:

      If unable to access the above link due to network/firewall blocks, or other reasons, please contact your Zetaris representative.


      Installing the Zetaris ODBC Driver

      To connect through ODBC, you will need to install the ODBC driver.

      1. Download the Zetaris ODBC .exe file (use resource link at the top of the page).

      2. Run the ODBC installer, check “Zetaris Networked Data Platform ODBC Driver” and install in the default directory.

      3. Open the ODBC Data Source Administrator (64 bit) by searching for “ODBC data source” in the search terminal.

      4. Add Zetaris Data Fabric in User DSN.

        • Select User DSN

        • Select Add…

        • Select Zetaris Networked Data Platform

        • Select Finish

      If the Zetaris driver does not exist when creating new data source, or error messages occur when adding, then uninstall the ODBC driver and reinstall.

      5. Configure Zetaris ODBC Connection.

      Field

      Value

      DSN Name

      Name your ODBC connection, this can be anything

      Server Host

      Zetaris server IP address

      Port

      10000 (default)

      Username

      Zetaris Username

      Password

      Zetaris Password

      6. Select “Connect”, to confirm connection, then select “OK”.

      The ODBC driver has now been installed.

      Configuring the Power BI Direct Query connection

      To connect through Zetaris MEZ after configuring ODBC, follow these steps:

      1. Download the Zetaris .mez  file from the resource link provided above.

      2. Create two new nested directories in Documents.
        1. Create a folder named "Microsoft Power BI Desktop" in Documents (C:\Users\[user]\Documents\Microsoft Power BI Desktop).
        2. Within the "Microsoft Power BI Desktop" folder, create another folder named "Custom Connectors" (C:\Users\[user]\Documents\Microsoft Power BI Desktop\Custom Connectors).
      3. Copy and paste the downloaded .mez  file into the "Custom Connectors" folder.
      4. Restart or launch the Power BI application to ensure that the changes take effect.
      5. Now, you need to change the data extension settings in Power BI. Follow these steps:
        1. File > Options and Settings> Options.
        2. Select “Security”.
        3. Under “Data Extensions”,check the box that reads,“(Not Recommended) Allow any extension to load without validation or warning”.
        4. Select“OK”.
      6. Close Power BI and relaunch the application to apply the updated security settings.
      7. After relaunching, go to "Get Data" and search for "Zetaris".
      8. Select the "Zetaris Data Fabric" connector from the options.

      9. To establish the connection, you will be prompted to enter the following information:

        1. Zetaris Server IP Address (provided by the Zetaris team).
        2. Port: 10000 (the default port for Zetaris).
        3. User credentials (username and password) to authenticate and access the data on the Zetaris server.

      By following these steps, you should be able to connect to Zetaris in Power BI  using "DirectQuery" and not "Import" and start utilising the data from the configured ODBC source.