Oracle Autonomous Database is an all-in-one cloud database solution for data marts, data lakes, operational reporting, and batch data processing. Oracle uses machine learning to completely automate all routine database tasks—ensuring higher performance, reliability, security, and operational efficiency.

 

What you can do with Oracle Database KPI and Profit.co Integration:

1. Integrate Oracle Database fields using query in Profit.co key result and automate the progress.

Configure Oracle Database KPI in Profit.co

Note: Super Users can only configure the Oracle Database KPI integration in Profit.co.

Step 1

Navigate to Settings → Integrations → Connectors from the left navigation panel. Click on the Oracle DB Manage button.

Connectors

Then click the Connect to Oracle DB button.

Connect to Oracle DB

Step 2

Enter the Connection Name and required details and click on Connect button to successfully configure the Oracle DB Integration connection

Oracle DB with password

You can also set the Visibility by clicking the edit icon.

Manage Oracle DB Connection

Set Visibility

Step 3

Now Create a key result Using the Form in Profit.co where you want to integrate the Oracle DB in a key result.

Note: Oracle DB KPI supports Increase KPI, Decrease KPI, or Control KPI type.

Choose the required KPI.

choose required KPI

Click the Automate Check-in and choose Oracle DB from the Connection dropdown.

Automate Check-in

On the Connect to Oracle DB tab, Enter the Query and Run the query, you will get the Current Value.

Then, click Add.

Current value

Once the Key Result is successfully created, click on the Check-in button and complete the Check-in to update the status value in the key result.

status value Key results

Foot prints

If you check-in you’ll be redirected to the review page. Finally, you can Update it to make progress to your key result.

Check-in chart

Note: The automatic check-in will happen every 24 hours from the time of doing check-in.

update-key-result