Siebel Analytics Platform Installation and Configuration Guide > Configuring the Siebel Analytics Data Sources >

About Updating Row Counts in Native Databases

Analytics License: All licenses.

Operating System: UNIX only.

This topic applies if you are using the Update Rowcount functionality and running a heterogeneous environment, such as Siebel Analytics Server and database under UNIX, while remote Administrator users run the Server Administration Tool on Windows machines.

When using the Update Rowcount functionality, the Server Administration Tool uses local ODBC sources on the client machine, not the server ODBC sources. Therefore, Oracle or DB2 data sources must be configured on the Windows machine running Server Administration Tool so that the following conditions are true:

• Data sources point to the same DBMS identified in the Siebel Analytics user.csh or user.sh file on the UNIX server.
• The name of the local data source also must match the name of the data source defined in the Connection Pool object in the physical layer of the Siebel Analytics repository (.rpd) file.

If these conditions are not true, and if the server and client data sources are pointing at different databases, then erroneous updated row counts or incorrect results appear.