Preqrequisites

Whitelisting IPs that will need access to the SQL database.

This can be requested from the Professional Services team during onboarding or via a support case as required.

For new clients

We will need to determine the database objects (tables, views, etc) you want to make available, and create the database roles for this.

For migrating clients

We will use the existing database roles and SQL access as configured in your current on-premise instance.

Access

We will provide users with a server name and access credentials with which they can access the SQL server.

Access is currently not available using SQL Server Management Studio, however other database management tools such as Dbeaver can be used.