PostgreSQL OCF Connector Release Notes¶
Alation Cloud Service Applies to Alation Cloud Service instances of Alation
Customer Managed Applies to customer-managed instances of Alation
October 30, 2024¶
PostgreSQL OCF Connector: Version 2.0.2¶
Enhancements¶
SDK Upgrade¶
The SDK version is now upgraded to 4.9.7 along with updates to multiple packages in JVM.
This upgrade addresses the following Common Vulnerabilities and Exposures (CVEs): CVE-2024-47554, CVE-2024-9143. (AL-176849)
October 09, 2024¶
PostgreSQL OCF Connector: Version 2.0.1¶
Fixed Issues¶
QLI Fails to Extract All the Queries From a single SQL Transaction¶
QLI extracts only a single query from a list of queries from an SQL transaction that has multiple SQL statements clubbed in a single SQL transaction. If custom SQL based QLI is enabled, the query will need to be updated, refer to the connector documentation for the latest custom query SQL.
This issue is now resolved. (AL-171721)
September 18, 2024¶
PostgreSQL OCF Connector: Version 2.0.0¶
Enhancements¶
FIPS Compliance¶
The JDK is now upgraded to Temurin-11.0.24+8. This upgrade addresses the following Common Vulnerabilities and Exposures (CVEs): CVE-2024-45490, CVE-2024-45491, CVE-2024-45492, CVE-2024-6119 (AL-136725)
July 31, 2024¶
PostgreSQL OCF Connector: Version 1.3.0¶
Enhancements¶
SDK Upgrade¶
The PostgreSQL OCF connector is now upgraded to the latest SDK version 4.8.16. (AL-164544)
This upgrade addresses the following Common Vulnerabilities and Exposures (CVEs):
CVE-2022-25647, CVE-2023-2976, CVE-2020-8908, CVE-2021-22569, CVE-2021-22570, CVE-2022-3509, CVE-2022-3510, CVE-2022-3171, CVE-2021-29425, CVE-2021-37136, CVE-2021-37137, CVE-2019-20444, CVE-2021-21290, CVE-2021-43797, CVE-2022-24823, CVE-2024-29025,` CVE-2021-21295`, CVE-2021-21409, CVE-2020-11612, CVE-2019-20445, CVE-2023-34462
OpenJDK Upgrade¶
The JDK is now upgraded to Temurin-11.0.23+9. This upgrade addresses the following CVEs: CVE-2024-20952 and CVE-2023-20918 (AL-164544)
Support for Authentication Based on AWS Secret Manager Credentials¶
When installed on an Alation Agent, the PostgreSQL OCF connector supports authentication using credentials the Agent has fetched from AWS Secrets Manager. For more information, see Integration with AWS Secrets Manager for Data Source Authentication Using OCF Connector. (AL-164544)
Note
Support for authentication based on AWS Secret Manager is available for all installations (on-premise and Alation Cloud Service), however, integrating with AWS Secrets Manager through an Alation Agent applies only to cloud native architecture.
April 10, 2024¶
PostgreSQL OCF Connector: Version 1.2.1¶
Enhancements¶
With Alation version 2023.3.4 and PostgreSQL OCF connector version 1.2.0, Alation has introduced an enhanced user interface for configuring the PostgreSQL data source settings.
Note
The connector version is compatible with Alation versions prior to 2023.3.4. However, you will view the old user interface with Alation versions prior to 2023.3.4.
The documentation for the new PostgreSQL experience is available at : PostgreSQL OCF Connector.
The enhanced user interface provides the following features:
Better User Experience¶
The enhanced PostgreSQL user interface provides better navigation and multiple visual cues, making it easy to configure and manage PostgreSQL data source.
Easy to Connect¶
The PostgreSQL user interface now provides a step-by-step process to connect to your PostgreSQL data source easily and quickly.
Additional Error-Prevention Checks¶
The PostgreSQL user interface now includes added checks to avoid obvious configuration mistakes. The user interface also includes text to assist and provide cues while configuring.
Detailed Error Reports and Troubleshooting Support¶
The improved PostgreSQL user interface makes troubleshooting easier for metadata extraction and query log ingestion, as you can now have a detailed error report for both processes. The report contains a detailed error description and steps to resolve the issue. (AL-139424)
November 22, 2023¶
PostgreSQL OCF Connector: Version 1.1.11¶
Compatible Alation version: 2023.1 or higher
Fixed Issues¶
Query Log Ingestion Fails If the Custom Query Does Not Include a transactionid Column¶
From PostgreSQL OCF Connector versions 1.1.9 and 1.1.10 onwards, QLI fails if the Custom QLI Query does not include a transactionid column.
This issue is fixed. Now, in PostgreSQL OCF Connector versions 1.1.9 and 1.1.10 or higher, QLI completes successfully even if the Custom QLI Query does not include a transactionid column. However, Alation recommends that you include the transactionid column in your query to obtain accurate durations for the query.