Bookshelf Home | Contents | Index | Search | PDF

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

Create the Physical Layer of the Disconnected Analytics Repository

---

The Physical layer of the Disconnected Analytics repository should be configured to run against a SQL Anywhere database. This allows the Siebel Analytics Server to generate the appropriate SQL statements for downloading data.

You can import the Physical layer schema database using the import feature in the Administration Tool. If you set up the tables in a local SQL Anywhere database, you can import these tables into your disconnected repository. For detailed instructions about how to create the Physical layer, including importing the physical schema, see Creating and Administering the Physical Layer in a Repository and Importing a Physical Schema.

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

• The database data source definition must be SQL Anywhere as shown in Figure 15.

  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. For an example of connection pool parameters, see Figure 16.
  • The user name and password of the connection pool must be the same as the name of the application. This application name is specified in the application configuration file and the user name and password much match it. For more information, see Creating the Application Configuration File for Disconnected Analytics.
• The mobile user does not need to know the user name and password for the local 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 local Disconnected Analytics application.
  • Data is always personalized, because it is extracted from the Siebel Analytics 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.

Bookshelf Home | Contents | Index | Search | PDF