Solved: Data fusion replication job sql connection issue - Page 2

binrip · 05-03-2023 09:45 PM

Hi

Im trying to build data fusion replication job from ms sql server (cloud sql) to big query. Both data fusion and cloud sql instances is using private IP. I have configured peering from both tenant project to VPC network and setup sql-auth proxy. Now i'm able to reach to cloud sql instance from data fusion when i create standard pipeline using source ms sql connector and sink big query connector. Pipeline run successfully without any issue.
But when i try to run replication job it gives me this error when i setup the source (same sql instance mentioned earlier)

The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:

here is my cloud sql instance configuration

I'm using JDBC driver Version 12.2. Please help me to solve this issue.

binrip

Hi @guillermo56 ,

Your using JDBC driver version 12 downloaded from Microsoft? or the driver available on data fusion HUB? Initially i was downloaded the JDBC driver version 12 from Microsoft website and deploy it to data fusion. It gives me this error. So, i removed all the installed JDBC drivers from the data fusion and install the JDBC driver from the data fusion HUB. It resolved this issue for me.

To Delete a JDBC driver

Access the Cloud Data Fusion graphical interface. Go to the Cloud Data Fusion Control Center.
View your JDBC driver. In the Filter by dropdown, select Artifacts.
In the artifact card of your JDBC driver, click the trash button at the bottom

Please check the last section of this article, it explain how to deploy the driver using the HUB.Connect Private Data Fusion instance with a Private Cloud SQL instance using CloudSQL proxy | by Dan...

Please let me know if this resolves the issue.

Regards

View solution in original post