Application Service Guide > Reporting Service (Deprecated) > Configuring the Reporting Service

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. If you update any of the properties, restart the Reporting Service for the modifications to take effect.

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 for the service:

Property	Description
Name	Name of the 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: ` ~ % ^ * + = { } \ ; : ' " / ? . , < > \| ! ( ) ] [ You cannot change the name of the service after you create it.
Description	Description of the service. The description cannot exceed 765 characters.
License	License object that allows use of the service. To apply changes, restart the Reporting Service.
Node	Node on which the 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. Note: The Reporting Service uses the DataDirect drivers included with the Informatica installation. Informatica does not support the use of any other database driver.
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.