Skip to main content
MySQL

Data-powered OKRs with Quantive and a MySQL integration. You can connect to any table in any schema in MySQL and create a Quantive entity.

Neli Ivanova avatar
Written by Neli Ivanova
Updated over 5 months ago

MySQL is a popular, open-source relational database (RDMBS). You can connect to any table in any schema in MySQL and create a Quantive entity based on it.

How to connect

  • In Quantive, navigate to Settings > Data Sources screen

  • Click the Select data source button

  • From the Choose a connector dialog, select the Databases tab and then MySQL

Enter the necessary information to connect to your MySQL database.

  • Host: hostname or IP address of your MySQL instance

  • Schema: the name of the schema to which you want to connect

  • Username: the name of the user with which you wish to connect

  • Password: the password of the user with which you wish to connect

  • Port: the port where MySql is listening. The default is 3306, which is a standard MySQL port

Click on the Connect button.

  • Choose a table to which you want to connect and click on the Use ... button

  • Give the name of your data source, something that makes sense to you and select the sync schedule (how often you want this data source to be synced automatically)

  • Click on the Add my data source button

  • Define who will have access and use the information in this entity to create insights and automate KRs and KPIs using the Data Source permissions

  • Click on the Finish button.

Note: Contact us for information on Quantive's outbound IPs for your account if you need to create a firewall rule to enable external access.

What data from MySQL can I use?

You can sync any field from any table in any schema that is accessible to the user with which you connected to the MySQL database.

Quantive will automatically coerce types for you, so for example date and timestamp can both be mapped to Gtmhub date type.

Did this answer your question?