Replacing the default database
When you install Talend Data Stewardship Console as a standalone application, H2 is the default embedded database. However, you have the possibility to make the console work with other databases (MySQL, Oracle, SQL Server, MSSQL, PostgreSQL, DB2, HSQL).
Open the context.xml file which can be found into the <TomcatPath>\webapps\org.talend.datastewardship\META-INF folder, where <TomcatPath> is the Tomcat installation directory.
Open the context-template.xml file in parallel to find examples of some edits to make to adapt the stewardship console to other databases, and copy the template corresponding to your database.
Paste this template into context.xml and change the properties (database URL, username and password) to suit your database.
Configuring the database if you installed the stewardship console manually
If you installed Talend Data Stewardship Console using the .war file provided by Talend, it may not be adapted to your environment.
To configure the stewardship console database, do the following.
Browse to the directory <DSC_WAR_FOLDER>\META-INF, and then create a new file context.xml under the directory.
Open the file context-template.xml in parallel to find and copy the template corresponding to the database you are using for Talend Data Stewardship Console.
Paste the template into context.xml and change the properties (database URL, username and password) to suit your database.