Instruction manual

Open Database Connectivity CentreVu® CMS Open Database Connectivity
ODBC Feature 1-2
calculations, keep in mind that arithmetic operations are performed in
order from left to right. Multiplication and division operations are
performed before addition and subtraction operations, unless the addition
or subtraction operations are enclosed in parentheses. Operations in
parentheses are always performed first. Therefore, it is very important to
review queries before sending them to the database.
Additional
Information on
Queries
1
For more information on how to compose efficient database queries, see
the Edit | Queries” chapter in the
CentreVu® CMS R3V8 Report Designer
document, 585-210-930.
Performance
Impact
1
The number, size, and types of queries received by the CMS may impact
performance. To keep system impact at a minimum, certain types of
queries, such as accessing large tables or performing table joins, should
be run during a period of low agent and real-time report activity; for
example, during off hours. Prioritize very involved queries the same way
you prioritize reports during high business activity. The impact of complex
or multiple queries on the database will be similar to running multiple
reports. Another important performance impact consideration is the
number of simultaneous database accesses allowed. To optimize system
performance, minimize the number of database connects and
disconnects from an application.
Security 1
ODBC users log into the CMS server with password protection. Users
have SQL access to
Informix tables as limited by the table permissions in
Chapter 3, “Database Tables.” All historical and dictionary database
tables have read-only access permission. The customer-created tables
on the host (any table names beginning with “
c_ ”) have read and write
permissions. All other tables are not accessible through ODBC.
CMS Feature
Interactions
Requiring Client
Support
1
The following CMS features require specific client administration and
interaction. Most importantly, data received by the client application is in
“raw” form; that is, it will need to be formatted for use within your
application. Dictionary names and certain time fields are most affected by
this formatting. Refer to Chapter 3, “Database Tables,” for further
information on data format and values.
●
Dictionary Names: Clients can access CMS Dictionary names. The
client must map the synonym to the report. Underlying data is