Skip to main content

Introduction

Transform's JDBC driver enables you to issue queries and build reports in Mode Analytics using Transform's MQL query syntax. The benefits of this integration are that if you are a Mode user or plan to adopt Mode, you can be confident that the queries you are executing are coming from a single source of truth that you defined in Transform.

As a hosted Transform user, Transform manages the server necessary to connect Mode.

Transform's JDBC connector uses Apache Calcite Avatica which is the same interface as Apache Druid.

Requirements#

  • Mode Analytics Instance
  • The user setting this connection up is an admin of Mode
  • Hosted Transform Deployment with JDBC enabled

Installation Steps#

  1. Under your Mode WorkSpace, navigate to Definitions —> Data —> Bridge Connectors

  2. Enter a new Bridge Name and click Create Bridge. Use the copy button in the top right-hand corner to copy the Configuration File code snippet list underneath the bridge creation confirmation.

  3. Navigate to the Transform Metrics Catalog under Settings —> MQL Server List. In the table row with the primary MQL server, click the field value Configure Mode under the column header Integrations.

  4. A modal window will open up and you should paste your copied Configuration File from Mode into this box and press Save. Once you save your information, the server will be provisioned and this could take up to 30 minutes.

  5. Transform will send you the host and port information of your Avatica server over Slack or Email. Copy this for the following steps to complete the information.

  6. Once you receive your host and port information from Transform, Navigate to Definitions —> Data —> Manage Connections and on the upper right-hand corner of the page choose Connect a Database.

  7. Choose Apache Druid from the dropdown menu. This is the dialect that Transform's JDBC driver reads.

  8. Select the Mode Bridge that you created in the above steps to continue your Apache Druid connection.

  9. Give your connection a Name and a Description. Fill in the Host and Port information that you received from Transform. Click Connect at the bottom of the setup page.

  10. You will get a successful connection prompt upon success. Click "New report" in the success prompt and start querying your metrics!

Setting Permissions For Your Transform Connection#

  1. Under the Data section, navigate to Manage Connections and select the Bridge Connector you use to connect to Transform.

  2. Select Permissions to view and manage the permissions for this connection. By default only Admins will have permissions to use this connection.

  3. Update your permissions so the desired teams have access.