Creating an SAP R/3 Data Source Connection

  To create an SAP R/3 data source connection:

1. Click Connection on the main 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 SAPR3 to identify a connection to an SAP R/3 data source.

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

   For an example of selecting ODBC as the data source provider, see Creating a New Data Source Connection.

4. On the third page, select an SAP R/3 data source.

   The wizard displays the available registries and data sources. Before connecting to an SAP R/3 data source, you must add the data source to the Registry.properties file in the DDO Registry Editor. (See “Using the Registry Editor to Make an SAP R/3 Connection” in Volume 3 of the Hyperion SQR Production Reporting Developer's Guide

5. (Optional) On the fourth 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.

6. Click Finish to exit the wizard.

   The data source you defined is displayed in the Data Connection dialog box.

7. Highlight the data source and click OK.