Catalog Administrator Guide > Managing Resources > Generate Resource Schedule Report and Duplicate Resources Report

Generate Resource Schedule Report and Duplicate Resources Report

You can generate a report with a list of all resources in the catalog and the schedules attached to each resource. The report helps you determine the best schedule to minimize the number of simultaneous resource scan jobs when you create a new schedule. You can also generate a report with a list of duplicate non-JDBC relational database type resources.

Use the Enterprise Data Catalog add-ons to generate and view the reports.

Deploy the Add-Ons

Deploy the add-on and then connect to the Catalog Administrator tool to view the resource schedules and duplicate resources in the catalog.

Download the add-ons from Informatica Marketplace. The informatica_1052_catalogReport.zip file includes the files that you need to deploy the add-ons.

1. On the node where you want to deploy the add-ons, extract the informatica_1052_catalogReport.zip file.

2. From the directory where you extracted the files, run the following command to start the application: ./startup.sh

The host name and the port number to access the application appear in the following format: http://<host>:<port>

Connect to the Catalog Administrator tool

After you deploy the add-ons, connect to the Catalog Administrator tool.

1. Open a browser.

2. In the address field, type the URL to access the application in the following format: http://<host>:<port>

The Catalog Information page appears.

3. Enter the connection properties to log in to the Catalog Administrator tool.

The following table describes the connection properties:

Property	Description
Catalog host	The gateway node host name.
Catalog port	The port number configured for the Catalog Service.
Protocol	Select https if you enabled a secure HTTPS connection for the Catalog Administrator tool.
Username	The user name to log in to the Catalog Administrator tool.
Password	The password to log in to the Catalog Administrator tool.

4. To view resource schedules, select Resource Schedules as the type of report.

5. To view duplicate resources, select Duplicate Resource Groups as the type of report.

6. Click Login.

View resource schedules

You can view a list of all resources in the catalog and their scan schedules using the add-on.

Click Resources with schedules to view only the resources with schedules. Click the link to a resource in the Schedule details column to view schedule details for the resource.

On the page that contains the list of resources, you can perform the following actions:

•Sort the list of resources. Sort the resources based on the resource name, resource type, resource creation time, or the last modified time of the resource.
•Filter the list of resources. Filter the displayed resources based on the resource name, resource type, resource creation time, last modified time of the resource, or the schedule creation time.

Note: You can save filter criteria. Saved filters appear in the Saved filters menu.

•Download the report. Download a report containing the list of resources and schedules to a CSV file.
•Refresh the list of resources. To refresh the list of resources, click the Re-sync icon.

View duplicate resources

You can view the resource types and the number of duplicate resource groups for each resource type from the Duplicate Resources Report page.

Click the number corresponding to a resource type to view the duplicate resource groups for the resource type. Resources that are grouped as duplicates have identical connection properties. Click Duplicate properties in the Connection properties column to view the connection properties for the resource group. The page also indicates if a metadata filter is applied to the resource.