Skip to main content Skip to complementary content

Database connection

Procedure

  1. Click Next to access the Talend Administration Center database connection panel.
    Talend Administration Center server registration page

    Refer to the Database Configuration page in Talend Administration Center to fill up the information.

    Database configuration page
  2. Select a database type among the list.
  3. Enter the database connection URL. The URL should be identical to the one used by Talend Administration Center, as mentioned above.
  4. Enter the database username and password. The user only needs a read access to the database.
  5. Similarly to the Web connection, you have the option to validate the database connection with the button.
    Test connection button
  6. Click Register to register the TAC server. The registration process triggers the collection of the inventory of the Talend Administration Center assets: Users, Groups, Projects Tasks and Plans. For large Talend Administration Center (in number of assets), such as in a DEV environment, the inventory can take several minutes.
    Register button
    Information noteTroubleshooting: If you see The Request timed out while listing the Job Conductor tasks, you can increase the default read timeout, which is two minutes, by setting the following property in start_tcmp.bat/sh: tac.config.metaservlet.read-timeout.
    SQL Server Connection with Microsoft Entra ID Authentication:
    • JTDS driver: JTDS uses the NTLM protocol to integrate with Microsoft Entra ID. This option requires that ntlmauth.dll is present in the machine system path (C:\Windows\System32, C:\Windows\System).

      If not present, the dll can be downloaded from the JTDS website. Download the zip package and extract the dll based on your OS architecture.

      For example: For 64-bits OS, the dll is located at x64/SSO/ntlmauth.dll in the zip file. Copy the dll file in the Talend Cloud Migration Platform installation folder and edit the file start_tcmp.bat to set the java.library.path system property. For example: java -Djava.library.path=<tcpm install folder> -Dserver.port=%HTTP_PORT% -jar %tcmp%.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here