Customizing and restoring the Talend DQ Portal configuration database

Talend Real-Time Big Data Platform Installation Guide for Windows

Talend Real-Time Big Data Platform
Installation and Upgrade
Talend Runtime
Talend Administration Center
Talend Installer
Talend CommandLine
Talend Artifact Repository
Talend Activity Monitoring Console
Talend Data Stewardship
Talend JobServer
Talend Studio
Talend Identity and Access Management
Talend DQ Portal
Talend ESB
Talend Log Server
Talend Data Preparation
Talend SAP RFC Server
Talend Repository Manager


  1. Open the file dqportal/script/hsql/database/tdqportal.script to edit it.
  2. Find all http://localhost:8080 and replace localhost and 8080 with the server IP address and port number if needed.
    Note: If you don't replace localhost with the server IP address, the Talend DQ Portal will not be accessible from another site.
  3. Replace tdq_utf8','','','','',60 with
    • tdq_utf8','','','','',65 if the database type is MySQL,

    • tdq_utf8','','','','',61 if the database type is Oracle,

    • tdq_utf8','','','','',63 if the database type is MS SQL Server,

    • tdq_utf8','','','','',66 if the database type is PostgreSQL.

  4. Copy the dqportal/script/hsql/database folder at the root of the Apache Tomcat installation directory.