To add a SQL Connection, go to the Connections page which is accessed via Menu -> Connected Data -> Connections.

NOTE: SQL connections are only available on Premium accounts.



You must be an Administrator level user to see this option. 

  • Click the ADD CONNECTION button on the top right of the page to add a new connection.
    This will bring up a list of connections that you can choose from.





NOTE: Windows Authentication is NOT supported; you must include username and password credentials in the string.


The SQL user specified MUST have at least db_ddladmin and db_datawriter database-level roles assigned.

For simplest configuration, grant db_owner role to the user. 


IMPORTANT: You must configure your database firewall to accept connections from our cloud servers.  Here is a list of our IP addresses:


All USA hosted cloud services currently run behind IP addresses: 

  • 137.135.90.98
  • 137.135.88.12


All Australia hosted cloud services currently run behind IP addresses: 

  • 13.75.159.117
  • 13.73.195.148


All Europe hosted cloud services currently run behind IP addresses: 

  • 13.95.226.227
  • 40.115.50.242


For any incoming connections from our servers to yours, please instruct your IT team to whitelist the above IPs (depending on where your account is hosted) to ensure reliable connectivity through corporate firewalls.



Click the SAVE button on the top right of the page to store your configuration.


Your connection will be verified automatically - you will see a green tick if everything is working.