Editing the servertemplate file - 7.3

Talend Installation Guide
Version
7.3
Language
English
EnrichDitaval
Linux
EnrichSubscriptionType
Subscription
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
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 LogServer
Talend MDM Server
Talend MDM Web UI
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio
Content
Installation and Upgrade
Deprecated
Available in...

Big Data Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

Procedure

  1. Open the dqportal/resources/hsql/servertemplate file to edit it.
  2. Replace [%TOMCAT_IP%] and [%TOMCAT_PORT%] with the IP address of the Apache Tomcat server and the appropriate SApache Tomcat server port (as set by the user) respectively.
  3. Replace [%TDQ_DB_DRIVER_CLASS_NAME%] with

    • com.mysql.jdbc.Driver if you use MySQL,

    • oracle.jdbc.OracleDriver if you use Oracle,

    • net.sourceforge.jtds.jdbc.Driver if you use MS SQL Server,

    • org.postgresql.Driver if you use PostgreSQL.

  4. Replace [%TDQ_DB_URL%] with the connection URL to the data mart database.

    Database Type

    Connection URL

    MySQL

    jdbc:mysql://$ip:$dmport/$datamart?characterEncoding=UTF8&useOldAliasMetadataBehavior=true

    Oracle

    jdbc:oracle:thin:@$ip:$dmport:$datamart

    MS SQL Server

    url="jdbc:jtds:sqlserver://$ip:$dmport/$datamart" validationQuery="select 1"

    PostgreSQL

    jdbc:postgresql://$ip:$dmport/$datamart

    Note that $ip, $dmport and $datamart in the connection URL need to be replaced with the IP address, port number, and name of the data mart database respectively. By default, the database created by the Studio is named talend_dq. Make sure you use the same database name in the connection URL and in the Studio. For further information about setting up a distant database from the studio, see Talend Studio User Guide.
  5. Replace [%TDQ_DB_USERNAME%] and [%TDQ_DB_PASSWORD%] with the username and password of the data mart database respectively.
  6. Delete [%VALIDATION_QUERY%].
  7. In <Environment name="spagobi_resource_path" type="java.lang.String" value="../resources"/>, replace ../resources by the absolute file path.
    For example: value="C:/Program Files/Tomcat 9.0/resources"
  8. Copy the content of the servertemplate file inside the <GlobalNamingResources> part of the <TomcatPath>/conf/server.xml file, then save your edits before closing the file.