[source-mongodb] Is there a way currently to make MongoDB connector work? [custom certificates]

[shubhshah01]

Connector Name

source-mongodb

Connector Version

1.3.0

What step the error happened?

Configuring a new connector

Relevant information

I want to make a connection from source-mongodb -> destination-postgres.
I have a self hosted replica set MongoDB instance.
Is there any way currently to achieve this ?

1. With TLS/SSL allowed on mongo instance -> getting an error
   Caused by: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
   There is an open issue related to this probably [Epic] Custom SSL support in source-mongodb-v2 (to SSH & SSL support AWS documentDB) #33452

2. Without TLS/SSL -> doesn't work as the documentation mentions it needs to be a replica set and TLS/SSL is required.

Any help would be appreciated. Thanks!

Relevant log output

java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Connector configuration is not valid. Unable to connect: Timed out after 30000 ms while waiting to connect. Client view of cluster state is {type=UNKNOWN, servers=[{address=localhost:27017, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketWriteException: Exception sending message}, caused by {javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target}, caused by {sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target}, caused by {sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target}}]

Contribute

• Yes, I want to contribute

[shubhshah01]

Update:
For above error -> Sync Mode - Incremental | Append + Deduped
But works when changed to -> Sync Mode - Full refresh | Overwrite

[marcosmarxm]

@airbytehq/java-connector-code-reviewers can someone take a look in next grooming section?