Oracle^® Business Intelligence Disconnected Analytics Administration and Configuration Guide > Preparing Applications for Oracle BI Disconnected Analytics > Step 3: Creating and Storing the Disconnected Repository >

Assign the Database Type and Connection Pool

The following list explains the unique properties for the database and disconnected connection pool for Oracle BI Disconnected Analytics:

• 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 2 illustrates where to set the Database type to SQL Anywhere. The CRM metadata tables box and the Virtual Private Database box are not applicable to Oracle BI Disconnected Analytics, so you can leave them unchecked.

  Figure 2. Disconnected Data Source Definition

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

  Figure 3. Disconnected Connection Pool Properties

  • The connection pool data source name must be Disconnected, because client laptops are configured during the Oracle BI Disconnected Analytics installation to use this data source name.
  • The SQL Anywhere personal database server, licensed with Oracle BI Disconnected Analytics, cannot have more than 10 concurrent database connections. Therefore, when setting up an RPD for Oracle BI Disconnected Analytics, set the Maximum Connections value to less than or equal to 10.
  • The user name and password of the connection pool must be the same as the name of the Oracle BI Disconnected Analytics application. This application name is specified in the application configuration file and the user name and password must match it. For more information, see Step 6: Creating the Configuration File for an Oracle BI Disconnected Analytics Application.
• A user of Oracle BI Disconnected Analytics 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 Oracle BI Disconnected Analytics 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 disconnected users to connect to their Oracle BI Disconnected Analytics applications.
  • Data is always personalized, because it is extracted from the Oracle BI Server using each user's name and password.
  • If your company uses Oracle's 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 Oracle Business Intelligence Server Administration Guide.
• Column names in a database table cannot contain special characters such as #. Change fact table column names to contain alphanumeric characters only.