Profit.co enables you to integrate and connect your MySQL account and create key results via the database server of MYSQL.

You can now integrate your Profit.co account with MySQL and can manage databases. With this established integration you can now manage your database efficiently by creating key results to show progress.

Note: Only super users can perform this integration connection.

Step 1

Navigate to Settings from the left navigation panel.

Click on Integrations, On the Connectors page, Select the Business Level tab and click on the MYSQL Manage button.

all_my_okrs
integartions

Step 2

Now click on Connect to MySQl.

connect_to_sql

Step 3

Establish a connection by adding the credentials of Server, username and password from your MySQL account.

delete

Step 4

Now create the key result Using form by clicking on the Add a new key result.

using_forms

Step 5

Now select Increase KPI and add KPI for the key result and enable the integration toggle and choose MySql connection.

kr_kpi

Step 6

Once you choose the MySQL connection, a pop up will appear. The connection name will be auto populated and you have to enter the SQL Query from your MySQL profile. Now click Run.

run

Step 7

Once you click on the Run button, the Current Value will be automatically populated. Now click on Add.

add

Step 8

You have now successfully integrated your key result and From value will be automatically populated and now enter To value and click Create.

from_to

Step 9

When you check-in your key result, the value will be updated automatically.

update