Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Security 6.2.

ODBC tab

BMC Defender Server includes an ODBC interface, that permits you to load PDF report data (and other data) into an ODBC compliant relational database. The Report ODBC Screen is one of several interfaces to the BMC Defender Server ODBC capability, and permits the operator to define ODBC data sources accessible to BMC Defender Server. Additionally, the screen permits you to run standard SQL queries on ODBC data sources, for testing and reporting purposes. The Report ODBC screen is depicted as follows:

image2019-3-22_16-48-17.png

Detailed notes on the BMC Defender Server ODBC facility are provided in ODBC-interface. The system can work with multiple ODBC data sources, and these data sources support the Pivot Report, and Actions facilities of BMC Defender Server. Additionally, methods to create BMC Defender Server screens that run database queries and display the results are documented in Using-Sigma-Web-Framework.

Note

The BMC Defender Server operates as 32-bit executable, hence cannot access a 64-bit ODBC driver. When configuring the BMC Defender Server ODBC connection on a 64-bit machine, the operator must run the %Windir%\SysWOW64\odbcad32.exe program to configure the ODBC data source. This is a common mistake.

The procedure for configuring the ODBC data source is as follows:

  1. On a 32-bit host platform, simply access the Admin Tools > ODBC screen from the Control Panel, select the System DSN tab of the Microsoft dialog, and create the DSN. The user specified name then appears in the drop-down list of the Reports > ODBC screen.

  2. On a 64-bit host platform, execute the 32-bit ODBC driver, usually found in the following location:

    %Windir%\SysWOW64\odbcad32.exe

    Create a System DSN (identical to the procedure in #1 as previous) and the DSN value then appears in the drop-down list of the Reports > ODBC screen.

  3. Once the System DSN appears in the drop-down list of the Reports > ODBC screen, the operator selects the value, clicks Edit, and supplies the user name and password (if any) that was configured as previous in the ODBC tool.

If the user specified name does not appear in the drop-down list of the Reports > ODBC screen, then the operator has either configured a 64-bit DSN (and should then configure the 32-bit DSN) or has not configured the DSN under the System DSN tab.

After performing the preceding steps, the ODBC DSN is available for use throughout the BMC Defender Server, on the various Reports tab, and in the Actions tabs of the system.

It might be useful for the operator to create a desktop shortcut on the BMC Defender Server platform that points to the correct Microsoft ODBC tool, to facilitate further interactions with the correct Control Panel tool.

Related topic

Reports-tab

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*