Add SSL/TLS support in Oracle Batch Source Classes
This PR introduces a new field, useSSL, to enable SSL (TLS) connections for Oracle by allowing the specification of protocol (tcp or tcps) in the connection string format.
Key Changes
New field
useSSL (Allows to specify whether SSL (TLS) should be used for connections or not )
If useSSL is set to yes, the protocol in the connection string is set to tcps. Otherwise, it defaults to tcp.
Connection String Format Updated:
For SID-based connections: jdbc:oracle:thin:@tcps or @tcp ://<host>:<port>/<SID>
For Service Name-based connections: : jdbc:oracle:thin:tcps or @tcp ://<host>:<port>/<ServiceName>
Testing Scope
Validated TCP protocol connectivity:
Verified that the connection works as expected when specifying protocol as tcp explicitly in the connection string to ensure backward compatibility with existing behavior.
Validated TCPS protocol connectivity:
Conducted internal tests with tcps to ensure secure connections (SSL/TLS) are correctly established and that the updated connection string format handles this protocol appropriately.
Add SSL/TLS support in Oracle Batch Source Classes
This PR introduces a new field,
useSSL
, to enable SSL (TLS) connections for Oracle by allowing the specification of protocol (tcp or tcps) in the connection string format.Key Changes
useSSL (Allows to specify whether SSL (TLS) should be used for connections or not )
If useSSL is set to yes, the protocol in the connection string is set to tcps. Otherwise, it defaults to tcp.
For SID-based connections:
jdbc:oracle:thin:@tcps or @tcp ://<host>:<port>/<SID>
For Service Name-based connections: :
jdbc:oracle:thin:tcps or @tcp ://<host>:<port>/<ServiceName>
Testing Scope
Validated TCP protocol connectivity: Verified that the connection works as expected when specifying protocol as tcp explicitly in the connection string to ensure backward compatibility with existing behavior.
Validated TCPS protocol connectivity: Conducted internal tests with tcps to ensure secure connections (SSL/TLS) are correctly established and that the updated connection string format handles this protocol appropriately.