Table of Contents

Search

  1. Preface
  2. Analyst Service
  3. Content Management Service
  4. Data Integration Service
  5. Data Integration Service Architecture
  6. Data Integration Service Management
  7. Data Integration Service Grid
  8. Data Integration Service Applications
  9. Metadata Manager Service
  10. Model Repository Service
  11. PowerCenter Integration Service
  12. PowerCenter Integration Service Architecture
  13. High Availability for the PowerCenter Integration Service
  14. PowerCenter Repository Service
  15. PowerCenter Repository Management
  16. PowerExchange Listener Service
  17. PowerExchange Logger Service
  18. Reporting Service
  19. Reporting and Dashboards Service
  20. SAP BW Service
  21. Search Service
  22. System Services
  23. Test Data Manager Service
  24. Web Services Hub
  25. Application Service Upgrade
  26. Application Service Databases
  27. Connecting to Databases from Windows
  28. Connecting to Databases from UNIX
  29. Updating the DynamicSections Parameter of a DB2 Database

Creating the Reporting Service

Creating the Reporting Service

Before you create a Reporting Service, complete the following tasks:
  • Create the Data Analyzer repository. Create a database for the Data Analyzer repository. If you create a Reporting Service for an existing Data Analyzer repository, you can use the existing database. When you enable a Reporting Service that uses an existing Data Analyzer repository, PowerCenter does not import the metadata for the prepackaged reports.
  • Create PowerCenter Repository Services and Metadata Manager Services. To create a Reporting Service for the PowerCenter Repository Service or Metadata Manager Service, create the application service in the domain.
  1. In the Administrator tool, click the
    Manage
    tab >
    Services and Nodes
    view.
  2. In the Domain Navigator, click
    Actions
    New Reporting Service
    .
    The New Reporting Service dialog box appears.
  3. Enter the general properties for the Reporting Service.
    The following table describes the Reporting Service general properties:
    Property
    Description
    Name
    Name of the Reporting Service. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters or begin with @. It also cannot contain spaces or the following special characters:
    ` ~ % ^ * + = { } \ ; : ' " / ? . , < > | ! ( ) ] [
    Description
    Description of the Reporting Service. The description cannot exceed 765 characters.
    Location
    Domain and folder where the service is created. Click Browse to choose a different folder. You can move the Reporting Service after you create it.
    License
    License that allows the use of the service. Select from the list of licenses available in the domain.
    Primary Node
    Node on which the service process runs. Since the Reporting Service is not highly available, it can run on one node.
    Enable HTTP on port
    The TCP port that the Reporting Service uses. Enter a value between 1 and 65535.
    Default value is 16080.
    Enable HTTPS on port
    The SSL port that the Reporting Service uses for secure connections. You can edit the value if you have configured the HTTPS port for the node where you create the Reporting Service. Enter a value between 1 and 65535 and ensure that it is not the same as the HTTP port. If the node where you create the Reporting Service is not configured for the HTTPS port, you cannot configure HTTPS for the Reporting Service.
    Default value is 16443.
    Advanced Data Source Mode
    Edit mode that determines where you can edit
    Datasource
    properties.
    When enabled, the edit mode is advanced, and the value is true. In advanced edit mode, you can edit
    Datasource
    and
    Dataconnector
    properties in the Administrator tool and the Data Analyzer instance.
    When disabled, the edit mode is basic, and the value is false. In basic edit mode, you can edit
    Datasource
    properties in the Administrator tool.
    After you enable the Reporting Service in advanced edit mode, you cannot change it back to basic edit mode.
  4. Click
    Next
    .
  5. Enter the repository properties.
    The following table describes the repository properties:
    Property
    Description
    Database Type
    The type of database that contains the Data Analyzer repository.
    Repository Host
    The name of the machine that hosts the database server.
    Repository Port
    The port number on which you configure the database server listener service.
    Repository Name
    The name of the database server.
    SID/Service Name
    For database type Oracle only. Indicates whether to use the SID or service name in the JDBC connection string. For Oracle RAC databases, select from Oracle SID or Oracle Service Name. For other Oracle databases, select Oracle SID.
    Repository Username
    Account for the Data Analyzer repository database. Set up this account from the appropriate database client tools.
    Repository Password
    Repository database password corresponding to the database user.
    Tablespace Name
    Tablespace name for DB2 repositories. When you specify the tablespace name, the Reporting Service creates all repository tables in the same tablespace. Required if you choose DB2 as the Database Type.
    Data Analyzer does not support DB2 partitioned tablespaces for the repository.
    Additional JDBC Parameters
    Enter additional JDBC options.
  6. Click
    Next
    .
  7. Enter the data source properties.
    The following table describes the data source properties:
    Property
    Description
    Reporting Source
    Source of data for the reports. Choose from one of the following options:
    • Data Profiling
    • PowerCenter Repository Services
    • Metadata Manager Services
    • Other Reporting Sources
    Data Source Driver
    The database driver to connect to the data source.
    Data Source JDBC URL
    Displays the JDBC URL based on the database driver you select. For example, if you select the Oracle driver as your data source driver, the data source JDBC URL displays the following: jdbc:informatica:oracle://[host]:1521;SID=[sid];.
    Enter the database host name and the database service name.
    For an Oracle data source driver, specify the SID or service name of the Oracle instance to which you want to connect. To indicate the service name, modify the JDBC URL to use the ServiceName parameter:
    jdbc:informatica:oracle://[host]:1521;ServiceName=[Service Name];
    To configure Oracle RAC as a data source, specify the following URL:
    jdbc:informatica:oracle://[hostname]:1521;ServiceName=[Service Name]; AlternateServers=(server2:1521);LoadBalancing=true
    Data Source User Name
    User name for the data source database.
    Enter the PowerCenter repository user name, the Metadata Manager repository user name, or the data warehouse user name based on the service you want to report on.
    Data Source Password
    Password corresponding to the data source user name.
    Data Source Test Table
    Displays the table name used to test the connection to the data source. The table name depends on the data source driver you select.
  8. Click
    Finish
    .