This topic describes how you can you link to AppDynamics for Databases from a monitored database, server, or storage system (NetApp) that is discovered by AppDynamics and supported by AppDynamics for Databases  This integration provides access to the deep database performance metrics provided by AppDynamics for Databases .

Prerequisites for AppDynamics for Databases Integration

• To use this integration you must have an AppDynamics for Databases  license.
• AppDynamics for Databases must be configured to monitor the databases that you want to link to from AppDynamics.
• You need the URL of the AppDynamics for Databases server.  The URL of the server is comprised of its IP address  or hostname and the port number of the server separated with a colon. The port number defaults to 8090 when you install the server, so if you haven't changed it, that's what it will be.  
  • For example the URL of an AppDynamics for Databases server could be, http://win-s7cnim71mii:8090 or http://192.168.0.27:9090
  • You can find the IP address of the machine where you installed the AppDynamics for Databases server as follows:
    • Windows: Open a cmd window, enter "ipconfig /all".  You'll see the IP address of the server there.  
    • Linux: Open a terminal window and enter "ifconfig -a".  This command will tell you what your IP address is.  Go to http://www.wikihow.com/Check-Ip-Address-in-Linux for other ways to find your IP address.
• In addition, if you are installing AppDynamics for Databases  and the AppDynamics controller on the same host, you may need to change the port number AppDynamics for Databases uses because the default port number for both products is 8090.  We recommend that you use port 9090. For information about changing the port number on AppDynamics for Databases , see Install AppDynamics for Databases and AppDynamics Controller on the Same Host.

See Linking to AppDynamics for Databases, and Integrate and Use AppDynamics for Databases with AppDynamics Pro for information on how to access AppDynamics for Databases  from the Controller UI.

See the AppDynamics for Databases documentation for information about using AppDynamics for Databases.

Configuring AppDynamics to Interface with AppDynamics for Databases

To Configure AppDynamics to Interface with AppDynamics for Databases

1. In the upper right corner of the menu bar, click Settings.

2. From the dropdown menu, click Administration.

3. Click the Integration tab.

4. Click AppDynamics for Databases in the Integrations list.

5. Check the Enabled check box to enable the integration.

6. Enter the URL and port number of your AppDynamics for Databases installation as follows: http://<IPAddress or Hostname>:<server port number>

7. Click Save.

To Configure the App Agent for Java to Interface with the AppDynamics for Databases Oracle Collector

From a Transaction Snapshot Flow Map where the exit call is to an Oracle database, you can link to AppDynamics for Databases to see and analyze the exact SQL that was running at the time of the transaction snapshot. To enable this functionality, for the node containing the Oracle database, you must set the App Agent for Java node property jdbc-dbcam-integration-enabled=true.