The 'On-Premise DBService' in the TIBCO Flogo Database connectors connection UI field can be enabled to establish the connection to on-premise or private cloud databases. This article lists the steps on how to set up the connection to on-premise or private cloud databases for TIBCO Flogo Database connectors including TIBCO Flogo Connector for Oracle MySQL, TIBCO Flogo Connector for Microsoft SQL Server, TIBCO Flogo Connector for PostgreSQL, TIBCO Flogo Connector for Oracle Database.

Enable the DB service:

1. Log in to TIBCO Cloud Integration.
2. Enable the DB services.

• On TIBCO Cloud Web UI, users can go to Environment and Tools > Hybrid Database Connection, click the DB Services toggle.

     Note: It is suggested to disable the DB services first. This could help to load the latest DB services.

Create a DB connection connecting to the on-premise DB:    

1. Download the TIBCO Cloud Integration - Hybrid Agent

   (1) Log in to TIBCO Cloud Integration.
   (2) Go to Environment and Tools > Agents
   (3) Click New Agent and choose Hybrid.
   (4) A download dialog opens. Choose your platform from the list to download the agent binary.

2. Configure and start the Hybrid Agent using the below command:
   ==========================================
   tibagent login
   tibagent configure agent -p <Port> <Agent name>
   tibagent start agent --spec <DB-Port>:<DB-Server-IP>:<DB-Port> <Agent name>
   ==========================================
   Note:
   The agent will be running on <Port>, and the agent’s name is <Agent name>.
   Replace <Access Key secret> and <Access Key ID> with the actual Access Key secret and Access Key ID.
   Replace <DB-Port> and <DB-Server-IP> with the port and IP of the on-premise DB server.

3. Once the agent is started, create a DB connection. In the connection, set On-Premise Database to true.

Create an application connecting to the on-premise DB:

1. Configure and start the Hybrid Agent with a custom access key:
2. ==========================================
   tibagent login
   tibagent configure agent -p <Port> <Agent name>
   tibagent configure connect --accessSecret <Access Key secret> --accessKey <Access Key ID> <Agent name>
   tibagent start agent --spec <DB-Port>:<DB-Server-IP>:<DB-Port> <Agent name>
   ==========================================
   Note: This agent is not the same agent that is used by the DB service.
3. Create or edit a Flogo app that contains the Oracle connector activities in the TIBCO Cloud Integration Web UI.
4. Push the application, but don't scale up the application.
5. In the TIBCO Cloud Integration Web UI, click the app to go to its App Details page, then click "Environmental controls" > "Hybrid Connectivity".
6. Select the Access Key that is used by the agent. Click the "Push Updates" button.
7. Scale up the app.

Documentation and Article links:

1. Downloading TIBCO Cloud^™ Integration Tools
2. Installing the TIBCO^® Cloud - Command Line Interface
3. Installing, Configuring, and Running the Hybrid Agent
4. Creating or Deleting Access Keys
5. Using the TIBCO Cloud - Hybrid Agent to Connect Flogo Apps to On-Premise Databases
6. Creating an Oracle MySQL Connection
7. Creating a Microsoft SQL Server Connection
8. Creating a PostgreSQL Connection
9. Creating an Oracle Database Connection