This page provides instructions for integrating AppDynamics with DB CAM. You can link to DB CAM for any DB CAM-monitored database that is discoverable by AppDynamics. This integration provides access to the database performance metrics provided by DB CAM.

Before You Begin

To use this integration you must have a DB CAM license. DB CAM must be configured to monitor the databases that you want to link to from AppDynamics.

Configure AppDynamics to Interface with DB CAM

You configure DB CAM integration at the account level and app agent level.

Configure DB CAM at the Account Level

Configure the integration at the account level using the Administration Console at <host>:<port>/controller/admin.jsp.

Create two new properties as name-value pairs in each account for which you want to enable DB CAM integration.

Configure One AppDynamics Account for DB CAM Integration

  1. Log in to the Administrator Console with the administrator root password.
  2. Select Accounts.
  3. Double-click the account for which you want to configure DB CAM integration.
  4. Click Additional Account Properties in the upper right.
  5. Click Add Property.
  6. In the left dialogue box, enter "DB_CAM_URL".
  7. In the right dialogue box, enter the URL of the AppDynamics Controller that you are configuring using the syntax: http[s]://<host>:<port>

  8. Click Add Property again.
  9. In the left dialogue box, enter "DB_CAM_ENABLED".
  10. In the right dialogue box, enter "true".
  11. Click OK.
  12. Log out of the Administrator Console.

Configure DB CAM at the Agent Level

Perform the following steps for each app agent for which you want to enable access to deep diagnostics from DB CAM:

  1. Open the AppServerAgent/conf/app-agent-config.xml file for the app agent.

  2. Locate the TransactionMonitoringService element, <agent-service name="TransactionMonitoringService" enabled="true">.

  3. Add the jdbc-dbcam-integration-enabled property for the service:

    <agent-service name="TransactionMonitoringService" enabled="true">
        <service-dependencies>BCIEngine,SnapshotService</service-dependencies>
             <configuration-properties>
                 <property name="jdbc-dbcam-integration-enabled" value="true"/>
  4. Save the file.

Link to DB CAM from AppDynamics

You can link to DB CAM from any AppDynamics flow map that displays a discovered DB CAM-monitored database. The flow map could be in a dashboard or a transaction snapshot.

If you link to DB CAM from a dashboard you will land in the DB CAM instance dashboard. If you link to be DB CAM from a transaction snapshot, you will land in the DB CAM Session Drill Down screen.

To Link to DB CAM from a Dashboard

  1. In the flow map of a dashboard, right-click on the link below a database icon.
  2. Select Search in DBCam. DB CAM launches and displays the instance dashboard for the selected database.

To Link to DB CAM from a Transaction Snapshot

  1. In the flow map of a transaction snapshot, right-click on the link below the database icon.
  2. Select Search in DBCam. DB CAM launches and displays the session drill down for the selected database.