If you selected the endpoint connection method when creating a data source with Azure as the cloud vendor, you need to configure it first. This topic describes how to configure it to obtain the connection information.
Azure Database for MySQL
Create an Azure Database for MySQL instance
On the Azure Database for MySQL Flexible Server page, click + Create.
On the Select Azure Database for MySQL Deployment Options page, select Flexible Server > Advanced Creation.
On the Flexible Server > Basic page, configure the parameters.
ParameterDescriptionSubscription Select the target Azure subscription from the drop-down list. Resource Group Select the target resource group from the drop-down list. Server Name Customize the server name. It can contain lowercase letters, numbers, and hyphens (-), and must be 3 to 63 characters long. Region/MySQL Version/Workload Type/Compute + Storage/Availability Zone Select as needed. High Availability Choose whether to enable high availability as needed. Authentication Select MySQL Authentication Only. Administrator Login Name/Password/Confirm Password Enter the information as appropriate. Click Next: Networking. On the Flexible Server > Network page, configure the parameters.
ParameterDescriptionConnection Method Select Public Access (Allowed IP Addresses) and Private Endpoint. Public Access/Firewall Rules Configure public access and firewall rules as needed. Private Endpoint You can create this later. Click Next: Security. On the Flexible Server > Security page, use the default configuration and click Next: Tags.
On the Flexible Server > Tags page, create tags as needed. Click Next: Review + create.
On the Flexible Server > Review + create page, verify the configurations and click Create.
After creation, go to the details page. In the left navigation bar, click Settings > Server Parameters and set
require_secure_transporttoOFF.Create a new virtual network.
Go to the Virtual Networks page and click + Create.
On the Create Virtual Network > Basic Information page, configure the parameters.
Click Review + create.
On the Create Virtual Network > Review + create page, verify the configurations and click Create.
Create or add a private endpoint for an Azure Database for MySQL instance
Create a private endpoint
On the Private endpoints page, click Create.
On the Create Private Endpoint > Basics page, configure the parameters.
ParameterDescriptionSubscription Select the target Azure subscription from the drop-down list. Resource Group Select the target resource group from the drop-down list. Name The name of the private endpoint. It must start with a letter or number, end with a letter, number, or underscore (), and can only contain letters, numbers, underscores (), dots (.), or hyphens (-). Network Interface Name The custom name of the network interface. It must start with a letter or number, end with a letter, number, or underscore (), and can only contain letters, numbers, underscores (), dots (.), or hyphens (-). Region Select the target region. Click Next: Resource. On the Create Private Endpoint > Resource page, configure the parameters as needed. The target resource cannot be changed and should remain at its default value.
Click Next: Virtual Network. On the Create Private Endpoint > Virtual Network page, select the virtual network and subnet as needed.
Click Next: DNS. On the Create Private Endpoint > DNS page, select Integrate with Private DNS Zone as No.
Click Next: Tags. On the Create Private Endpoint > Tags page, create tags as needed.
Click Next: Review + create. On the Create Private Endpoint > Review + create page, verify that all configurations are correct and click Create.
Add a private endpoint to an existing Azure Database for MySQL instance
On the Azure Database for MySQL Flexible Server page, click the name of the target server to go to its Overview page.
In the left-side navigation pane, click Settings > Network.
In the Private Endpoint section, click + Create Private Endpoint.
On the Create Private Endpoint > Basics page, customize the Name and Network Interface Name.
Click Next: Resource. On the Create Private Endpoint > Resource page, the target resource cannot be changed and should remain at its default value.
No further configuration is required on subsequent pages. Click Next to proceed to the Create a private endpoint > Review + create page.
After confirming all configurations are correct, click Create.
Use a private endpoint
After you create or add a private endpoint for Azure Database for MySQL, you need to copy the Resource ID and enter it in the Connection Information section on the Create Data Source page. For details about creating a data source, see Create a data source.
To copy the resource ID, perform the following steps:
Log in to the Azure Database for MySQL Flexible Server page.
Click the name of the target server to go to its Overview page.
In the Summary section, click JSON View in the upper-right corner.
On the Resource JSON page, click the copy icon next to Resource ID.
If the data source connection test fails and prompts you to accept the incoming connection request in the Azure console, perform the following operations:
Log in to the Azure Database for MySQL Flexible Server page.
Click the name of the target server to go to its Overview page.
In the left-side navigation pane, click Settings > Network.
In the Private Endpoints section, select the target private endpoint and click Approve.
After the private endpoint is approved and the connection succeeds, return to the Create Data Source page and retest the connection.
Self-managed MySQL/Oracle databases
Create a load balancer
Log in to the Load Balancers page and click + Create > Standard Load Balancer.
On the Create Load Balancer > Basic page, configure the parameters.
ParameterDescriptionSubscription Select the target Azure subscription from the drop-down list. Resource Group Select the target resource group from the drop-down list. Name The custom name of the load balancer. It must start with a letter or number, end with a letter, number, or underscore (), and can only contain letters, numbers, underscores (), dots (.), or hyphens (-). Region Select as needed. SKU Select Standard. Type Select Internal. Layer Select Regional. Click Next: Frontend IP Configuration. On the Create Load Balancer > Frontend IP Configuration page, click + Add Frontend IP Configuration.
In the Add Frontend IP Configuration dialog box, configure the parameters. After configuration, click Save.
ParameterDescriptionName The custom name of the frontend IP configuration. It must start with a letter or number, end with a letter, number, or underscore (), and can only contain letters, numbers, underscores (), dots (.), or hyphens (-). IP Version Select IPv4. Virtual Network The virtual network where the self-managed database is located. Subnet Select the correct subnet from the drop-down list. Allocation Select Dynamic. Availability Zone Select No Zone. Click Next: Backend Pool. On the Create Load Balancer > Backend Pool page, click + Add Backend Pool.
On the Add Backend Pool page, configure the parameters. After configuration, click Save.
ParameterDescriptionName The custom name of the backend pool. It must start with a letter or number, end with a letter, number, or underscore (), and can only contain letters, numbers, underscores (), dots (.), or hyphens (-). Virtual Network The virtual network where the self-managed database is located. Backend Pool Configuration Select NIC. No further configuration is required on subsequent pages. Click Next in sequence to enter the Create Load Balancer > Review + create page.
After confirming that all configurations are correct, click Create.
Create a Private Link service
Go to the Private Link services page and click + Create.
On the Create Private Link Service > Basics page, configure the parameters.
ParameterDescriptionSubscription Select the target Azure subscription from the drop-down list. Resource Group Select the target resource group from the drop-down list. Name Customize the name of the Private Link service. It must start with a letter or number, end with a letter, number, or underscore (), and can only contain letters, numbers, underscores (), dots (.), or hyphens (-). The length must be 2 to 64 characters. Region Select as needed. Click Next: Outbound Settings. On the Create Private Link Service > Outbound Settings page, configure the parameters.
ParameterDescriptionLoad Balancer Select the created load balancer from the drop-down list. Load Balancer Frontend IP Address Select the frontend IP address of the load balancer from the drop-down list. Source NAT Subnet Select the subnet for allocating the NAT IP address from the drop-down list. Enable TCP Proxy V2 Choose whether to enable TCP Proxy V2 as needed. Private IP Address Settings Select Dynamic. No configuration is required on subsequent pages. Click Next in sequence to go to the Create Private Link Service > Review + create page.
After confirming all configurations are correct, click Create.
Use a Private Link service
After creating a Private Link service, copy its Resource ID and enter it in the Azure > Endpoint > Connection Information fields on the Create Data Source page. For details, see Create a data source.
To copy the resource ID, perform the following steps:
Go to the Private Link services page.
Click the name of the target Private Link service to go to its Overview page.
In the Summary section, click JSON View in the upper-right corner.
On the Resource JSON page, click the copy icon next to Resource ID.
If the data source connection test fails and prompts you to enter the Azure console to accept the received connection request, perform the following operations:
Go to the Private Link services page.
Click the name of the target Private Link service to go to its Overview page.
In the left navigation pane, click Settings > Private endpoint connections.
Select the target private endpoint and click Approve.
In the Approve connection dialog box, click Yes.
After the private endpoint connection is approved, return to the new data source creation page to retest the connection.