Managing Reports › Write CA Business Intelligence Reports › CA SDM ODBC Driver

CA SDM ODBC Driver

Business Objects reporting applications (Crystal Reports and Web Intelligence) access data using an ODBC driver that connects directly with the CA SDM object engine named the domsrvr.

This connection provides a number of benefits:

• SELECT statements used by BusinessObjects reports reference objects and attributes using their CA SDM names (in other words, their Majic names). For example, a SELECT statement for a report on contacts could be written:

  SELECT combo_name FROM cnt WHERE last_name LIKE 'smith%'
  

• The CA SDM ODBC driver maps attributes like combo_name and objects like cnt to their corresponding DBMS name or names.
• All CA SDM security, including data partition and tenancy restrictions, is automatically applied to reports. All connections between BusinessObjects and CA SDM are associated with a CA SDM contact, and the CA SDM ODBC edits input SELECT statements to enforce the security restrictions associated with the end-user reporting role. BusinessObjects does not connect directly to the database.
• The CA SDM Attribute Alias feature "flattens" or de-normalizes the CA SDM database. Attribute aliases are additional attributes in CA SDM objects that allow a query to reference attributes in joined tables without an explicit join, allowing the base table to be used as if it were a reporting view.
• The CA SDM ODBC driver supports date literals in queries, and automatically translates values in CA SDM internal date format to a standard DBMS date.

Important! The CA SDM ODBC driver is supported only for BusinessObjects reporting (Crystal and Web Intelligence). CA SDM does not provide a standalone ODBC client, and does not recommend use of the ODBC driver with applications other than BusinessObjects.