Viewing DB Service Status for an Organization with the API

You can set up hybrid connectivity between TIBCO Flogo® apps and on-premises or private cloud databases using the Database connector design-time service or DB Service. DB Service is a singleton user app you run for an organization. It enables the activities of an app Database connector to be connected to your on-premises or private cloud database through the TIBCO Cloud™ Integration - Hybrid Agent. The database service is accessible only by the users that belong to selected organization.

Use the API to check the status of the DB Service for a specific organization. You can also use this method to determine when an asynchronous call has completed, such as the POST /v1/subscriptions/{subscriptionLocator}/dbservice method.

To check DB Services status you need the following: 

Subscription Locator — The Subscription Locator of the Organization you want to access. To find Subscription Locators for your organizations use the GET ​/v1​/userinfo method to return a list of all of the organizations for your OAuth Token with their Subscription Locators. You can use 0 as the Subscription Locator for the organization that owns the OAuth token.

  1. Make the asynchronous call to modify the DB Service.
  2. Use the GET ​/v1​/subscriptions​/{subscriptionLocator}​/dbservice method to request the DB Service status of the selected organization.
  3. You may need to make the status call more than once until you receive a response with a success message similar to the following: 
  4. {
      "subscriptionLocator": "01ESSC8PWNVJ7BXJSYMCNFB9BG",
      "status": "enabled",
      "tunnelKey": "lakshmiaccesskey"
    } 

Related Topics

Managing an Organization with the TIBCO Cloud™ Integration API

Enabling the DB Service for an Organization with the API

Disabling the DB Service for an Organization with the API