- Sources overview
- Available source connectors
- Adobe applications
- Advertising
- Analytics
- Cloud storage
- Amazon Kinesis connector
- Amazon S3 connector
- Apache HDFS connector
- Azure Data Lake Storage Gen2 connector
- Azure Blob connector
- Azure Event Hubs connector
- Azure File Storage connector
- Data Landing Zone
- FTP connector
- Google Cloud Storage connector
- Google PubSub
- Oracle Object Storage
- SFTP connector
- Amazon S3 and Azure Blob connector
- Consent & Preferences
- CRM
- Customer success
- Databases
- Amazon Redshift connector
- Apache Hive on Azure HDInsights connector
- Apache Spark on Azure HDInsights connector
- Azure Databricks connector
- Azure Data Explorer connector
- Azure Synapse Analytics connector
- Azure Table Storage connector
- Google BigQuery connector
- GreenPlum connector
- HP Vertica connector
- IBM DB2 connector
- MariaDB connector
- Microsoft SQL Server connector
- MySQL connector
- Oracle connector
- PostgreSQL connector
- Snowflake Streaming connector
- Snowflake connector
- Teradata Vantage connector
- Data & identity partner
- eCommerce
- Local system
- Marketing automation
- Payments
- Protocols
- Streaming
- API tutorials
- Create a base connection
- Explore data
- Collect data
- On-demand ingestion
- Filter data at the source level
- Monitor dataflows
- Update accounts
- Update dataflows
- Retry failed dataflow runs
- Delete accounts
- Delete dataflows
- Ingest encrypted data
- Save a dataflow as a draft
- Apply access labels to a dataflow
- UI tutorials
- Create a source connection
- Adobe applications
- Advertising
- Analytics
- Cloud storage
- Consent & Preferences
- CRM
- Customer Success
- Databases
- Amazon Redshift
- Apache Hive on Azure HDInsights
- Apache Spark on Azure HDInsights
- Azure Databricks
- Azure Data Explorer
- Azure Synapse Analytics
- Azure Table Storage
- Google Big Query
- GreenPlum
- HP Vertica
- IBM DB2
- MariaDB
- Microsoft SQL Server
- MySQL
- Oracle
- PostgreSQL
- Snowflake
- Snowflake Streaming
- Teradata Vantage
- Data & identity partner
- eCommerce
- Local system
- Marketing automation
- Payments
- Protocols
- Streaming
- Configure a dataflow
- Advertising connection dataflow
- Analytics connection dataflow
- Batch cloud storage connection dataflow
- Streaming cloud storage connection dataflow
- Consent & Preferences connection dataflow
- CRM connection dataflow
- Customer success connection dataflow
- Database connection dataflow
- Ecommerce connection dataflow
- Marketing automation connection dataflow
- Payment connection dataflow
- Protocol connection dataflow
- Create a sources dataflow using templates in the UI
- Ingest encrypted data
- On-demand ingestion
- Monitor batch dataflows
- Monitor streaming dataflows
- Update accounts
- Update dataflows
- Delete accounts
- Delete dataflows
- Subscribe to sources alerts
- Save a dataflow as a draft
- Apply access labels to a dataflow
- Create a source connection
- Self-Serve Sources (Batch SDK)
- Overview
- Configure your connection specification
- Self-Serve Sources (Batch SDK) API guide
- Documentation guide
- Streaming SDK
- Get started with Self-Serve Sources (Streaming SDK)
- Create a connection specification for a streaming source
- Update a connection specification for a streaming source
- Update the streaming flow specification
- Test and submit your connection specification for verification
- Document your source (Streaming SDK)
- Documentation self-service API streaming template
- Documentation self-service UI streaming template
- Error messages
- Flow run notifications
- IP address allow list
- Frequently asked questions
- API reference
- Experience Platform release notes
Azure Synapse Analytics
The Azure Synapse Analytics source is available in the sources catalog to users who have purchased Real-Time Customer Data Platform Ultimate.
Azure Synapse Analytics is a cloud-based analytics service that unifies big data and data warehousing. You can ingest, explore, prepare, and analyze data using SQL, Spark, or real-time tools—all without moving your data.
You can use the Azure Synapse Analytics source to connect your account and bring your data to Adobe Experience Platform.
Prerequisites
Read the following sections to complete the prerequisite setup before you connect your Azure Synapse Analytics account to Experience Platform.
IP address allowlist
You must add region-specific IP addresses to your allowlist prior to connecting your sources to Experience Platform. For more information, read the guide on allowlisting IP addresses to connect to Experience Platform for more information.
Configure permissions
To connect your source account to Experience Platform, your account must have both of the following permissions enabled:
- View Sources
- Manage Sources
If you don’t have these permissions, contact your product administrator to request access. For more information, read the access control UI guide.
Authenticate to Experience Platform
You can use either account key authentication or service-principal key authentication to connect your Azure Synapse Analytics to Experience Platform.
Provide values for the following credentials to connect your Azure Synapse Analytics database to Experience Platform using account key authentication.
| Credential | Description |
|---|---|
| Connection string | This is the connection string used for authenticating with Azure Synapse Analytics. The standard format is: Server=tcp:{SERVER_NAME}.database.windows.net,1433;Database={DATABASE};User ID={USERNAME}@{SERVER_NAME};Password={PASSWORD};Trusted_Connection=False;Encrypt=True;Connection Timeout=30. You must replace the placeholders with your actual connection details. |
| Connection spec ID | The connection spec provides the connector properties of a data source. This includes details such as authentication specifications and requirements for creating both base and source connections. For Azure Synapse Analytics, the connection spec ID is: a49bcc7d-8038-43af-b1e4-5a7a089a7d79. Note: This credential is only necessary when connecting via APIs. |
To retrieve your credentials for service principal key authentication, navigate to the Microsfot Entra admin center and retrieve values for the following:
- App ID
- Display name
- Secret
- Tenant ID
Next, navigate to your Azure Synapse Analytics instance and then select the option to create a user from an external provider. From here, provide the appropriate permissions for the service principal on the schema. NOTE:: You must include “SELECT” as it is required for schema preview, similar to “COPY”. For instance, an example command can be:
GRANT SELECT ON SCHEMA::dbo TO {APP_ID};
Provide values for the following credentials to connect your Azure Synapse Analytics database to Experience Platform using service-principal key authentication.
| Credential | Description |
|---|---|
| Server | The fully qualified domain name of your Azure Synapse Analytics SQL endpoint. |
| Database | The name of the specific database within your Azure Synapse Analytics workspace. |
| Tenant | The Azure Active Directory tenant ID associated with your Azure subscription. |
| Service principal ID | The client ID of an Azure Active Directory application. |
| Service principal key | The client secret or password associated with the service principal. |
| Connection spec ID | The connection spec provides the connector properties of a data source. This includes details such as authentication specifications and requirements for creating both base and source connections. For Azure Synapse Analytics, the connection spec ID is: a49bcc7d-8038-43af-b1e4-5a7a089a7d79. Note: This credential is only necessary when connecting via APIs. |
For more information, read the Azure documentation on managing identities for Azure Synapse Analytics.
Connect Azure Synapse Analytics to Experience Platform using APIs
- Connect Azure Synapse Analytics to Experience Platform using the Flow Service API
- Explore data tables using the Flow Service API
- Create a dataflow for a database source using the Flow Service API
Connect Azure Synapse Analytics to Experience Platform using the UI
