Ransomware attackers specifically target and attempt to destroy backup systems to increase the probability of payment. Hardening your system is critical. Please ensure you have reviewed your platform security using the Security Hardening Checklist
Cohesity

COHESITY Documentation

Explore our documentation to get started, discover products & new features, access troubleshooting guides, register sources, platforms support.

Products
Data Security Alliance
Visit Cohesity.com
Demos
Support
Blogs
Developers
Partner Portals
Cohesity Community
© 2026 Cohesity, Inc. All Rights Reserved.
Terms of Use|
Privacy Policy|
Legal|
  1. Home
  3. IT Analytics Data Collector Notes and Troubleshooting
  5. Data Collector Troubleshooting
  7. Substituting ODBC for JDBC to connect to SQL server for Veritas Backup Exec
IT Analytics Data Collector Notes and Troubleshooting

Substituting ODBC for JDBC to connect to SQL server for Veritas Backup Exec

The Backup Exec data collector, by default, uses JDBC (Java Database Connectivity) to connect to the SQL Server database. In most cases, this is the preferred mechanism for communicating with the SQL Server. However, in some instances--for example, TCP/IP is disabled for the SQL Server--JDBC will not be feasible.

In these rare situations, you can configure ODBC (Open Database Connectivity) to connect. The main limitation of this option is that it requires that a DSN (Data Source Name) be set up for each Backup Exec server for which the data collector needs access.

Note:

The data collector can be configured to use a mixture of JDBC and ODBC for specific servers.

Use the following steps to turn on ODBC for specific servers:

  1. Obtain a copy the servers.csv file from the Portal Server (the one that you created to load the Backup Exec servers into the database).

  2. Edit servers.csvanddelete those servers that you do not want to use ODBC. The format of the entry in the CSV file is:

    <windows_domain>, <host or ipaddress>, <ipaddress>, , , BKUPEXEC

  3. Save the file to $APTARE_HOME/mbs/conf as odbcservers.confon the Data Collector server.

  4. Launch the ODBC Data Source Administrator window:

    Control Panel > Administrative Tools > Data Sources (ODBC)

  5. Set up the ODBC DSN for each of the Backup Exec servers in odbcservers.conf, as depicted in the following sequence of windows.

    The DSN needs to be of the form hostname_BKUPEXEC, where hostname is the second token in odbcservers.conf.

    Note:

    If the hostname_BKUPEXEC form does not work (see the third window in the following example), try substituting the IP address for the hostname. If you use the IP address, be sure to make appropriate changes to the CSV file to comply with the following required format:

    <windows_domain>, <ipaddress>, <ipaddress>, , , BKUPEXEC

    The DSN needs to be of the form hostname_BKUPEXEC, where hostname is the second token in odbcservers.conf.

    Note:

    If the hostname_BKUPEXEC form does not work (see the third window in the following example), try substituting the IP address for the hostname. If you use the IP address, be sure to make appropriate changes to the CSV file to comply with the following required format:

    <windows_domain>, <ipaddress>, <ipaddress>, , , BKUPEXEC

Feedback

Was this page helpful?
Previous

Collecting missed events for Veritas Backup Exec

Next

Useful Data Collection scripts for capacity

Feedback

Was this page helpful?