1.Login to TIBCO® Cloud Integration (TCI)

2.Download the TIBCO Cloud - Hybrid Agent

[A] Login to TIBCO Cloud Integration.

[B] Select the Integration domain and launch.

[C] Click the Environment and Tools --> Agents

[D] Click on New Agents -> Hybrid [Choose platform and hit download]

[E] Store tibagent executable in a new folder on your machine

3.Make sure your on-premise database is up and running.

4. In TIBCO® Cloud Integration create a new access key-value pair for the user. Remember to save the access key-value pair. For step-by-step instructions see Creating or Deleting Access Keys in the online help at this URL: https://account.cloud.tibco.com/cloud/docs/proxy-agent/creating_access_key.html

5. Now enable dbservice on TCI. Following are the steps:

[A] Launch TCI -> Ennvironment and Tools
[B] Select Hybrid database Connection
[C] Select Enable and choose the access key that was created


 

6. Configure and start tibagent. Following are the commands:

• Configure tibagent.

command: tibagent configure agent <agent name>

• Configure agent with access key and access secret created in Step 4.

command: tibagent configure connect --accessSecret <accessSecret> --accessKey <accessKey><agentName>

• Start tibagent

command:  tibagent start agent --spec 3306:localhost:3306 <agentName>

7. Once tunnel starts, go to the TIBCO® Cloud Integration UI and create a MySQL connection. You should be able to connect and design flow. For step-by-step instructions see Creating a MySQL Connection in the online help at this URL: https://integration.cloud.tibco.com/docs/index.html#Subsystems/flogo-mysql/connector-users-guide/mysql-creating-an-oracle-m.html

Setting "On-Premise DB Service" to true enables the activities of a TIBCO Flogo Database connector to be routed to your on-premise database through the TIBCO Cloud - Proxy Agent tibtunnel instance running. 

  8.  Push the app after it has been designed.

 9. In the TIBCO® Cloud Integration UI, go to Environmental Controls→Hybrid Connectivity.

[Note: The same tunnel can be used in Design Time as well as Run Time. If not, you can create a new access key or profile to start a new tunnel using configure and connect commands: https://integration.cloud.tibco.com/docs/index.html#tci/using/hybrid-agent/agent-command-reference.html]

 10. Choose the Access Key that your tunnel is configured with.

11. Click Push updates in the UI. Once updated, scale up the application on TCI.

[NOTE: The solution above showcases the DB Service configuration for an Oracle MySQL Server connection to an on-premises database, but these steps also apply to Microsoft SQL Server and PostgreSQL Server connections.]

Documentation links :

1. Installing and configuring the TIBCO Cloud hybrid agent : https://integration.cloud.tibco.com/docs/index.html#tci/using/hybrid-agent/installing-configuring-running-agent.html
2. Creating Access Keys : https://account.cloud.tibco.com/cloud/docs/proxy-agent/creating_access_key.html