The Data Sources page allows you to add, modify, and remove PostgreSQL and Oracle data sources on which you want to run reports. You can select data sources from a pre-defined list of installed Java Naming and Directory Interface (JNDI) data sources that the reporting server manages or define new, external Java Database Connectivity (JDBC) data sources. For a data source to be available when you run reports, you must first add it using this page.
After you add a pre-defined JNDI data source, you can use the Data Sources page to modify the display name. For JDBC data sources, you can modify the display name and the password that the Reporting Module uses to connect to the data source.
You cannot remove the pre-defined data source named IDMRPTCfgDataSource. This is the default data source that the Reporting Module uses to run reports against the internal database.
To add a data source:
Click Data Sources in the left navigation menu.
Click Add.
Select the appropriate method for connecting to the data source.
(Conditional) If you are adding a pre-defined data source, select the source from the list.
(Conditional) If you are defining a new data source, provide the following information for connecting to the data source:
Name of the data source
DNS name or IP address of the computer that hosts the data source
Whether to use SSL to connect to the data source
Port on which the data source listens
Database name
User name and password for the data source user account
(Optional) To test whether the Reporting Module can connect to the data source, click Test Connection.
A successful connection is not required to add the data source.
Click Save.
To modify a data source:
Click Data Sources in the left navigation menu.
Click the data source name, and then modify the information.
To remove a data source:
Click Data Sources in the left navigation menu.
Click Remove next to the data source you want to remove.
After you remove a data source, it is no longer available for running reports.