For the Private Cloud deployment plan, a customer gets read-only access from a static IP address range to a dedicated database in our MS Azure infrastructure. It allows using reporting tools such as Tableau, Micro Strategy, MS Excel, or free tools like Power BI Desktop or MS Server Management Studio.
Here is the process.
- A customer provides us with an IP address or a range of IP addresses that we add to the whitelist.
- We provide the following information to a customer:
- SQL server name
- Database name
- Login
- Password
The following example shows how to enter the provided information in MS Server Management Studio.
On the "Connect to Server" screen, enter the SQL Server name, Login and Password:
On the Options screen, enter the database name and click Connect: