Azure SQL Database Connector

<\!-- Page header --> <\!-- Step indicator -->

1Connect

2Select Tables

3Process

4Download

<\!-- ═══ STEP 1: Connect ═══ -->

<\!-- Left: Connection form -->

Database Connection

Enter your Azure SQL server and database details.

Server Name

Database Name

Authentication Method

Username

Password (not stored)

Connection Security

Encrypt Connection

Always enabled for Azure SQL — TLS 1.2 minimum

<\!-- Right: Setup instructions -->

Azure Setup 3 steps

Create a Contained Database User

Connect to your Azure SQL database as admin and run:

-- SQL Server Authentication CREATE USER adam_reader WITH PASSWORD = 'StrongPwd\!'; ALTER ROLE db_datareader ADD MEMBER adam_reader; -- Azure AD user CREATE USER [user@domain.com] FROM EXTERNAL PROVIDER; ALTER ROLE db_datareader ADD MEMBER [user@domain.com];

Open Firewall Rules

Azure Portal → SQL Server → Networking → Firewall rules. Add the IP(s) that Adam will connect from, or enable Allow Azure services and resources to access this server.

# Azure CLI equivalent: az sql server firewall-rule create \ --resource-group myRG \ --server myserver \ --name adam-connector \ --start-ip 0.0.0.0 \ --end-ip 0.0.0.0

Verify TLS & Port 1433

Azure SQL requires TLS 1.2+ on port 1433. Encryption is enforced by default on Azure — no configuration needed. Ensure your network does not block outbound port 1433.

Credentials are used only for this session. We recommend using a read-only db_datareader role and rotating the password after the export.

<\!-- ═══ STEP 2: Select Tables ═══ -->

Select Tables

Choose which tables to pull and anonymise.

0 tables selected

Loading tables…

<\!-- ═══ STEP 3: Process ═══ -->

Processing

Pulling tables from Azure SQL and scanning for PII.

Preparing… 0%

<\!-- ═══ STEP 4: Download ═══ -->

Anonymised Results

Select a table to preview, then download.

Download All Tables

Download the complete anonymised dataset (all selected tables combined).

📄

CSV Bundle

All tables as separate CSV files in a zip archive

{ }

JSON Export

All tables with provenance metadata as JSON

🗜

Parquet Export

Columnar format with full SQL type preservation

📊

PII Audit Report

Full list of detected fields and anonymisation actions

Provenance Record

Full lineage metadata for this run.