Creating a New Data Source Connection

Before you create a report, you must first create a data source connection. This section describes creating an ODBC data source connection. See Part VI Accessing Additional Data Sources for information on creating other types of data source connections.

*  To create an ODBC data source connection:

  1. Click Connection on the main Oracle's Hyperion® SQR® Production Reporting Studio screen.

    A Create Data Connection wizard is displayed.

  2. On the first page, enter a name to identify the data connection.

    For example, enter Oracle to connect to an Oracle data source.

  3. On the second page, select ODBC to identify the data source provider.

    For examples of selecting DDO as the data source provider, see Creating an SAP R/3 Data Source Connection, Creating an SAP BW Data Source Connection and Creating an Essbase Data Source Connection.

  4. On the third page, select an ODBC data source.

    This page lists data sources accessible through ODBC from your computer. The data sources are configured through the ODBC Manager.

    To add a data source, click New to access the Create New Data Source dialog box and select the appropriate driver from the list of available drivers.

    SQR Production Reporting Studio supports these drivers:

    • MERANT OEM 5.0 Wire Protocol drivers

    • IBM RedBrick 32 Warehouse ODBC driver

    • Sybase IQ driver

    If you are asked for a connect string, refer to the information in Table 1.

    Table 1. Data Sources and Their Connect Strings

    Data SourceDescription

    DB2

    Ssname/SQLid is the subsystem name and SQL authorization ID to use.

    Informix

    Database is the name of the database to use.

    Oracle

    [Username]/[Password[@Database]] is your user name and password for the database. Optionally, you can specify the connection string for the database.

    SQL Server

    Data_Source_Name/[Username]/[Password] is the name you give to the ODBC driver when you set up the driver, your user name, and the password for the database.

    Sybase

    Username/[Password] is your user name and password for the database.

  5. On the fourth page, select the Oracle's Hyperion® SQR® Production Reporting database to which you want to connect.

    SQR Production Reporting Studio assumes that you installed Production Reporting for the specified database on the same machine running SQR Production Reporting Studio. For example, to create reports in an Oracle database, install Production Reporting for Oracle on the SQR Production Reporting Studio machine.

    To connect to a remote Production Reporting database, select Remote as the Local Run and select the desired remote Production Reporting database in the Remote Run field. For example, to use Production Reporting for Oracle installed on a Remote host, select Remote as the Local Run and Oracle as the Remote Run.

  6. (Optional) On the fifth page, enter login parameters.

    If you do not enter a username and password here, you are prompted to enter a username and password each time you connect to the database and create a report. If you do enter a username and password here, however, you are not prompted to enter them again.

    If you choose to override the default server name or the default database name, enter the desired server name or database name here. For example, if you are connecting to Oracle and your tnsnames.ora entry differs from your SID entry, you could change the Server Name to match your Oracle SID.

  7. Click Finish to exit from the wizard.