Integrate AppDynamics with DB CAM

This page describes how to integrate Splunk AppDynamics with DB CAM. You can link to DB CAM for any DB CAM-monitored database that is discoverable by Splunk 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 Splunk AppDynamics.

Configure Splunk 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 Splunk 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 dialog, enter "DB_CAM_URL".

7. In the right dialog, enter the URL of the Splunk AppDynamics Controller that you are configuring using the syntax: http[s]://<host>:<port>

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

Configure DB CAM at the Agent Level

Perform this procedure 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 Splunk AppDynamics

You can link to DB CAM from any Splunk 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 gain access to the DB CAM instance dashboard. If you link to be DB CAM from a transaction snapshot, you gain access to the DB CAM Session Drill Down pane.

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.