Azure Synapse Analytics

​

Database Connection

​

Step 1: Locate Your SQL Endpoint

1. Open the Azure Portal and go to your Synapse workspace
2. On the Overview page, find the SQL endpoint under Dedicated SQL endpoint
3. The endpoint has the format <workspace-name>.sql.azuresynapse.net

​

Step 2: Configure Firewall Rules

1. In your Synapse workspace, go to Networking (or Firewalls and virtual networks)
2. Add BonData’s IP addresses to the allowed IP range
3. Ensure Allow Azure services and resources to access this workspace is configured as required by your security policy
4. Save the changes

​

Step 3: Create a SQL Login and User (Recommended)

-- In the master database, create a login
CREATE LOGIN bondata_user WITH PASSWORD = 'your_secure_password';

-- In your dedicated SQL pool, create a user mapped to the login
CREATE USER bondata_user FOR LOGIN bondata_user;

-- Grant read access
EXEC sp_addrolemember 'db_datareader', 'bondata_user';

​

Step 4: Gather Connection Details

• Host: Your workspace SQL endpoint (e.g., myworkspace.sql.azuresynapse.net)
• Port: 1433
• Database: The name of your dedicated SQL pool
• User: The username created above
• Password: The password for the user

​

Step 5: Connect in BonData

​

Required Fields

​

Available Data

• Tables - All tables the user has SELECT access to
• Views - Database views accessible to the user
• Custom Queries - Run custom T-SQL queries to extract specific data