Connect SQL Endpoint Fabric Lakehouse to Talend Open Studio 7.1

[emgravey]

Hello, 

I would need support to connect to a Fabric Lakehouse SQL Endpoint using Talend Open Studio version 7.1.

I am using an SQL Server connector but I have this error message and I am not able to find the right connection parameters to connect:

Did someone already achieve this connection?

Thanks

Emmanuelle

[emgravey]

Hello, 

We have downloaded Talend Open Studio 8.0 and now we have this error: 

@burakkaragoz have you go some idea? 

Thanks

Emmanuelle

[v-csrikanth]

Hi @emgravey 
I am sorry to hear that you issue was not resolved by the given approaches.Can you please raise a Microsoft support ticket. You can create a Microsoft support ticket using the link below.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.

Hope this works for you!

Thanks.

[v-csrikanth]

Hi @emgravey 

I wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!

Best Regards,
Community Support Team _ C Srikanth.

[emgravey]

My issue is not yet solved 😞 

[v-csrikanth]

Hi @emgravey 
Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!

Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @emgravey 

We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @emgravey 
Thanks for reaching out to fabric community.

To enable Azure AD–based authentication for a Fabric Lakehouse SQL Endpoint in Talend Open Studio, you must first install the Microsoft JDBC Driver for SQL Server (v9.2 or later) by placing its JAR file into Talend’s lib/java folder and restarting the Studio.

Next, in your Metadata → Database Connections entry (or directly on your tMSSqlConnection component), specify the driver class com.microsoft.sqlserver.jdbc.SQLServerDriver and use a JDBC URL of the form:
*****************************************************************************
jdbc:sqlserver://<your-endpoint>.sql.azuresynapse.net:1433;
database=<your-db>;
encrypt=true;
trustServerCertificate=false;
hostNameInCertificate=*.fabric.microsoft.com;
authentication=ActiveDirectoryInteractive
*****************************************************************************

If you prefer username/password authentication, replace the last parameter with authentication=ActiveDirectoryPassword. To authenticate with a service principal, use authentication=ActiveDirectoryServicePrincipal and include user=<appId>;password=<appSecret> in the URL.

For token-based authentication, obtain an Azure AD access token (for example via the MSAL4J library or Azure CLI) and supply it under “Additional JDBC parameters” as accessToken=<token>
Note per token must be set on the JDBC connection properties rather than embedded in the URL. Finally, test the connection in Talend to confirm that the driver, URL and authentication settings work correctly.

For full details on supported authentication modes, see Microsoft’s JDBC driver documentation at https://learn.microsoft.com/sql/connect/jdbc/connecting-using-azure-active-directory-authentication?... 

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[burakkaragoz]

Hi @emgravey ,

Thanks for raising this. Connecting Talend to a Fabric Lakehouse SQL Endpoint can be a bit tricky since it's not a traditional SQL Server, even though it uses the TDS protocol.

Here are a few things to check:

1. Driver: Make sure you're using the latest Microsoft JDBC Driver for SQL Server (not the legacy one bundled with Talend 7.1).
2. Connection String: Use the full SQL Endpoint URL from Fabric, and make sure it includes encrypt=true;trustServerCertificate=false; in the connection properties.
3. Authentication: Fabric endpoints typically require Azure AD authentication. Talend 7.1 might not support this natively. You may need to use a service principal or token-based auth if supported.
4. Port: Confirm you're connecting over port 1433.

If Talend doesn’t support Azure AD auth directly, one workaround is to use a small Python or .NET bridge that authenticates and passes the data to Talend.

Let me know what error message you're getting exactly. I can help troubleshoot further with that.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

[emgravey]

Hello

Can't you see my screenshot about error message and connection information in the post?

let me know 🙂

Thanks
Emmanuelle

[burakkaragoz]

You're trying to connect Talend Open Studio 7.1 to a Fabric Lakehouse SQL Endpoint using the JTDS driver, but you're getting a No suitable driver found error. That’s expected because:

1. JTDS is outdated and doesn’t support modern SQL Server features like Azure AD authentication or encrypted connections required by Fabric endpoints.
2. You're using a Fabric SQL Endpoint, which behaves like Azure SQL, not a traditional SQL Server.

Here’s what you should try:

• Switch to the Microsoft JDBC Driver for SQL Server instead of JTDS. Talend supports it, and it’s better suited for Azure-based services.
• Update your JDBC URL to something like this:

  jdbc:sqlserver://<your-host>.datawarehouse.fabric.azure.com:1433;database=<your-db>;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.fabric.microsoft.com;authentication=ActiveDirectoryInteractive

• Make sure you have the Microsoft JDBC Driver added to Talend’s library path. You can download it from Microsoft’s official site.
• If you're using Azure AD authentication, you might need to configure Talend to support token-based or interactive login, depending on your setup.

Let me know if you need help setting up the driver or adjusting the connection string.

[emgravey]

Can you give me more details on this point :

"

• If you're using Azure AD authentication, you might need to configure Talend to support token-based or interactive login, depending on your setup." 

Where can we configure Talend to support Token-based or interactive login? 

Thank you for your help 

[emgravey]

@burakkaragoz could you help? Thanks 🙂

[burakkaragoz]

@emgravey ,

Thanks for clarifying your question and sharing the error details.

You’re right: the main blocker is that Fabric Lakehouse SQL Endpoints require Azure AD authentication and encrypted connections, but Talend Open Studio 7.1 with the JTDS driver does not support these modern requirements.

Here’s what you need to do, step by step:

1. Switch to the Microsoft JDBC Driver (not JTDS):

   • Download the latest Microsoft JDBC Driver for SQL Server from the official site.
   • Add it to Talend’s library path (Talend > Preferences > Java > Installed JREs > Add External JARs).

2. Update your connection string:

   • Use the full Fabric SQL Endpoint URL, and make sure your JDBC string looks like:
     Code

     jdbc:sqlserver://<your-fabric-sql-endpoint>.database.windows.net:1433;database=<your-db>;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;

3. Authentication – Azure AD:

   • Unfortunately, Talend Open Studio 7.1 does not natively support Azure AD (token-based) authentication via the connection UI.
   • Option 1: If your organization allows, create a SQL user with username/password (not recommended for production, but works for quick tests).
   • Option 2 (recommended): Use an “Access Token” as the password in the Talend connection.
     • You need to obtain an Azure AD access token (using Azure CLI or a service principal).
     • In Talend, set the username as your Azure AD email, and paste the access token in the password field.
     • Example (using Azure CLI for token):
       Code

       az account get-access-token --resource https://database.windows.net/

       Copy the accessToken from the result.

4. Where to configure in Talend:

   • In your DB connection component, select “Microsoft SQL Server (JDBC)”.

   • For authentication, set:

     • Username: your Azure AD email
     • Password: paste the access token

   • You may need to enable “Use Authentication” and look for “Active Directory Password” or “Active Directory Interactive” if your Talend version supports it. If not, only the access-token-in-password approach works.

5. If you need to automate token retrieval:

   • For production, consider scripting the token retrieval and injecting it into Talend jobs using context variables.

Extra tips:

• Always use encrypt=true and trustServerCertificate=false for secure connections.
• Make sure outbound port 1433 is open on your network.

Let me know if you get stuck on the token step, or if you see a different error after this setup. If you need a quick step-by-step with screenshots, I can provide that as well!

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

[emgravey]

Hi @burakkaragoz 

We have an issue because the token is more than 128 caracters and talend is limiting the password to 128. 

Any idea 🙂 ?

Thanks a lot for your support

Emmanuelle