Whitelist client IP addresses

You can access the Datastore from the SQL Server Management Studio or any third-party tools from a client machine. However, the IP addresses of these client machines must be whitelisted to access the Datastore successfully. When you whitelist IP addresses, these addresses are considered as trusted addresses. You can define a single IP address or a range of IP addresses.

Whitelist a client IP address

Important: To whitelist reporting databases, ensure that the Reporting Analytics User role is assigned for the reporting database. To learn how to assign the Reporting Analytics User role, refer to Assign group and roles.

1. From the BI Gateway Model Builder Home Page, click in the upper right corner.

   A list with options appears. The current account is displayed.

   

2. Click Whitelist Client IP.

   The Firewall Rules dialog box appears.

   

3. Click +.

4. In the Firewall Rule Name box, type the name for the rule.

5. In the Start IP box, type the start IP address.

6. In the End IP box, type the end IP address range. This is the IP address at which the whitelisting ends.

   Note:
   - If you want to whitelist only one IP address, then enter the same IP address in the Start IP and End IP boxes. However, if you want to whitelist a range of IP addresses, enter the start IP address and end IP address range in the Start IP and End IP boxes.
   - We recommend that you do not whitelist the entire range of IP addresses from 0.0.0.0 to 255.255.255.255 to avoid any security risks.

7. Click Save.

   The selected IP addresses are whitelisted.

Edit an IP address

8. From the BI Gateway Model Builder Home Page, click in the upper right corner.

   A list with options appears.

9. Click Whitelist Client IP.

   The Firewall Rules dialog box appears with a list of the defined rules.

10. From the list of rules, edit the start and end IP addresses in the Start IP and End IP boxes, respectively, for the required rule.

11. Click Save.

    The selected IP addresses are whitelisted.

Delete an IP address

12. From the BI Gateway Model Builder Home Page, click in the upper right corner.

    A list with options appears.

13. Click Whitelist Client IP.

    The Firewall Rules dialog box appears with a list of the defined rules.

14. Click the icon in the row of the rule that you want to delete.

    The selected rule is deleted.