Profi.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.
Navigate to Settings → Integrations → Connectors from the left navigation panel.
Click on the Manage button of MySQL integration.
Now click on Connect to MySQl.
Establish a connection by adding the credentials of Server, username and password from your MySQL account.
Now create the key result Using form by clicking on the Add a new key result.
Now select Increase KPI and add KPI for the key result and enable the integration toggle and choose MySql connection.
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.
Once you click on the Run button, the Current Value will be automatically populated. Now click on Add.
You have now successfully integrated your key result and From value will be automatically populated and now enter To value and click Create.
When you check-in your key result, the value will be updated automatically.