Azure Synapse
Available when using an authoring Data Collector version 3.20.0 or later.
- Data Collector 5.5.x and later - Requires the Azure stage library,
streamsets-datacollector-azure-lib
. - Data Collector
3.20.0 to 5.4.x - Requires
version 1.2.0 or later of the Azure Synapse Enterprise stage library,
streamsets-datacollector-azure-synapse-lib
.
For a description of the Azure Synapse connection properties, see Azure Synapse Connection Properties.
Engine | Stages |
---|---|
Data Collector 3.20.0 or later |
|
Azure Synapse Authentication
- SQL Login
- You specify a user name and password created in the database.
- Azure Active Directory
- You specify an Azure Active Directory user identity and password. The user identity and
password are the credentials used to sign in to the Azure
portal. Enter the full user identity, for example:
user@mycompany.com
.
Azure Synapse Connection Properties
Azure Synapse SQL Property | Description |
---|---|
Azure Synapse Name | Name of the Azure Synapse server. The server name is the first portion of the FQDN. For example, in the
|
Azure Synapse Instance Type | Azure Synapse Instance type to write to:
|
Azure Synapse Authentication | Authentication method used to connect to Azure
Synapse:
|
User | User name for the connection to the database. Available when using the SQL Login authentication method. |
Password | Password for the
account. Tip: To secure sensitive
information, you can use credential stores or runtime resources. Available when using the SQL Login authentication method. |
Azure Active Directory ID | Azure Active Directory user identity for the connection to the
database. The user identity and
password are the credentials used to sign in to the Azure
portal. Enter the full user identity, for example:
Available when using the Azure Active Directory authentication method. |
Azure Active Directory Password | Password for the user
identity. Tip: To secure sensitive
information, you can use credential stores or runtime resources. Available when using the Azure Active Directory authentication method. |
Azure Government Account | Enables the use of an Azure Government account. For more information about government accounts, see the Azure documentation. |