GuidesConnect to Hex

Connect to Hex

Set up a MySQL database connection from Hex to your Hardal project so you can query analytics data in collaborative data science notebooks

Connect your Hardal analytics data to Hex for advanced data analysis, machine learning, and collaborative data science workflows.

Get your database credentials from Settings → Database in your Hardal dashboard.

Get Connection Credentials

Access Database Settings

  1. Log into your Hardal dashboard
  2. Select your Signal from the project list
  3. Go to Settings → Database
  4. Copy your connection details

You now have the credentials needed for Hex integration.

Connect to Hex

Create Data Connection

  1. Log into your Hex workspace
  2. Navigate to Data sources in the left sidebar
  3. Click Add data source
  4. Select MySQL from the available connectors

Configure Connection

Enter your Hardal database credentials:

  • Host: [from your database settings]
  • Port: [from your database settings]
  • Database: [from your database settings]
  • Username: [from your database settings]
  • Password: [from your database settings]

Click Test connection to verify, then Save.

Store these credentials securely and limit access to authorized team members only.

Verify Data Access

  1. Create a new SQL cell in a Hex notebook
  2. Run a simple query to test the connection: 
    SELECT COUNT(*) FROM website_event LIMIT 10;
  3. Verify you can see your Hardal data

You can now query and analyze your Hardal data in Hex notebooks.

Was this page helpful?