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

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.

tdq_ds.PNG

 

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
Version history
Revision #:
3 of 3
Last update:
‎06-09-2017 03:58 PM
Updated by:
 
Labels (1)