Informatica Reporting Service

The Reporting Service is an application service that runs the Data Analyzer application in an Informatica domain. Create and enable a Reporting Service on the Domain tab of the Administrator tool.

When you create a Reporting Service, choose the data source to report against:

PowerCenter repository. Choose the associated PowerCenter Repository Service and specify the PowerCenter repository details to run PowerCenter Repository Reports.    Metadata Manager warehouse. Choose the associated Metadata Manager Service and specify the Metadata Manager warehouse details to run Metadata Manager Reports.    Data Profiling warehouse. Choose the Data Profiling option and specify the data profiling warehouse details to run Data Profiling Reports.    Other reporting sources. Choose the Other Reporting Sources option and specify the data warehouse details to run custom reports.

Data Analyzer stores metadata for schemas, metrics and attributes, queries, reports, user profiles, and other objects in the Data Analyzer repository. When you create a Reporting Service, specify the Data Analyzer repository details. The Reporting Service configures the Data Analyzer repository with the metadata corresponding to the selected data source.

You can create multiple Reporting Services on the same node. Specify a data source for each Reporting Service. To use multiple data sources with a single Reporting Service, create additional data sources in Data Analyzer. After you create the data sources, follow the instructions in the Data Analyzer Schema Designer Guide to import table definitions and create metrics and attributes for the reports.

When you enable the Reporting Service, the Administrator tool starts Data Analyzer. Click the URL in the Properties view to access Data Analyzer.

The name of the Reporting Service is the name of the Data Analyzer instance and the context path for the Data Analyzer URL. The Data Analyzer context path can include only alphanumeric characters, hyphens (-), and underscores (_). If the name of the Reporting Service includes any other character, PowerCenter replaces the invalid characters with an underscore and the Unicode value of the character. For example, if the name of the Reporting Service is ReportingService#3, the context path of the Data Analyzer URL is the Reporting Service name with the # character replaced with _35. For example:

http://<HostName>:<PortNumber>/ReportingService_353 PowerCenter Repository Reports When you choose the PowerCenter repository as a data source, you can run the PowerCenter Repository Reports from Data Analyzer.

PowerCenter Repository Reports are prepackaged dashboards and reports that allow you to analyze the following types of PowerCenter repository metadata:

Source and target metadata. Includes shortcuts, descriptions, and corresponding database names and field-level attributes.    Transformation metadata in mappings and mapplets. Includes port-level details for each transformation.    Mapping and mapplet metadata. Includes the targets, transformations, and dependencies for each mapping.    Workflow and worklet metadata. Includes schedules, instances, events, and variables.    Session metadata. Includes session execution details and metadata extensions defined for each session.    Change management metadata. Includes versions of sources, targets, labels, and label properties.    Operational metadata. Includes run-time statistics.

Metadata Manager Repository Reports When you choose the Metadata Manager warehouse as a data source, you can run the Metadata Manager Repository Reports from Data Analyzer.

Metadata Manager is the PowerCenter metadata management and analysis tool.

You can create a single Reporting Service for a Metadata Manager warehouse.

Data Profiling Reports When you choose the Data Profiling warehouse as a data source, you can run the Data Profiling reports from Data Analyzer.

Use the Data Profiling dashboard to access the Data Profiling reports. Data Analyzer provides the following types of reports:

Composite reports. Display a set of sub-reports and the associated metadata. The sub-reports can be multiple report types in Data Analyzer.    Metadata reports. Display basic metadata about a data profile. The Metadata reports provide the source-level and column-level functions in a data profile, and historic statistics on previous runs of the same data profile.    Summary reports. Display data profile results for source-level and column-level functions in a data profile.

Other Reporting Sources When you choose other warehouses as data sources, you can run other reports from Data Analyzer. Create the reports in Data Analyzer and save them in the Data Analyzer repository.

Data Analyzer Repository When you run reports for any data source, Data Analyzer uses the metadata in the Data Analyzer repository to determine the location from which to retrieve the data for the report and how to present the report.

Use the database management system client to create the Data Analyzer repository database. When you create the Reporting Service, specify the database details and select the application service or data warehouse for which you want to run the reports. When you enable the Reporting Service, PowerCenter imports the metadata for schemas, metrics and attributes, queries, reports, user profiles, and other objects to the repository tables.

Note: If you create a Reporting Service for another reporting source, you need to create or import the metadata for the data source manually.

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 Domain tab.
2.
In the Navigator, click Actions > New Reporting Service.

The New Reporting Service dialog box appears.

Enter the general properties for the Reporting Service.

The following table describes the Reporting Service general properties:

3.

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 Datasourceproperties.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.

Note: 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.

Note: 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.
Advertisements

Tagged:

5 thoughts on “Informatica Reporting Service

  1. Mostafa 12/05/2012 at 21:06 Reply

    Carla WilsonFebruary 12, 2011 at 4:57 pm Seth, this is awesome! I didn’t know where to begin on using gotspaeial data. I have to try this out!BTW, I stumbled on your blog after reading your highlighting tip. I love your Blogroll, and have just added your blog to my favorites.

    Like

  2. gayu 01/17/2013 at 00:19 Reply

    what is connect string for oracle while creating the repository. I tried

    servername:portno/dbname

    Nothing worked right, i am keep on getting error messgae “An Exception has occurred. The database connection details for service is invalid. Please check the log for more details”

    which log do i need to check.
    Any help is much appreciated.

    Thanks in Advance

    Like

  3. zdinesh03 03/18/2013 at 09:56 Reply

    too good piece of information, I had come to know about your site from my friend sajid, bangalore,i have read atleast 11 posts of yours by now, and let me tell you, your web-page gives the best and the most interesting information. This is just the kind of information that i had been looking for, i’m already your rss reader now and i would regularly watch out for the new post, once again hats off to you! Thanks a lot once again, Regards

    Like

  4. Billy Huang 08/06/2014 at 11:15 Reply

    hi ,
    My source DB changed to RAC , So I had to change JDBC connect string .The issue is that I do not know where I need to change the JDBC connect string in Informatica.

    Like

  5. Billy 08/06/2014 at 11:20 Reply

    Hi ,
    My source DB changed to oracle RAC , so I have to change my JDBC connect string . The issue is that , I don’t know where shoud I change the JDBC conncect string in informatica 9.5.1. Any suggest is appreciate

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: