Install Database Monitoring on Windows

This page describes the steps required to install Database Collector on Windows.

Ensure that the machine on which you install the Database Collector has network access to the databases you want to monitor.

Perform the following steps:

Go to https://appdynamics.jfrog.io/ui/native/zip-hosted/appdcloud/collectors/db-collector-windows-amd64/.
Download the zip file version that is appropriate for your OS environment.
For example, /23.6.0-780/db-collector-windows-amd64-23.6.0-780.zip
Extract the zip file to any directory.

Update the conf\appddbcollector.yaml configuration file in the extracted folder:

appddbcollector.yaml

appdynamics_credentials:
  client_id: <client-id>
  client_secret: <secret>
  endpoint: <data-endpoint>
  token_url: <auth-endpoint>  

# Set below fields in the config to provide SSL details
# tlsConfig:
#  certificate: <certificate>
#  hostNameInCertificate: <hostname>

# Set below field in the config to specify environment (defaults to self-hosted)
# environment:
#  platform: self-hosted # Other possible properties "AWS", "Azure"

monitoring_config:
  sqlserver/1:
    configName: ${CONFIG_NAME}
    hostname: ${HOSTNAME}
    hostport: ${HOSTPORT}
    username: ${USERNAME}
    password: ${PASSWORD}
    database: ${DATABASE}
    tlsConfig:
      certificate: ${CERTIFICATE_CRT}
      hostNameInCertificate: ${HOSTNAMEINCERTIFICATE}
    environment:
      platform: ${CLOUD_CONFIG}
  mysql/1:
    configName: ${CONFIG_NAME}
    hostname: ${HOSTNAME}
    hostport: ${HOSTPORT}
    username: ${USERNAME}
    password: ${PASSWORD}
    environment:
      platform: ${CLOUD_CONFIG}
    tlsConfig:
      certificate: ${CERTIFICATE_CRT}
      hostNameInCertificate: ${HOSTNAMEINCERTIFICATE}
  aurora-mysql/1:
    configName: ${CONFIG_NAME}
    hostname: ${HOSTNAME}
    hostport: ${HOSTPORT}
    username: ${USERNAME}
    password: ${PASSWORD}
    environment:
      platform: ${CLOUD_CONFIG}
    tlsConfig:
      certificate: ${CERTIFICATE_CRT}
      hostNameInCertificate: ${HOSTNAMEINCERTIFICATE}
  mariadb/1:
    configName: ${CONFIG_NAME}
    hostname: ${HOSTNAME}
    hostport: ${HOSTPORT}
    username: ${USERNAME}
    password: ${PASSWORD}
    environment:
      platform: ${CLOUD_CONFIG}
    tlsConfig:
      certificate: ${CERTIFICATE_CRT}
      hostNameInCertificate: ${HOSTNAMEINCERTIFICATE} 
  aurora-postgresql/1:
    configName: ${CONFIG_NAME}
    hostname: ${HOSTNAME}
    hostport: ${HOSTPORT}
    username: ${USERNAME}
    password: ${PASSWORD}
    environment:
      platform: ${CLOUD_CONFIG}
    tlsConfig:
      certificate: ${CERTIFICATE_CRT}
  postgres/1:
    configName: ${CONFIG_NAME}
    hostname: ${HOSTNAME}
    hostport: ${HOSTPORT}
    username: ${USERNAME}
    password: ${PASSWORD}
    environment:
      platform: ${CLOUD_CONFIG}
    tlsConfig:
      certificate: ${CERTIFICATE_CRT}

YML

Specify aws or azure on the platform field. Keep the field empty if you are not using any of these platforms.
By default, logs are available in the logs directory of the extracted folder.

Start the Database Collector:
```
bin\appddbcollector.bat
```
CODE
To check the logs, open the appddbcollector.log file.