Data sources cannot be tested and set correctly in the Administrator page of the Portal

[TalendSolutionExpert]

Overview

Before you can use Talend Data Quality Portal as a web-based monitoring and reporting tool of data quality metrics, you must define the data source that holds the technical data to be used in document templates. You can test this connection before saving it.

This article shows the form of the IP address you must define in the database connection on the Administrator page of the Portal.

Environment

This article applies to Talend Data Quality Portal versions prior to 6.2.1.

Symptoms/Description

When you define the database URL or JNDI name from the Talend Data Quality Portal > Administrator page > Detail Data Source page, you may get an error when you try to test the connection before saving it if you do not use the correct form of the IP address with different web browsers. This is due to some limitations on the use of some browsers by SpagoBI.

Resolution

When you define the connection to the data source, you must use internet or public IP addresses to connect successfully using web browsers. IP addresses like 127.0.0.1 or domain aliases like localhost will not work.

The following table gives detailed descriptions of supported browsers and IP forms:

	Win 7			Ubuntu		Mac
	IP	localhost	127.0.0.1	IP	127.0.0.1/localhost	IP
Firefox (29.01)	yes	no	no	not tested	not tested	unavailable browser
IE 8 (8.0)	yes (browser on XP)	not tested	not tested	unavailable browser	unavailable browser	unavailable browser
IE 9	not tested	not tested	not tested	unavailable browser	unavailable browser	unavailable browser
IE 10 (10.0.9200)	no	no	no	unavailable browser	unavailable browser	unavailable browser
IE 11 (11.0.9600.16476)	yes	no	no	unavailable browser	unavailable browser	unavailable browser
Google Chrome (35.0.1916.114 m)	yes	no	no	not tested	not tested	unavailable browser
Opera (21.0)	yes	no	no	yes	no	yes
Safari (7.0)	not tested	not tested	not tested	unavailable browser	unavailable browser	yes