CA SDM includes an ODBC driver that allows an external application, such as Web Intelligence, to submit SQL SELECT queries directly to the CA SDM object manager (domsrvr). The driver depicts CA SDM Majic object names and attributes as tables and columns of a virtual database. In addition, the driver allows an unlimited number of attribute alias columns to be added to each object. Each attribute alias defines a pseudo-column corresponding to a column of a joined table. For example, the attribute alias assignee_organization_name corresponds to the Majic dotted join assignee.organization.name.
Attribute alias codes provide a flattened view of the database. They allow you to include columns from related tables. By convention, an attribute alias name is the same as the Majic join name, with the dots replaced by underscores. For example, if a Call Request report needs to show the assignee's organization name, and this column was not provided out of the box, you could define an alias called assignee_organization_name that equates to assignee.organization.name.
| Copyright © 2013 CA.
|
Tell Technical Publications how we can improve this information |