# Database connection

## Procedure

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

   ![Talend Administration Center server registration page](https://help.qlik.com/Resources/Images/qlik-talend-cloud-migration-toolkit-user-guide/tac_registration3.png)

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

   ![Database configuration page](https://help.qlik.com/Resources/Images/qlik-talend-cloud-migration-toolkit-user-guide/tac_database_admin.png)
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](https://help.qlik.com/Resources/Images/qlik-talend-cloud-migration-toolkit-user-guide/check_cnnection_btn.png)
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](https://help.qlik.com/Resources/Images/qlik-talend-cloud-migration-toolkit-user-guide/register_btn.png)

   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\_qtcmt.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](http://jtds.sourceforge.net/). 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 Qlik Talend Cloud Migration Toolkit installation folder and edit the file start\_qtcmt.bat to set the java.library.path system property. For example: java -Djava.library.path=<qtcmt install folder> -Dserver.port=%HTTP\_PORT% -jar %qtcmt%.
   * Microsoft Driver: Refer to the Microsoft JDBC documentation on [Connecting with Integrated Authentication](https://docs.microsoft.com/en-us/previous-versions/sql/legacy/ms378428%28v=sql.100%29#connecting-with-integrated-authentication).