Question
楽天カード株式会社
JP
Last activity: 9 Jan 2025 9:28 EST
Pegaから古いバージョンのSQL Serverへ接続したい ( connect to an older version of SQL Server )
皆さん、質問させてください。 現在、Pegaから外部のDB(SQL Server)にJDBC経由で接続を行いたいと考えています。
しかし接続先のSQL ServerがTLS1.0しか対応しておらず、TLS1.2以上が基本要件のPegaから接続ができません。 SQL Serverのアップデートが仕様上難しく、Pega側で対応が必要なのですが どなたか解決策をお持ちではないでしょうか。
**************** Google Translation *********************
I want to connect to an older version of SQL Server from Pega
Currently, I want to connect from Pega to an external DB (SQL Server) via JDBC. However, the SQL Server I am connecting to supports only TLS1.0, and I am unable to connect from Pega, which requires TLS1.2 or higher as a basic requirement. It is difficult to update SQL Server due to the specifications, and Pega needs to handle it. Maybe someone has a solution?
***************************************************
***Edited by Moderator Marije to change add English Translation****
Accepted Solution
Updated: 9 Jan 2025 9:28 EST
Pegasystems Inc.
GB
To connect from Pega to an external DB (SQL Server) that supports only TLS 1.0, while Pega requires TLS 1.2 or higher, you can follow the below steps to handle this situation:
1. **Configure Outbound Connection**: You can edit the rule form for outbound connections in Pega to use the appropriate protocol supported by your Pega application's underlying Java version. This will allow you to specify the TLS version for communicating with your SQL Server.
2. **TLS Best Practices**: Refer to the Transport Layer Security (TLS) best practices documentation for Pega Platform, which provides recommendations for selecting the proper TLS version when initiating outbound connections from Pega Platform to external servers and systems. You can find the documentation [here](https://docs.pega.com/bundle/platform/page/platform/security/transport_layer_security_tls_best_practices.html).
3. **TLS 1.0 Support**: While Pega Platform version 8.8 or higher supports TLS 1.2 and TLS 1.3, you may need to ensure that the TLS 1.0 support is enabled in your Pega environment to establish the connection with the SQL Server that supports only TLS 1.0.
4. **JDBC Configuration**: Ensure that your JDBC configuration in Pega is compatible with the TLS version supported by the SQL Server. You may need to adjust the JDBC settings to align with the TLS requirements of the SQL Server.
To connect from Pega to an external DB (SQL Server) that supports only TLS 1.0, while Pega requires TLS 1.2 or higher, you can follow the below steps to handle this situation:
1. **Configure Outbound Connection**: You can edit the rule form for outbound connections in Pega to use the appropriate protocol supported by your Pega application's underlying Java version. This will allow you to specify the TLS version for communicating with your SQL Server.
2. **TLS Best Practices**: Refer to the Transport Layer Security (TLS) best practices documentation for Pega Platform, which provides recommendations for selecting the proper TLS version when initiating outbound connections from Pega Platform to external servers and systems. You can find the documentation [here](https://docs.pega.com/bundle/platform/page/platform/security/transport_layer_security_tls_best_practices.html).
3. **TLS 1.0 Support**: While Pega Platform version 8.8 or higher supports TLS 1.2 and TLS 1.3, you may need to ensure that the TLS 1.0 support is enabled in your Pega environment to establish the connection with the SQL Server that supports only TLS 1.0.
4. **JDBC Configuration**: Ensure that your JDBC configuration in Pega is compatible with the TLS version supported by the SQL Server. You may need to adjust the JDBC settings to align with the TLS requirements of the SQL Server.
By following these steps and considering the TLS best practices, you can address the challenge of connecting from Pega to an older version of SQL Server that supports only TLS 1.0.
If you need further assistance, feel free to refer to the Pega Platform documentation or reach out to Pega Support for additional guidance.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.