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

Overview

Before being able to 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 gives the form of the IP address you must define in the database connection in the Administrator page of the Portal to test or set the connection successfully without having any error.

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 Detail Data Source page in the Administrator page of Talend Data Quality Portal, 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 like 127.0.0.1 or the domain alias like localhost will not work.

The below table gives detail description 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 #:
1 of 1
Last update:
‎05-11-2017 11:24 PM
Updated by:
 
Labels (1)
Contributors