Regarding jdbc url parameters for MSSQL Connector

Connector Development
1

Hi Team, we are using airbyte 0.35.60-alpha verion running in kubernetes, we have question regarding jdbc url parameters for MSSQL Connector.

We have to connect to source MSSQL server where we have to pass additional jdbc url parameters for directing the queries to read replicas instead of primary node.

This can be acheived by passing additional parameters with primary node string.
ApplicationIntent=ReadOnly;MultiSubnetFailover=True

The above parameters would direct the queries to read replicas.

However, there is no option for passing these parameters for MSSQL connector(I see the option is enabled for snowflake connector in airbyte), Can the connection string be constructed in such a way that connections can be offload to the ReadReplica by passing above parameter for MSSQL connector? (just like snowflake connector)

Thanks,
Kiran

2

Please upgrade connector to version 0.1.18 version? The JDBC parameter is available in this version, in 0.1.19 is not showing because of a bug. I’m going to work to fix it.

3

Thanks Team. I am able to update connector and able to pass the jdbc url parameters.

1 Like
4

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.