Data Sources Properties

Data Sources properties apply to data sources in the Hyperion Interactive Reporting Data Access Service (DAS). These properties can be used to fine-tune Hyperion Interactive Reporting Data Access Service performance.

To import a DAS data source, click Import, select the source server.xml file from file system and click OK. (The location of source server.xml file can differ depending on source system version.)

To add a new data source to DAS, click New.

To modify properties of an existing data source in DAS, select the data source and click Modify.

Note:

Connectivity Type, Database Type, and Data Source Name are used only to route requests to Hyperion Interactive Reporting Data Access Service. Database client software to connect to the requested database must be installed and properly configured on each host where Hyperion Interactive Reporting Data Access Services is configured to accept routed requests for database access.

Table 8. Data Source Properties

Property	Description
Connectivity Type	Data source database driver. Must be installed on the host for Hyperion Interactive Reporting Data Access Service.
Database Type	Database type for the data source
Data Source Name	Name of the data source
Maximum Connections in Pool	Maximum number of unused database connections to keep open for a database user name and Interactive Reporting database connection combination
Maximum Queue Size	Maximum number of requests that can simultaneously wait to obtain a connection to the database server
Maximum Idle Time	Maximum number of seconds to keep open unused database connections
Reap Interval	Frequency in seconds at which the system checks for unused database connections and closes them
Maximum Pool Idle Time	Maximum number of seconds to keep unused connections for a database user name and Interactive Reporting database connection combination in memory
Use Proxy Session	For Oracle databases only. Whether to use Oracle Proxy Authentication When you use Oracle Proxy Authentication, users are not authenticated by the Oracle database. The proxy user acts on behalf of the user. This feature can be used in conjunction with pass-through authentication in EPM Workspace so users only need to authenticate to EPM Workspace and can connect to an Oracle database. Connections are kept in a connection pool by the Oracle database connection software to increase efficiency. If you use a proxy session, enter the following information: Proxy User Name—User name of the Oracle database proxy user account Proxy Password—Password of the Oracle database proxy user account Proxy Oracle Pool Minimum—Minimum number of database connections available in the Oracle connection pool Proxy Oracle Pool Increment—Number of additional connections created if a connection is needed, all existing connections in the pool are in use, and the maximum number of connections has not been reached Proxy Oracle Pool Maximum—Maximum number of connections that can be opened using the data source Note: To use this feature, you must first configure user accounts and Oracle proxy user accounts to use Oracle Proxy Authentication in the Oracle database server.