Reporting Service


Use the Administrator tool to manage the Reporting Service and the Data Analyzer repository content.

You kan use the Administrator tool to complete the following tasks: Börja här med

*  Configure the edit mode.

* Enable and disable a Reporting Service.

* Create contents in the repository.

* Back up contents of the repository.

* Restore contents to the repository.

* Delete contents from the repository.

* Upgrade contents of the repository.

* View last activity logs.

Note: You must disable the Reporting Service in the Administrator tool to perform tasks related to repository content.

Enabling and Disabling a Reporting Service

Use the Administrator tool to enable, disable, or recycle the Reporting Service. Disable a Reporting Service to perform maintenance or to temporarily restrict users from accessing Data Analyzer. When you disable the Reporting Service, you also stop Data Analyzer. You might recycle a service if you modified a property. When you recycle the service, the Reporting Service is disabled and enabled.

When you enable a Reporting Service, the Administrator tool starts Data Analyzer on the node designated to run the service. Click the URL in the Properties view to open Data Analyzer in a browser window and run the reports.

You can also launch Data Analyzer from the PowerCenter Client tools, from Metadata Manager, or by accessing the Data Analyzer URL from a browser.

To enable the service, select the service in the Navigator and click Actions > Enable.

To disable the service, select the service in the Navigator and click Actions > Disable.

Note: Before you disable a Reporting Service, ensure that all users are disconnected from Data Analyzer.

To recycle the service, select the service in the Navigator and click Actions > Recycle.

 Creating Contents in the Data Analyzer Repository

You can create content for the Data Analyzer repository after you create the Reporting Service. You cannot create content for a repository that already includes content. In addition, you cannot enable a Reporting Service that manages a repository without content.

The database account you use to connect to the database must have the privileges to create and drop tables and indexes and to select, insert, update, or delete data from the tables.

1.
In the Administrator tool, click the Domain tab.
2.
In the Navigator, select the Reporting Service that manages the repository for which you want to create content.
3.
Click Actions > Repository Contents > Create.
4.
Select the user assigned the Administrator role for the domain.
5.
Click OK.

The activity log indicates the status of the content creation action.

6.
Enable the Reporting Service after you create the repository content.

Backing Up Contents of the Data Analyzer Repository

To prevent data loss due to hardware or software problems, back up the contents of the Data Analyzer repository.

When you back up a repository, the Reporting Service saves the repository to a binary file, including the repository objects, connection information, and code page information. If you need to recover the repository, you can restore the content of the repository from the backup file.

When you back up the Data Analyzer repository, the Reporting Service stores the file in the backup location specified for the node where the service runs. You specify the backup location when you set up the node. View the general properties of the node to determine the path of the backup directory.

1.
In the Administrator tool, click the Domain tab.
2.
In the Navigator, select the Reporting Service that manages the repository content you want to back up.
3.
Click Actions > Repository Contents > Back Up.
4.
Enter a file name for the repository backup file.

The backup operation copies the backup file to the following location:

<node_backup_directory>/da_backups/

Or you can enter a full directory path with the backup file name to copy the backup file to a different location.

5.
To overwrite an existing file, select Replace Existing File.
6.
Click OK.

The activity log indicates the results of the backup action.

Restoring Contents to the Data Analyzer Repository

You can restore metadata from a repository backup file. You can restore a backup file to an empty database or an existing database. If you restore the backup file on an existing database, the restore operation overwrites the existing contents.

The database account you use to connect to the database must have the privileges to create and drop tables and indexes and to select, insert, update, or delete data from the tables.

To restore contents to the Data Analyzer repository:

1.
In the Administrator tool, click the Domain tab.
2.
In the Navigator, select the Reporting Service that manages the repository content you want to restore.
3.
Click Actions > Repository Contents > Restore.
4.
Select a repository backup file, or select other and provide the full path to the backup file.
5.
Click OK.

The activity log indicates the status of the restore operation.

Deleting Contents from the Data Analyzer Repository

Delete repository content when you want to delete all metadata and repository database tables from the repository.

You can delete the repository content if the metadata is obsolete. Deleting repository content is an irreversible action. If the repository contains information that you might need later, back up the repository before you delete it.

To delete the contents of the Data Analyzer repository:

1.
In the Administrator tool, click the Domain tab.
2.
In the Navigator, select the Reporting Service that manages the repository content you want to delete.
3.
Click Actions > Repository Contents > Delete.
4.
Verify that you backed up the repository before you delete the contents.
5.
Click OK.

The activity log indicates the status of the delete operation.

Upgrading Contents of the Data Analyzer Repository

When you create a Reporting Service, you can specify the details of an existing version of the Data Analyzer repository. You need to upgrade the contents of the repository to ensure that the repository contains the objects and metadata of the latest version.

 Viewing Last Activity Logs

You can view the status of the activities that you perform on the Data Analyzer repository contents. The activity logs contain the status of the last activity that you performed on the Data Analyzer repository.

1.
In the Administrator tool, click the Domain tab.
2.
In the Navigator, select the Reporting Service for which you want to view the last activity log.
3.
Click Actions > Last Activity Log.

The Last Activity Log displays the activity status.

Configuring the Reporting Service

After you create a Reporting Service, you can configure it. Use the Administrator tool to view or edit the following Reporting Service properties:

General Properties. Include the Data Analyzer license key used and the name of the node where the service runs.
Reporting Service Properties. Include the TCP port where the Reporting Service runs, the SSL port if you have specified it, and the Data Source edit mode.
Data Source Properties. Include the data source driver, the JDBC URL, and the data source database user account and password.
Repository Properties. Include the Data Analyzer repository database user account and password.

To view and update properties, select the Reporting Service in the Navigator. In the Properties view, click Edit in the properties section that you want to edit.

General Properties

You can view and edit the general properties after you create the Reporting Service.

Click Edit in the General Properties section to edit the general properties.

The following table describes the general properties:

Property Description
Name Name of the Reporting Service.
Description Description of the Reporting Service.
License License that allows you to run the Reporting Service. To apply changes, restart the Reporting Service.
Node Node on which the Reporting Service runs. You can move a Reporting Service to another node in the domain. Informatica disables the Reporting Service on the original node and enables it in the new node. You can see the Reporting Service on both the nodes, but it runs only on the new node.If you move the Reporting Service to another node, you must reapply the custom color schemes to the Reporting Service. Informatica does not copy the color schemes to the Reporting Service on the new node, but retains them on the original node.

Reporting Service Properties

You can view and edit the Reporting Service properties after you create the Reporting Service.

Click Edit in the Reporting Service Properties section to edit the properties.

The following table describes the Reporting Service properties:

Property Description
HTTP Port The TCP port that the Reporting Service uses. You can change this value. To apply changes, restart the Reporting Service.
HTTPS 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. If the node where you create the Reporting Service is not configured for the HTTPS port, you cannot configure HTTPS for the Reporting Service. To apply changes, restart the Reporting Service.
Data Source Advanced 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 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.
Note: If multiple Reporting Services run on the same node, you need to stop all the Reporting Services on that node to update the port configuration.

Data Source Properties

You must specify a reporting source for the Reporting Service. The Reporting Service creates the following objects in Data Analyzer for the reporting source:

A data source with the name Datasource
A data connector with the name Dataconnector

Use the Administrator tool to manage the data source and data connector for the reporting source. To view or edit the Datasource or Dataconnector in the advanced mode, click the data source or data connector link in the Administrator tool.

You can create multiple data sources in Data Analyzer. You manage the data sources you create in Data Analyzer within Data Analyzer. Changes you make to data sources created in Data Analyzer will not be lost when you restart the Reporting Service.

The following table describes the data source properties that you can edit:

Property Description
Reporting Source The service which the Reporting Service uses as the data source.
Data Source Driver The driver that the Reporting Service uses to connect to the data source.
Data Source JDBC URL The JDBC connect string that the Reporting Service uses to connect to the data source.
Data Source User Name The account for the data source database.
Data Source Password Password corresponding to the data source user.
Data Source Test Table The test table that the Reporting Service uses to verify the connection to the data source.

Code Page Override

By default, when you create a Reporting Service to run reports against a PowerCenter repository or Metadata Manager warehouse, the Service Manager adds the CODEPAGEOVERRIDE parameter to the JDBC URL. The Service Manager sets the parameter to a code page that the Reporting Service uses to read data in the PowerCenter repository or Metadata Manager warehouse.

If you use a PowerCenter repository or Metadata Manager warehouse as a reporting data source and the reports do not display correctly, verify that the code page set in the JDBC URL for the Reporting Service matches the code page for the PowerCenter Service or Metadata Manager Service.

Repository Properties

Repository properties provide information about the database that stores the Data Analyzer repository metadata. Specify the database properties when you create the Reporting Service. After you create a Reporting Service, you can modify some of these properties.

Note: If you edit a repository property or restart the system that hosts the repository database, you need to restart the Reporting Service.

Click Edit in the Repository Properties section to edit the properties.

The following table describes the repository properties that you can edit:

Property Description
Database Driver The JDBC driver that the Reporting Service uses to connect to the Data Analyzer repository database. To apply changes, restart the Reporting Service.
Repository Host Name of the machine that hosts the database server. To apply changes, restart the Reporting Service.
Repository Port The port number on which you have configured the database server listener service. To apply changes, restart the Reporting Service.
Repository Name The name of the database service. To apply changes, restart the Reporting Service.
SID/Service Name For repository 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 User Account for the Data Analyzer repository database. To apply changes, restart the Reporting Service.
Repository Password Data Analyzer repository database password corresponding to the database user. To apply changes, restart the Reporting Service.
Tablespace Name Tablespace name for DB2 repositories. When you specify the tablespace name, the Reporting Service creates all repository tables in the same tablespace. To apply changes, restart the Reporting Service.
Additional JDBC Parameters Enter additional JDBC options.Don’t forget to allow granting Users Access to Reports Limit access to Data Analyzer to secure information in the Data Analyzer repository and data sources. To access Data Analyzer, each user needs an account to perform tasks and access data. Users can perform tasks based on their privileges. Much more security is there and just play around and see what you can do it.

You can grant access to users through the following components:

User accounts. Create users in the Informatica domain. Use the Security tab of the Administrator tool to create users.    Privileges and roles. You assign privileges and roles to users and groups for a Reporting Service. Use the Security tab of the Administrator tool to assign privileges and roles to a user.    Permissions. You assign Data Analyzer permissions in Data Analyzer.

Any comments either – or + will always welcome – uppskattad – välkommen här

Mehboob

MCITP – MCTS

2 thoughts on “Reporting Service

  1. I am able to create reporting service and my repository server is UP and running, still i get the followng error while enabling reporting service. Please help
    You must create a repository before you can enable the Reporting Service.

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