Connection guide

Connect Azure SQL

Azure SQL requires firewall rules that allow Unity Layer to reach your server, plus a login with db_datareader access.

Configure firewall rules

In the Azure Portal, allow Unity Layer's IP range to connect to the server.

-- In Azure Portal: SQL Server > Security > Firewalls and virtual networks
-- Add Unity Layer's IP address or allow Azure services

Create a dedicated user

Create a login and database user for Unity Layer.

CREATE LOGIN unitylayer_user WITH PASSWORD = 'your_secure_password';
CREATE USER unitylayer_user FOR LOGIN unitylayer_user;

Grant database access

Add the user to db_datareader for read-only access.

USE your_database;
ALTER ROLE db_datareader ADD MEMBER unitylayer_user;

Verify user

Confirm login and role membership.

SELECT name, type_desc FROM sys.database_principals WHERE name = 'unitylayer_user';

When setup is complete, open Connect database in the data catalog to enter credentials and test the connection.