Changing Talend Identity and Access Management database - 6.4

Talend Real-time Big Data Platform Installation Guide for Linux

EnrichVersion
6.4
EnrichProdName
Talend Real-Time Big Data 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 Management
Talend Installer
Talend JobServer
Talend Log Server
Talend Project Audit
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio

As the embedded H2 database is not recommended for production environments, it is advised to change the Talend Identity and Access Management database.

Talend Identity and Access Management uses two different databases:

  • One for the OpenId Connect service: oidc

  • One for the Fediz Identity Provider: idp

  1. Stop Talend Identity and Access Management if it has been already started.

  2. Place the JDBC driver jar file corresponding to the database you want to use in the iam-A.B.C/apache-tomcat-x.x.xx/lib folder and make sure that it has the same permissions as the other jar files.

    For more information on the supported databases, see Compatible Databases.

  3. Update the provisioning.properties and domains/Master.properties files as described in Apache Syncope documentation.

  4. Edit the iam-A.B.C/apache-tomcat-x.x.xx/conf/iam.properties file and update the following parameters:

    Parameter

    Description

    idp.db.url

    IDP database JDBC URL.

    idp.db.driverClassName

    Fully qualified driver class name, com.mysql.jdbc.Driver for example.

    idp.db.username

    User name used to connect to the IDP database.

    idp.db.password

    Password used to connect to the IDP database.

    The password is encrypted at first launch.

    idp.db.platform

    OpenJPA 2.4.2 platform name without the package name, MariaDBDictionary for example.

    For more information, see https://openjpa.apache.org/builds/2.4.2/apidocs/org/apache/openjpa/jdbc/sql/DBDictionary.html.

    oidc.db.url

    OIDC database JDBC URL.

    oidc.db.driverClassName

    Fully qualified driver class name, com.mysql.jdbc.Driver for example.

    oidc.db.username

    User name used to connect to the OIDC database.

    oidc.db.password

    Password used to connect to the OIDC database.

    The password is encrypted at first launch.

    oidc.db.databasePlatform

    Hibernate 5 platform name.

    For more information, see https://docs.jboss.org/hibernate/orm/5.2/javadocs/.

    oidc.db.dialect

    Hibernate 5 dialect for the database.

    For more information, see https://docs.jboss.org/hibernate/orm/5.2/javadocs/.

  5. Start Talend Identity and Access Management by executing the startup.sh file.