Siebel Analytics Server Administration Guide > Setting Up Disconnected Analytics > Creating and Storing the Disconnected Analytics Repository >

Assign the Disconnected Database Type and Connection Pool

The following list explains the unique properties for the disconnected database and disconnected connection pool:

• In the physical layer of every disconnected repository, the database type must be set to SQL Anywhere because that will always be the database on the disconnected machine. Figure 15 illustrates where to set the Database type to SQL Anywhere.

  Figure 15.  Disconnected Data Source Definition

• Figure 16 shows the connection pool parameters in the Connection Pool dialog box.

  Figure 16.  Disconnected Connection Pool Properties

  • The connection pool data source name must be Disconnected because client laptops are configured during the Disconnected Analytics installation to use this data source name.
  • The user name and password of the connection pool must be the same as the name of the disconnected application. This application name is specified in the application configuration file and the user name and password must match it. For more information, see Create the Application Configuration File for Disconnected Analytics.
• The mobile user does not need to know the user name and password for the disconnected database. You can define a common user name (Administrator by default) in the repository and mobile users can use this to log in to their disconnected applications.
  • For authentication purposes, you can add a standard user name in the disconnected repository for all mobile users to connect to their Disconnected Analytics application.
  • Data is always personalized, because it is extracted from the enterprise server using each user's name and password.
  • If your company uses Siebel operational applications remotely, you can set up a separate connection for authentication purposes. The user name and password in this connection must be :USER and :PASSWORD. These variables allow the values to be used for authentication purposes. For more information about repository variables, see Using Repository Variables.
• Column names in a database table cannot contain special characters such as #. Change fact table column names to contain alphanumeric characters only.