Administration Guide › Accessing Collected Events with ODBC and JDBC › Example: Preparing to Use ODBC and JDBC Clients with Crystal Reports › Create an "elm" ODBC Data Source › ODBC Data Source Considerations

ODBC Data Source Considerations

The following are the descriptions of the ODBC data source fields as they relate to CA Enterprise Log Manager:

• Data Source Name

  Create a name for this data source. Client applications that want to use this data use this name to connect to the data source.

• Service Host

  Specifies the name of the CA Enterprise Log Manager server which the client connects. You can use either a hostname or an IPv4 address.

• Service Port

  Specifies the TCP service port on which the CA Enterprise Log Manager server listens for ODBC client connections. The default value is 17002. The value you set here must match the setting for the ODBC Server service or the connection fails.

• Service Data Source

  Leave this field blank, otherwise the connection attempt fails.

• Encrypted SSL

  Specifies whether to use encryption on the communications between the client and the CA Enterprise Log Manager server. The default value is to have SSL enabled. The value you set here must match the setting for the ODBC Server service or the connection fails.

• Custom Properties

  Specifies the connection properties for use with the event log store. The delimiter between the properties is a semi-colon with no space. The recommended default values include the following:

  • querytimeout

    Specifies the timeout value in seconds with no data returned after which the query is closed. The following is the syntax for this property:

    querytimeout=300
    

  • queryfederated

    Specifies whether to perform a federated query. Setting this value to false performs a query only on the CA Enterprise Log Manager server to which the database connection is made. The following is the syntax for this property:

    queryfederated=true
    

  • queryfetchrows

    Specifies how many rows to retrieve in a single fetch operation, if the query is successful. The minimum value is 1, and the maximum value is 5000. The default value is 1000. The following is the syntax for this property:

    queryfetchrows=1000
    

  • offsetmins

    Specifies the offset for the timezone for this ODBC client. A value of 0 uses GMT. You can use this field to set your own timezone offset from GMT. The following is the syntax for this property:

    offsetmins=0
    

  • suppressNoncriticalErrors

    Indicates the Interface Provider's behavior in case of noncritical errors such as a database not responding or a host not responding.

    The following is the syntax for this property:

    suppressNoncriticalErrors=false