Azure Analytics
Destination (Warehouse Activation) - Vendo writes modeled data and activation outputs into Azure Synapse through the Azure Analytics connector.
Azure Analytics is the Vendo catalog entry for Azure Synapse destination connections.
What Vendo Exports
Azure Analytics accepts the same warehouse activation payload types exposed by the app catalog.
| Export Type | Description |
|---|---|
| Events | Modeled business events and custom event streams |
| Users | User and customer profiles enriched by Vendo |
| Ad Data | Advertising performance, campaign, and creative data |
| Conversions | Conversion records for measurement and activation workflows |
How It Works
Vendo connects to your Azure Synapse environment and writes selected outputs into the tables you configure for activation. The destination uses the warehouse pattern shared by Vendo’s direct-query connectors: your Azure environment remains the system of record for storage and compute, while Vendo controls which modeled outputs are exported.
Platform Details
| Setting | Value |
|---|---|
| App type | azure_synapse |
| Catalog name | Azure Analytics |
| Provider | Native |
| Delivery mode | Direct query warehouse connection |
| Accepted payloads | event, user, ad_data, conversions |
Setup
- Navigate to App Connections > Add App Connection
- Select Azure Analytics from the data warehouse category
- Provide the Azure Synapse workspace, SQL endpoint, database, and schema/table scope
- Use a database principal with write access to the destination tables or schemas
- Save the destination and choose which Vendo outputs should export to Azure Synapse
Permissions Required
Grant write permissions only to the destination schemas or tables Vendo should manage:
| Permission | Purpose |
|---|---|
| Connect to SQL endpoint | Reach the Synapse SQL endpoint |
| Database and schema access | Address the target export location |
INSERT or equivalent write permission | Append activation output rows |
| Table creation or migration permission, if enabled | Let Vendo create managed export tables |
Source Support
Azure Analytics is also available as a source for direct-query reads from Azure Synapse tables and views.
See Azure Analytics source for the read-side behavior.
Troubleshooting
| Symptom | What to check |
|---|---|
| Export fails | Confirm the database principal has write access to the target schema/table |
| Rows do not appear | Check the selected payload type and destination table mapping |
| Schema mismatch | Verify the target table columns match the selected export shape |
| Network access fails | Confirm your network rules allow Vendo to reach the SQL endpoint |