Customizing and restoring the Talend DQ Portal configuration database - 7.0

Talend MDM Platform Installation Guide for Windows

EnrichVersion
7.0
EnrichProdName
Talend MDM Platform
task
Installation and Upgrade
EnrichPlatform
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend DQ Portal
Talend ESB
Talend Identity and Access Management
Talend Installer
Talend JobServer
Talend Log Server
Talend MDM Server
Talend MDM Web UI
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio

Procedure

  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.