If you use MySQL, the my.ini file of your MySQL server installation directory must be edited in order to increase the size of query packets processed by the server. For more details, please see Table 18, "Talend Data Quality Portal".
The talend_dq database exists and is correctly initialized: it contains tables such as the TDQ_PRODUCT table. The database can have another name set by the user in the Studio. Use the same name in the Portal configuration (in the server.xml file). See Editing the servertemplate file for more information.
The Talend-DQPortal-YYYYYYYY_YYYY-VA.B.C.zip file has been downloaded and unzipped.
The drivers (.jar files) corresponding to your Talend Data Quality Portal configuration database are downloaded.
Execute the script
Go to the dqportal folder.
Execute the install.sh script and follow the instructions.
If you answer yes to the last question of the install.sh script which is 'start tomcat?', the HSQL database is started automatically. However, the next time you want to start Talend Data Quality Portal, you will have to manually start the HSQL database first from the database folder of Tomcat.
Editing the servertemplate file
Open the file dqportal/resources/hsql/servertemplate to edit it.
[%TOMCAT_PORT%]with the IP address of the Tomcat server and the appropriate Tomcat server port (as set by the user) respectively.
com.mysql.jdbc.Driverif you use MySQL, or
oracle.jdbc.OracleDriverif you use Oracle, or
net.sourceforge.jtds.jdbc.Driverif you use MS SQL Server, or
org.postgresql.Driverif you use PostgreSQL.
[%TDQ_DB_URL%]with the connection URL to the data mart database.
MS SQL Server
url="jdbc:jtds:sqlserver://$ip:$dmport/$datamart" validationQuery="select 1"
$datamartin 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.
[%TDQ_DB_PASSWORD%]with the username and password of the data mart database respectively.
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.
Changing the default port used by the embedded HSQL database (optional)
Open the <TomcatPath>/database/startup.bat file to edit it.
Add the following at the end of the line:
<portNumber>is to be replaced with the port number that will be actually used by the database.
Open the <TomcatPath>/conf/server.xml file and update the port number accordingly.
Before starting Tomcat, start the HSQL database:
Go to the <TomcatPath>/database directory and execute the startup script (startup.sh).
Go to the <TomcatPath>/bin directory and launch the startup.sh, then log in to the Talend Data Quality Portal.
For more information about how to log into the portal, please see the Talend Data Quality Portal User and Administrator Guide.