Azure SQL Server
Connect Erathos to Azure SQL Server.
To connect to your SQL Server instance (hosted on Azure Cloud), there are some simple preliminary steps to allow your database to be accessible by our platform.
Setup
Firewall
Our IP address is 35.212.87.86.
You will need to add Erathos IP address to your firewall whitelist. Navigate to the main page of the chosen SQL Server database and select the Networking under the Security sidemenu.
Ascertain your database is not completely private by selecting Selected networks to allow public access for IPs that comply to the firewall rules. Then, add Erathos platform IP as the Start IPv4 address and End IP address and give a name easy to identify the rule's purpose at a later time. Persist the new firewall rule by clicking Save at the bottom of the page.
Credentials
In order to identify the host address of your database and the username of the server admin you can navigate to the Overview sidemenu option of the main page of the selected database, where you can find the credentials under the Essentials section.
It is also possible to locate your host address, database port, database name and admin username by navigating to Azure SQL Database > SQL databases and selecting the database you wish to use as your target data warehouse. Inside the database, select Settings > Connection strings in the sidemenu to view your credentials.
Connect to Erathos
To connect Erathos to your Azure SQL Server:
Create a New Destination
Go to Settings > Data Warehouse.
Select Azure SQL Server.
Fill Out the Form
Input your credentials, such as Host address, Database name, Server admin password Database port and Server admin username.
Advanced Connection Settings (Optional)
If you wish to establish your connection through your own server in order to restrict the direct access to the database you may also fill out the ssh credentials form. For more information, please referer to Databases connection types.
Last updated