Talend Administration Center 6.3.1 with Microsoft Azure DB

Talend Version          6.3.1

Summary

 How to run TAC 6.3.1 with MS Azure DB
Additional Versions  
Product  Talend Data Integration
Component  Talend Administration Center
Problem Description  
While setting up Talend Administration Center (TAC) to use AzureDB, the configuration page will throw:
500 The call failed on the server; see server log for details
if you use the official Microsoft JDBC Driver: https://msdn.microsoft.com/library/mt484311.aspx

It will also throw:
Cannot connect to database (I/O Error: DB server closed connection.)
If you use the official jTDS JDBC Driver: http://jtds.sourceforge.net/
Problem root cause  For jTDS JDBC, the URL connecting to Azure SQL DB, "ssl=require" or "ssl=request" is a must.  Default buffer size of jTDS driver is 4096 (http://jtds.sourceforge.net/faq.html), and looks like it exceeds the Azure SQL permission (at least Azure instance created by free account).

Not sure what the root cause is when using Microsoft official latest JDBC Driver.
Solution or Workaround  
Problem resolved by using the patched JTDS driver and specify the property “packetSize=512;” 
Follow the example:
database.url=jdbc:jtds:sqlserver://talendtac.database.windows.net:1433/tac;user=tadmin@talendtac.database.windows.net;password=yourpassword;ssl=require;
database.driver=net.sourceforge.jtds.jdbc.Driver
database.username=tadmin
database.password=yourpassword
Or this provided example:
URL=jdbc:jtds:sqlserver://name.database.windows.net:1433/tac631;user=tac;password=password;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;packetSize=512;
Driver=net.sourceforge.jtds.jdbc.Driver 
Username=tac 
Password=password
Download URL for the patched jTDS driver is:
https://sourceforge.net/p/jtds/bugs/_discuss/thread/16113049/7594/attachment/jtds-1.3.1.jar
Patched driver is also attached to this KB.

Related jTDS bug ID is https://sourceforge.net/p/jtds/bugs/725/?page=0
A sslhandshake pb with jTDS under JDK1.8. There is no official release yet including this fix.

Related SF Case 00066017
JIRA ticket number  https://jira.talendforge.org/browse/TMC-9599
Version History
Revision #:
1 of 1
Last update:
‎05-18-2017 09:46 PM
Updated by:
 
Labels (1)
Contributors