Setting Processing and Metadata Options

Three options types specific to Interactive Reporting, database-connection file are offered: processing and metadata.

Processing Open Catalog Extension (OCE) options store database connection information.

Table 76. Processing Database-Connection Options

Option	Description
Data source access	Select a method for the Interactive Reporting database-connection file to use a username and password when a job is run or a file is processed. Use the username/password specified below—You enter the database username and password. Prompt for user name/password—You are prompted for the database username and password when the job is run or scheduled or the file is processed. This is the default when pass-through is disabled.
User name	If Data source access is set to use this field, enter the database user name.
Password	If Data source access is set to use this field, enter in the database password.
Allow pass-through where end user’s authentication system is enabled for it	Select to allow pass-through credentials for data source access.

Metadata options store a file that contains extra information about the Interactive Reporting database connection.

Table 77. Metadata Options

Option	Description
This Interactive Reporting database connection (.oce) uses metadata defined in another connection	Metadata is used and the metadata connection is not specified in the Interactive Reporting, database-connection file. All fields in this group are disabled if this field is not selected.
Select metadata connection	If metadata is used and the metadata connection is not specified in the Interactive Reporting, database connection file, select the Interactive Reporting database-connection file for the metadata.
Metadata access	Select one of the following: Use processing OCE’s credential for metadata connection – Use that username and password associated with the Interactive Reporting database connection to access the metadata. Use specified user name/password – Use the specified user name and password to access the metadata.
User name	If Data source access is set to use this field, enter the database user name.
Password	If Data source access is set to use this field, enter in the database password.

Table 78. Interactive Reporting Database Connection

Option	Description
Connection Software	Connection software name used by this Interactive ReportingInteractive Reporting database connection file (.oce) to connect to the database server, for example, ODBC or EssbaseOracle Essbase.
Database	Type of the database or database connectivity to which this Interactive Reporting Connection file (.oce) is used to connect, for example ORA8, Essbase, ODBC, OLEDB and so on.
Host	Identifier or alias for the specific information needed to connect to the client, for example, host name or DSN.

To complete the Import dialog wizard for Interactive Reporting Database Connection (.oce) files, see Importing Files.