This topic describes how to configure a database whitelist in DataV. Before you can add a data source in DataV, you must add the configure a whitelist for your database to ensure that DataV has access to it.

  • If you are using a data source from Alibaba Cloud RDS database, see Configure a whitelist. Add the following IP addresses to the whitelist of your RDS database.
  • If you are using a data source from Alibaba Cloud ECS database, you must add the following IP addresses to the whitelist of the ECS security group rules, system firewalls, and your database.
  • If you are using a data source from the database on a local physical machine, you must add the following IP addresses to the whitelist of the system firewalls of this physical machine, the network firewalls, and your database.

According to your database connection scenarios, add the following IP addresses to the whitelist of your database.

Internet

Region Whitelist
Singapore 47.88.235.235/0,47.74.136.56/0,47.88.250.141/0,47.88.235.217/0,47.74.136.64/0,47.74.136.22/0,47.74.136.12/0,47.88.235.207/0
Malaysia 47.254.212.25/0
Japan (Tokyo) 47.91.9.73/0,47.91.13.92/0,47.91.9.1/0,47.91.9.42/0
Germany 47.91.83.106/0,47.91.82.104/0,47.91.84.120/0,47.91.84.16/0,47.91.84.36/0
Hong Kong 47.90.68.215/0,47.75.228.154/0,47.91.171.160/0,47.90.68.160/0,47.75.228.234/0,47.91.172.161/0,47.91.172.151/0
US (Silicon Valley) 47.88.99.201/0,47.254.58.179/0,47.88.99.83/0,47.88.108.155/0,47.88.99.128/0
US (Virginia) 47.89.170.94/0,47.89.170.79/0,47.89.170.80/0,47.89.170.71/0,47.89.170.97/0

Intranet classic network

Region Whitelist
Singapore 11.193.8.8/0,11.192.152.94/0,11.193.8.55/0,11.193.8.59/0,10.152.165.219/0,11.192.152.89/0,11.192.152.117/0,11.193.8.60/0
Malaysia 11.193.189.75/0,11.193.189.69/0,11.193.189.73/0,11.193.189.72/0
Japan (Tokyo) 11.192.149.155/0,11.192.149.118/0,11.192.147.75/0,11.192.149.66/0
Germany 11.192.169.2/0,11.192.168.143/0,11.193.107.16/0,11.192.170.80/0,11.192.170.221/0
Hong Kong 11.193.118.80/0,11.193.118.65/0,11.193.12.4/0,11.193.118.48/0,11.193.118.86/0,11.193.11.239/0,11.193.11.200/0
US (Silicon Valley) 11.193.216.239/0,11.193.216.224/0,11.193.216.227/0,11.193.216.234/0,11.193.216.184/0
US (Virginia) 10.152.235.192/0,10.152.235.29/0,10.152.235.171/0,10.152.235.194/0,10.152.235.191/0
Notice You may encounter the disconnection of 11 network segments when you configure the whitelist of Intranet classic network. To solve this problem, see Solution to disconnection of 11 network segments..

Intranet VPC network

Region Whitelist
Singapore 100.104.13.0/24
Malaysia 100.104.133.64/26
Japan (Tokyo) 100.104.175.0/24
Germany 100.104.244.192/26
Hong Kong 100.104.188.0/24
US (Silicon Valley) 100.104.144.0/26
US (Virginia) 100.104.89.64/26

Solution to disconnection of 11 network segments.

If you encounter the disconnection of 11 network segments, execute the following command to add a router in /etc/rc.local.
sudo route add -net 11.0.0.0/8 gw 10.152.28.247
Note The IP address behind gw is the server gateway.

If the problem is unresolved, you can open a ticket and send it to ECS to inform Alibaba Cloud technical support engineers that the 11 network segments are unable to access your server.