Creating Interactive Reporting Database Connections (.oces)

The Database Connection Wizard steps you through the Interactive Reporting database connection file creation process and captures the connection parameters in a file that enables you to connect to a data source. Interactive Reporting Studio saves the cInteractive Reporting database connection file in the default Interactive Reporting database connection directory.

With an advanced user’s assistance, an Interactive Reporting database connection file can be set up once, distributed, and reused. You only have to supply a database user name and password each time you log in to query a database.

Note:

There is a correlation between the connectivity software and database choices. For example if you select Essbase for the connection software, only .Essbase is available as a database choice.

  To create an Interactive Reporting database connection:

  1. Select Tools, then Connection, and then Create.

    The Database Connection Wizard is displayed.

  2. Select the connection software used for connecting to the database server from the pull down list in the What connection software do you want to use? field.

  3. Select the database server in the What type of database do you want to connect to? field.

  4. To configure metadata settings, select Show Meta Connection Wizard.

  5. To configure advanced connection preferences, select Show advanced options.

  6. Click Next.

  7. Depending on the database, enter your user name in the User Name field, password in the Password field, the IP address, ODBC database source or server alias name in the Host field and click Next.

    If you selected to work with meta data settings, the Meta Data Connection Wizard launches. See the Accessing the Open Metadata Interpreter for more information.

  8. The wizard prompts you to save the Interactive Reporting database connection file.

  9. To save the Interactive Reporting database connection file, click Yes.

    The Save dialog box is displayed. Interactive Reporting Studio saves theInteractive Reporting database connection file in the default Interactive Reporting connection directory.

  10. To save the Interactive Reporting database connection file in a different directory, navigate to the desired directory and click Save.

    Table 233. Database Connection Configuration Wizard options 

    Option

    Description

    What connection software do you want to use?

    Select the connection software to use when connecting to the database.

    Depending on the connection software, additional fields may be displayed. These fields enable you to customize the Interactive Reporting database connection file; show metadata settings; and select ODBC logon dialogs.

    What type of database do you want to connect to?

    Select the type of database to which to connect from the pull-down list.

    Show Metadata Connection Wizard?

    To view and edit meta data settings, select this field. The Metadata Definitions dialog box is configured with specific SQL statements to read meta data on multiple databases.

    Show advanced options?

    To select advanced preferences for the Interactive Reporting database connection file, select this field. Connection preferences enable you to select what instructions and protocols the Interactive Reporting database connection file should observe. The preferences are saved with the Interactive Reporting database connection file and applied each time you use the connection.

    For example, you can use connection preferences to filter extraneous tables from the Table Catalog or specify how the connection software should manage SQL statements.

    Connection preferences vary depending on the connection software and database.

    Prompt for database name

    To select the specific database name on the server, select this field.

    Use ODBC Logon Dialogs?

    If you select ODBC connection software, use the ODBC logon dialog boxes instead of the Interactive Reporting Studio dialog boxes, select this field. To use the Interactive Reporting Studio connection dialog boxes, leave this field unchecked.

    User Name

    Enter the sign on name to the database.

    Password

    Enter the password for the database

    Host

    Enter the IP address, database alias, or ODBC data source name.

Note:

In Release 9.3, Hyperion supports connections to Informatica MX2 repositories, specifically connections to the Informatica PowerCenter 7.1 repositories using the Informatica Metadata Exchange SDK 7.1 client software. The Connection Wizard has been changed to prompt for the repository server host name and port number instead of the ODBC connection string, user name and password. The Informatica Metadata Exchange SDK 7.1 client software must installed to the server or the machine that has DAS running to work in the EPM Workspace and in Interactive Reporting Web Client. Connections to Informatica MX2 repositories are supported on Windows platforms only.