[Launched] Generally Available: Azure Database for PostgreSQL - Azure Data Factory managed identity

-


Azure Database for PostgreSQL - Azure Data Factory Managed Identity

The Azure Database for PostgreSQL now supports managed identity for integration with Azure Data Factory, enhancing secure data integration processes. This integration leverages managed identities to authenticate connections, eliminating the need for hardcoded credentials.

Key Features of Managed Identity Integration

  • Authentication Methods: Azure Database for PostgreSQL flexible server supports various authentication methods for Azure Data Factory, including basic authentication, service principal, system-assigned managed identity, and user-assigned managed identity[2].
  • Managed Identity Benefits: Managed identities are automatically managed by Azure, reducing the complexity of credential management. They allow applications to access resources without explicitly handling credentials[1][4].
  • Azure Data Factory Capabilities: Azure Data Factory is a fully managed service designed for data integration tasks like ETL, ELT, and more. It supports connecting to Azure Database for PostgreSQL using managed identities for secure data operations[2].

Implementation Steps

To use managed identity with Azure Data Factory and Azure Database for PostgreSQL, follow these steps:

  • Configure Managed Identity: Set up a user-assigned managed identity for your Azure Data Factory or Synapse workspace. This identity will be used to authenticate to other resources[3].
  • Grant Access: Ensure that the Azure Data Factory managed identity has the necessary permissions to access the Azure Database for PostgreSQL instance. This typically involves creating a user in the database for the managed identity and assigning appropriate roles[5].
  • Integrate with Azure Data Factory: Use the managed identity to connect to Azure Database for PostgreSQL within Azure Data Factory workflows for secure data operations[2].

General Availability and Updates

The general availability of Azure Database for PostgreSQL with managed identity integration for Azure Data Factory enhances the security and efficiency of data integration processes. This update aligns with broader Azure efforts to improve data security and reduce credential management complexity across its services.

อ้างอิงค์ : https://azure.microsoft.com/updates?id=495140

ความคิดเห็น

แสดงความคิดเห็น

โพสต์ยอดนิยมจากบล็อกนี้

Retirement: MICROSOFT AZURE OPERATED BY 21VIANET - Action required to migrate to Azure China North 3 region by July 1, 2026 due to China North 1 and China East 1 region retirement

-
รูปภาพ
Retirement of Azure Regions in China Microsoft Azure operated by 21Vianet is planning significant changes to its regional infrastructure in China. Specifically, the China North 1 and China East 1 regions are scheduled for retirement. Key Points About the Retirement Retirement Date : Both China North 1 and China East 1 regions will be retired on July 1, 2026 [1]. Impact : Customers with services in these regions will experience disruptions if they do not migrate their services to other regions by the retirement date[1]. Recommended Action : Microsoft advises customers to migrate their services to alternative regions, such as China North 3 , to avoid service disruptions. Additional Service Updates Beyond the region retirement, there are other service updates relevant to Azure in China: Azure Batch Service Retirement : The Azure Batch service will also be retired on March 31, 2026 , in regions like India West , China North 1 , and China East 1 , due to regional constraints...
อ่านเพิ่มเติม

[Launched] Generally Available: Private subnet

-
รูปภาพ
Here is a structured summary of the Generally Available: Private Subnet launch announcement and key information from the official Azure Updates page referenced (https://azure.microsoft.com/updates?id=492953): General Availability of Azure Private Subnet Announcement Date: May 2025[1] Feature Status: Launched (now generally available for all Azure customers) Description: The "private subnet" feature for Azure Virtual Network is now production-ready, enabling customers to create subnets with enhanced network isolation and security. Key Benefits: Enhanced Security: Private subnets help restrict outbound internet access, reducing the risk of unauthorized data exfiltration. Explicit Internet Access: VMs in a private subnet do not have default outbound internet access, requiring explicit configuration of NAT gateways or other routes for connectivity[5]. Greater Control: Organizations gain more granular management over their Azure VM network traffic, allowing them t...
อ่านเพิ่มเติม

[Launched] Generally Available: User-managed plugin enablement in Azure Database for MySQL – Flexible Server

-
รูปภาพ
Summary of "User-managed plugin enablement in Azure Database for MySQL – Flexible Server" Key Updates: General Availability : User-managed plugin enablement is now generally available for Azure Database for MySQL – Flexible Server. Supported Plugin : Currently supports the validate_password plugin, which enforces strong password policies for enhanced security. Enable/Disable Plugins : Enable: CALL az_install_validate_password_plugin(); Disable: CALL az_uninstall_validate_password_plugin(); Configuration Management : Plugin settings can be adjusted via the Server Parameters page in the Azure portal for easier customization. Undo Log Cleanup : A new stored procedure allows manual cleanup of the Undo Log to reduce storage usage without support intervention. Default Plugin Exposure : The caching sha2 password plugin is now enabled by default and configurable through server parameters in the portal. Benefits: Provides granular control over database plugins. I...
อ่านเพิ่มเติม