Azure SQL Database

Load event data into Azure SQL Database for fully managed, intelligent relational database storage on Azure.

Configuration

FieldTypeRequiredDescription
serverstringYesThe Azure SQL server hostname, e.g. xxx.database.windows.net.
databasestringYesThe target database name.
table_namestringYesThe target table name to insert rows into.
usernamestringYesThe database username for authentication.
passwordsecretYesThe database password for authentication.

Quick Setup

  1. Navigate to Integrations in the sidebar.
  2. Open the Integration Library tab.
  3. Find Azure SQL Database or filter by Cloud Storage.
  4. Click Install, select a variant if available, and fill in the required fields.
  5. Click Install Integration to create the integration with a ready-to-use default configuration.

API Setup

curl -X POST http://localhost:8084/v1/admin/integration-catalog/azure_sql/install \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "Azure SQL Database",
    "variant": "default",
    "config": {
      "server": "myserver.database.windows.net",
      "database": "analytics",
      "table_name": "events",
      "username": "datafly"
    },
    "delivery_mode": "server_side"
  }'

Delivery

Events are delivered server-side from your Datafly Signal infrastructure directly to Azure SQL Database. No client-side scripts are loaded for this integration.

Visit Azure SQL Database documentation for full API documentation and credential setup instructions.