Linked Service - Get Linked Services By Workspace
Lists linked services.
GET {endpoint}/linkedservices?api-version=2020-12-01
Name | In | Required | Type | Description |
---|---|---|---|---|
endpoint
|
path | True |
string (uri) |
The workspace development endpoint, for example |
api-version
|
query | True |
string |
The Synapse client API Version. |
Name | Type | Description |
---|---|---|
200 OK |
OK. |
|
Other Status Codes |
An error response received from the Azure Synapse service. |
Sample request
GET exampleWorkspace.dev.azuresynapse.net/linkedservices?api-version=2020-12-01
Sample response
Date: Sat, 16 Jun 2018 00:37:36 GMT
X-Content-Type-Options: nosniff
x-ms-ratelimit-remaining-subscription-reads: 14994
x-ms-request-id: 558d0fd8-dc1f-44b6-9ca9-59fcca8af9a5
x-ms-correlation-request-id: 558d0fd8-dc1f-44b6-9ca9-59fcca8af9a5
{
"value": [
{
"id": "/subscriptions/12345678-1234-1234-1234-12345678abc/resourceGroups/exampleResourceGroup/providers/Microsoft.Synapse/workspaces/exampleWorkspaceName/linkedservices/exampleLinkedService",
"name": "exampleLinkedService",
"type": "Microsoft.Synapse/workspaces/linkedservices",
"properties": {
"type": "AzureStorage",
"typeProperties": {
"connectionString": {
"type": "SecureString",
"value": "**********"
},
"encryptedCredential": "ew0KICAiVmVyc2lvbiI6ICIyMDE3LTExLTMwIiwNCiAgIlByb3RlY3Rpb25Nb2RlIjogIktleSIsDQogICJTZWNyZXRDb250ZW50VHlwZSI6ICJQbGFpbnRleHQiLA0KICAiQ3JlZGVudGlhbElkIjogIkRGLURPR0ZPT0QtWUFOWkhBTkctV1VfMGI2M2EyMmYtMGEzNC00NDg2LWIzMDktNzM0NTlkODUyY2Q1Ig0KfQ=="
},
"description": "Example description"
},
"etag": "0a0064d4-0000-0000-0000-5b245bd00000"
}
]
}
Name | Description |
---|---|
Amazon |
Amazon Marketplace Web Service linked service. |
Amazon |
AmazonRdsForOracle database. |
Amazon |
The type used for authentication. Type: string. |
Amazon |
Amazon RDS for SQL Server linked service. |
Amazon |
Linked service for Amazon Redshift. |
AmazonS3Linked |
Linked service for Amazon S3. |
App |
Linked service for AppFigures. |
Asana |
Linked service for Asana. |
Azure |
Azure Batch linked service. |
Azure |
Azure Data Lake Storage Gen2 linked service. |
Azure |
The azure blob storage linked service. |
Azure |
Azure Databricks Delta Lake linked service. |
Azure |
Azure Databricks linked service. |
Azure |
Azure Data Explorer (Kusto) linked service. |
Azure |
Azure Data Lake Analytics linked service. |
Azure |
Azure Data Lake Store linked service. |
Azure |
Azure File Storage linked service. |
Azure |
Azure Function linked service. |
Azure |
Azure Key Vault linked service. |
Azure |
Azure Key Vault secret reference. |
Azure |
Azure Database for MariaDB linked service. |
Azure |
Azure ML Studio Web Service linked service. |
Azure |
Azure ML Service linked service. |
Azure |
Azure MySQL database linked service. |
Azure |
Azure PostgreSQL linked service. |
Azure |
Linked service for Windows Azure Search Service. |
Azure |
The type used for authentication. Type: string. |
Azure |
Microsoft Azure SQL Database linked service. |
Azure |
The type used for authentication. Type: string. |
Azure |
Azure SQL Data Warehouse linked service. |
Azure |
The type used for authentication. Type: string. |
Azure |
Azure SQL Managed Instance linked service. |
Azure |
The type used for authentication. Type: string. |
Azure |
The storage account linked service. |
Azure |
Azure Synapse Analytics (Artifacts) linked service. |
Azure |
The azure table storage linked service. |
Cassandra |
Linked service for Cassandra data source. |
Cloud |
The object that defines the structure of an Azure Synapse error response. |
Common |
Common Data Service for Apps linked service. |
Concur |
Concur Service linked service. |
Cosmos |
Microsoft Azure Cosmos Database (CosmosDB) linked service. |
Cosmos |
Linked service for CosmosDB (MongoDB API) data source. |
Couchbase |
Couchbase server linked service. |
Credential |
Credential reference type. |
Credential |
Credential reference type. |
Custom |
Custom linked service. |
Dataworld |
Linked service for Dataworld. |
Db2Authentication |
AuthenticationType to be used for connection. It is mutually exclusive with connectionString property. |
Db2Linked |
Linked service for DB2 data source. |
Drill |
Drill server linked service. |
Dynamics |
Dynamics AX linked service. |
Dynamics |
Dynamics CRM linked service. |
Dynamics |
Dynamics linked service. |
Eloqua |
Eloqua server linked service. |
File |
File system linked service. |
Ftp |
The authentication type to be used to connect to the FTP server. |
Ftp |
A FTP server Linked Service. |
Google |
The OAuth 2.0 authentication mechanism used for authentication. ServiceAuthentication can only be used on self-hosted IR. |
Google |
Google AdWords service linked service. |
Google |
The OAuth 2.0 authentication mechanism used for authentication. ServiceAuthentication can only be used on self-hosted IR. |
Google |
Google BigQuery service linked service. |
Google |
The OAuth 2.0 authentication mechanism used for authentication. |
Google |
Google BigQuery service linked service. |
Google |
Linked service for Google Cloud Storage. |
Google |
Linked service for GoogleSheets. |
Greenplum |
The authentication type to use. Type: string. Only used for V2. |
Greenplum |
Greenplum Database linked service. |
HBase |
The authentication mechanism to use to connect to the HBase server. |
HBase |
HBase server linked service. |
Hdfs |
Hadoop Distributed File System (HDFS) linked service. |
HDInsight |
HDInsight linked service. |
HDInsight |
HDInsight ondemand linked service. |
Hive |
The authentication method used to access the Hive server. |
Hive |
Hive Server linked service. |
Hive |
The type of Hive server. |
Hive |
The transport protocol to use in the Thrift layer. |
Http |
The authentication type to be used to connect to the HTTP server. |
Http |
Linked service for an HTTP source. |
Hubspot |
Hubspot Service linked service. |
Impala |
The authentication type to use. |
Impala |
Impala server linked service. |
Informix |
Informix linked service. |
Integration |
Integration runtime reference type. |
Integration |
Type of integration runtime. |
Jira |
Jira Service linked service. |
Lake |
Microsoft Fabric Lakehouse linked service. |
Linked |
A list of linked service resources. |
Linked |
Linked service reference type. |
Linked |
Linked service resource type. |
Magento |
Magento server linked service. |
Maria |
MariaDB server linked service. |
Marketo |
Marketo server linked service. |
Microsoft |
Microsoft Access linked service. |
Mongo |
Linked service for MongoDB Atlas data source. |
Mongo |
The authentication type to be used to connect to the MongoDB database. |
Mongo |
Linked service for MongoDb data source. |
Mongo |
Linked service for MongoDB data source. |
My |
Linked service for MySQL data source. |
Netezza |
Netezza linked service. |
OData |
Specify the credential type (key or cert) is used for service principal. |
OData |
Type of authentication used to connect to the OData service. |
OData |
Open Data Protocol (OData) linked service. |
Odbc |
Open Database Connectivity (ODBC) linked service. |
Office365Linked |
Office365 linked service. |
Oracle |
Authentication type for connecting to the Oracle database. Only used for Version 2.0. |
Oracle |
Oracle database. This linked service has supported version property. The Version 1.0 is scheduled for deprecation while your pipeline will continue to run after EOL but without any bug fix or new features. |
Oracle |
Oracle Service Cloud linked service. |
Parameter |
Definition of a single parameter for an entity. |
Parameter |
Parameter type. |
Paypal |
Paypal Service linked service. |
Phoenix |
The authentication mechanism used to connect to the Phoenix server. |
Phoenix |
Phoenix server linked service. |
Postgre |
Linked service for PostgreSQL data source. |
Postgre |
Linked service for PostgreSQLV2 data source. |
Power |
Power BI Workspace linked service. |
Presto |
The authentication mechanism used to connect to the Presto server. |
Presto |
Presto server linked service. This linked service has supported version property. The Version 1.0 is scheduled for deprecation while your pipeline will continue to run after EOL but without any bug fix or new features. |
Quickbase |
Linked service for Quickbase. |
Quick |
QuickBooks server linked service. |
Responsys |
Responsys linked service. |
Rest |
Type of authentication used to connect to the REST service. |
Rest |
Rest Service linked service. |
Salesforce |
Linked service for Salesforce. |
Salesforce |
Salesforce Marketing Cloud linked service. |
Salesforce |
Linked service for Salesforce Service Cloud. |
Salesforce |
Linked service for Salesforce Service Cloud V2. |
SalesforceV2Linked |
Linked service for Salesforce V2. |
Sap |
SAP Business Warehouse Linked Service. |
Sap |
Linked service for SAP Cloud for Customer. |
Sap |
Linked service for SAP ERP Central Component(SAP ECC). |
Sap |
The authentication type to be used to connect to the SAP HANA server. |
Sap |
SAP HANA Linked Service. |
Sap |
SAP ODP Linked Service. |
Sap |
SAP Business Warehouse Open Hub Destination Linked Service. |
Sap |
SAP Table Linked Service. |
Script |
Custom script action to run on HDI ondemand cluster once it's up. |
Secure |
Azure Synapse secure string definition. The string value will be masked with asterisks '*' during Get or List API calls. |
Service |
The authentication type to use. |
Service |
ServiceNow server linked service. |
Sftp |
The authentication type to be used to connect to the FTP server. |
Sftp |
A linked service for an SSH File Transfer Protocol (SFTP) server. |
Share |
SharePoint Online List linked service. |
Shopify |
Shopify Service linked service. |
Smartsheet |
Linked service for Smartsheet. |
Snowflake |
The type used for authentication. Type: string. |
Snowflake |
Snowflake linked service. |
SnowflakeV2Linked |
Snowflake linked service. |
Spark |
The authentication method used to access the Spark server. |
Spark |
Spark Server linked service. |
Spark |
The type of Spark server. |
Spark |
The transport protocol to use in the Thrift layer. |
Sql |
Sql always encrypted AKV authentication type. Type: string. |
Sql |
Sql always encrypted properties. |
Sql |
The type used for authentication. Type: string. |
Sql |
SQL Server linked service. |
Square |
Square Service linked service. |
Sybase |
AuthenticationType to be used for connection. |
Sybase |
Linked service for Sybase data source. |
Team |
The authentication type to use. |
Team |
Linked service for TeamDesk. |
Teradata |
AuthenticationType to be used for connection. |
Teradata |
Linked service for Teradata data source. |
Twilio |
Linked service for Twilio. |
Type |
Linked service reference type. |
Vertica |
Vertica linked service. |
Warehouse |
Microsoft Fabric Warehouse linked service. |
Web |
A WebLinkedService that uses anonymous authentication to communicate with an HTTP endpoint. |
Web |
A WebLinkedService that uses basic authentication to communicate with an HTTP endpoint. |
Web |
A WebLinkedService that uses client certificate based authentication to communicate with an HTTP endpoint. This scheme follows mutual authentication; the server must also provide valid credentials to the client. |
Web |
Web linked service. |
Xero |
Xero Service linked service. |
Zendesk |
The authentication type to use. |
Zendesk |
Linked service for Zendesk. |
Zoho |
Zoho server linked service. |
Amazon Marketplace Web Service linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
AmazonMWS |
Type of linked service. |
typeProperties.accessKeyId |
object |
The access key id used to access data. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.endpoint |
object |
The endpoint of the Amazon MWS server, (i.e. mws.amazonservices.com) |
typeProperties.marketplaceID |
object |
The Amazon Marketplace ID you want to retrieve data from. To retrieve data from multiple Marketplace IDs, separate them with a comma (,). (i.e. A2EUQ1WTGCTBG2) |
typeProperties.mwsAuthToken | SecretBase: |
The Amazon MWS authentication token. |
typeProperties.secretKey | SecretBase: |
The secret key used to access data. |
typeProperties.sellerID |
object |
The Amazon seller ID. |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. |
typeProperties.useHostVerification |
object |
Specifies whether to require the host name in the server's certificate to match the host name of the server when connecting over SSL. The default value is true. |
typeProperties.usePeerVerification |
object |
Specifies whether to verify the identity of the server when connecting over SSL. The default value is true. |
version |
string |
Version of the linked service. |
AmazonRdsForOracle database.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Amazon |
Type of linked service. |
typeProperties.connectionString |
object |
The connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
The Azure key vault secret reference of password in connection string. |
version |
string |
Version of the linked service. |
The type used for authentication. Type: string.
Value | Description |
---|---|
SQL | |
Windows |
Amazon RDS for SQL Server linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Amazon |
Type of linked service. |
typeProperties.alwaysEncryptedSettings |
Sql always encrypted properties. |
|
typeProperties.applicationIntent |
object |
The application workload type when connecting to a server, used by recommended version. Possible values are ReadOnly and ReadWrite. Type: string (or Expression with resultType string). |
typeProperties.authenticationType |
The type used for authentication. Type: string. |
|
typeProperties.commandTimeout |
object |
The default wait time (in seconds) before terminating the attempt to execute a command and generating an error, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.connectRetryCount |
object |
The number of re-connections attempted after identifying that there was an idle connection failure, used by recommended version. This must be an integer between 0 and 255. Type: integer (or Expression with resultType integer). |
typeProperties.connectRetryInterval |
object |
The amount of time (in seconds) between each re-connection attempt after identifying that there was an idle connection failure, used by recommended version. This must be an integer between 1 and 60. Type: integer (or Expression with resultType integer). |
typeProperties.connectTimeout |
object |
The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.connectionString |
object |
The connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.database |
object |
The name of the database, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.encrypt |
object |
Indicate whether TLS encryption is required for all data sent between the client and server, used by recommended version. Possible values are true/yes/mandatory, false/no/optional and strict. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.failoverPartner |
object |
The name or address of the partner server to connect to if the primary server is down, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.hostNameInCertificate |
object |
The host name to use when validating the server certificate for the connection. When not specified, the server name from the Data Source is used for certificate validation, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.integratedSecurity |
object |
Indicate whether User ID and Password are specified in the connection (when false) or whether the current Windows account credentials are used for authentication (when true), used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.loadBalanceTimeout |
object |
The minimum time, in seconds, for the connection to live in the connection pool before being destroyed, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.maxPoolSize |
object |
The maximum number of connections allowed in the connection pool for this specific connection string, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.minPoolSize |
object |
The minimum number of connections allowed in the connection pool for this specific connection string, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.multiSubnetFailover |
object |
If your application is connecting to an AlwaysOn availability group (AG) on different subnets, setting MultiSubnetFailover=true provides faster detection of and connection to the (currently) active server, used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.multipleActiveResultSets |
object |
When true, an application can maintain multiple active result sets (MARS). When false, an application must process or cancel all result sets from one batch before it can execute any other batch on that connection. Type: Boolean (or Expression with resultType boolean). |
typeProperties.packetSize |
object |
The size in bytes of the network packets used to communicate with an instance of server, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.password | SecretBase: |
The on-premises Windows authentication password. |
typeProperties.pooling |
object |
Indicate whether the connection will be pooled or explicitly opened every time that the connection is requested, used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.server |
object |
The name or network address of the instance of SQL Server to which to connect, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.trustServerCertificate |
object |
Indicate whether the channel will be encrypted while bypassing walking the certificate chain to validate trust, used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.userName |
object |
The on-premises Windows authentication user name. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Linked service for Amazon Redshift.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Amazon |
Type of linked service. |
typeProperties.database |
object |
The database name of the Amazon Redshift source. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
The password of the Amazon Redshift source. |
typeProperties.port |
object |
The TCP port number that the Amazon Redshift server uses to listen for client connections. The default value is 5439. Type: integer (or Expression with resultType integer). |
typeProperties.server |
object |
The name of the Amazon Redshift server. Type: string (or Expression with resultType string). |
typeProperties.username |
object |
The username of the Amazon Redshift source. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Linked service for Amazon S3.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
AmazonS3 |
Type of linked service. |
typeProperties.accessKeyId |
object |
The access key identifier of the Amazon S3 Identity and Access Management (IAM) user. Type: string (or Expression with resultType string). |
typeProperties.authenticationType |
object |
The authentication type of S3. Allowed value: AccessKey (default) or TemporarySecurityCredentials. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.secretAccessKey | SecretBase: |
The secret access key of the Amazon S3 Identity and Access Management (IAM) user. |
typeProperties.serviceUrl |
object |
This value specifies the endpoint to access with the S3 Connector. This is an optional property; change it only if you want to try a different service endpoint or want to switch between https and http. Type: string (or Expression with resultType string). |
typeProperties.sessionToken | SecretBase: |
The session token for the S3 temporary security credential. |
version |
string |
Version of the linked service. |
Linked service for AppFigures.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
App |
Type of linked service. |
typeProperties.clientKey | SecretBase: |
The client key for the AppFigures source. |
typeProperties.password | SecretBase: |
The password of the AppFigures source. |
typeProperties.userName |
object |
The username of the Appfigures source. |
version |
string |
Version of the linked service. |
Linked service for Asana.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Asana |
Type of linked service. |
typeProperties.apiToken | SecretBase: |
The api token for the Asana source. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Azure Batch linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.accessKey | SecretBase: |
The Azure Batch account access key. |
typeProperties.accountName |
object |
The Azure Batch account name. Type: string (or Expression with resultType string). |
typeProperties.batchUri |
object |
The Azure Batch URI. Type: string (or Expression with resultType string). |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.linkedServiceName |
The Azure Storage linked service reference. |
|
typeProperties.poolName |
object |
The Azure Batch pool name. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Azure Data Lake Storage Gen2 linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.accountKey |
object |
Account key for the Azure Data Lake Storage Gen2 service. Type: string (or Expression with resultType string). |
typeProperties.azureCloudType |
object |
Indicates the azure cloud type of the service principle auth. Allowed values are AzurePublic, AzureChina, AzureUsGovernment, AzureGermany. Default value is the data factory regions’ cloud type. Type: string (or Expression with resultType string). |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.sasToken | SecretBase: |
The Azure key vault secret reference of sasToken in sas uri. |
typeProperties.sasUri |
object |
SAS URI of the Azure Data Lake Storage Gen2 service. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.servicePrincipalCredential | SecretBase: |
The credential of the service principal object in Azure Active Directory. If servicePrincipalCredentialType is 'ServicePrincipalKey', servicePrincipalCredential can be SecureString or AzureKeyVaultSecretReference. If servicePrincipalCredentialType is 'ServicePrincipalCert', servicePrincipalCredential can only be AzureKeyVaultSecretReference. |
typeProperties.servicePrincipalCredentialType |
object |
The service principal credential type to use in Server-To-Server authentication. 'ServicePrincipalKey' for key/secret, 'ServicePrincipalCert' for certificate. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
The ID of the application used to authenticate against the Azure Data Lake Storage Gen2 account. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
The Key of the application used to authenticate against the Azure Data Lake Storage Gen2 account. |
typeProperties.tenant |
object |
The name or ID of the tenant to which the service principal belongs. Type: string (or Expression with resultType string). |
typeProperties.url |
object |
Endpoint for the Azure Data Lake Storage Gen2 service. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
The azure blob storage linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.accountKey |
The Azure key vault secret reference of accountKey in connection string. |
|
typeProperties.accountKind |
string |
Specify the kind of your storage account. Allowed values are: Storage (general purpose v1), StorageV2 (general purpose v2), BlobStorage, or BlockBlobStorage. Type: string (or Expression with resultType string). |
typeProperties.authenticationType |
The type used for authentication. Type: string. |
|
typeProperties.azureCloudType |
object |
Indicates the azure cloud type of the service principle auth. Allowed values are AzurePublic, AzureChina, AzureUsGovernment, AzureGermany. Default value is the data factory regions’ cloud type. Type: string (or Expression with resultType string). |
typeProperties.connectionString |
object |
The connection string. It is mutually exclusive with sasUri, serviceEndpoint property. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.containerUri |
object |
Container uri of the Azure Blob Storage resource only support for anonymous access. Type: string (or Expression with resultType string). |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.encryptedCredential |
string |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.sasToken |
The Azure key vault secret reference of sasToken in sas uri. |
|
typeProperties.sasUri |
object |
SAS URI of the Azure Blob Storage resource. It is mutually exclusive with connectionString, serviceEndpoint property. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.serviceEndpoint |
string |
Blob service endpoint of the Azure Blob Storage resource. It is mutually exclusive with connectionString, sasUri property. |
typeProperties.servicePrincipalId |
object |
The ID of the service principal used to authenticate against Azure SQL Data Warehouse. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
The key of the service principal used to authenticate against Azure SQL Data Warehouse. |
typeProperties.tenant |
object |
The name or ID of the tenant to which the service principal belongs. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Azure Databricks Delta Lake linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.accessToken | SecretBase: |
Access token for databricks REST API. Refer to https://docs.azuredatabricks.net/api/latest/authentication.html. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.clusterId |
object |
The id of an existing interactive cluster that will be used for all runs of this job. Type: string (or Expression with resultType string). |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.domain |
object |
.azuredatabricks.net, domain name of your Databricks deployment. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Azure Databricks linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.accessToken | SecretBase: |
Access token for databricks REST API. Refer to https://docs.azuredatabricks.net/api/latest/authentication.html. Type: string (or Expression with resultType string). |
typeProperties.authentication |
object |
Required to specify MSI, if using Workspace resource id for databricks REST API. Type: string (or Expression with resultType string). |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.domain |
object |
.azuredatabricks.net, domain name of your Databricks deployment. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.existingClusterId |
object |
The id of an existing interactive cluster that will be used for all runs of this activity. Type: string (or Expression with resultType string). |
typeProperties.instancePoolId |
object |
The id of an existing instance pool that will be used for all runs of this activity. Type: string (or Expression with resultType string). |
typeProperties.newClusterCustomTags |
object |
Additional tags for cluster resources. This property is ignored in instance pool configurations. |
typeProperties.newClusterDriverNodeType |
object |
The driver node type for the new job cluster. This property is ignored in instance pool configurations. Type: string (or Expression with resultType string). |
typeProperties.newClusterEnableElasticDisk |
object |
Enable the elastic disk on the new cluster. This property is now ignored, and takes the default elastic disk behavior in Databricks (elastic disks are always enabled). Type: boolean (or Expression with resultType boolean). |
typeProperties.newClusterInitScripts |
object |
User-defined initialization scripts for the new cluster. Type: array of strings (or Expression with resultType array of strings). |
typeProperties.newClusterLogDestination |
object |
Specify a location to deliver Spark driver, worker, and event logs. Type: string (or Expression with resultType string). |
typeProperties.newClusterNodeType |
object |
The node type of the new job cluster. This property is required if newClusterVersion is specified and instancePoolId is not specified. If instancePoolId is specified, this property is ignored. Type: string (or Expression with resultType string). |
typeProperties.newClusterNumOfWorker |
object |
If not using an existing interactive cluster, this specifies the number of worker nodes to use for the new job cluster or instance pool. For new job clusters, this a string-formatted Int32, like '1' means numOfWorker is 1 or '1:10' means auto-scale from 1 (min) to 10 (max). For instance pools, this is a string-formatted Int32, and can only specify a fixed number of worker nodes, such as '2'. Required if newClusterVersion is specified. Type: string (or Expression with resultType string). |
typeProperties.newClusterSparkConf |
object |
A set of optional, user-specified Spark configuration key-value pairs. |
typeProperties.newClusterSparkEnvVars |
object |
A set of optional, user-specified Spark environment variables key-value pairs. |
typeProperties.newClusterVersion |
object |
If not using an existing interactive cluster, this specifies the Spark version of a new job cluster or instance pool nodes created for each run of this activity. Required if instancePoolId is specified. Type: string (or Expression with resultType string). |
typeProperties.policyId |
object |
The policy id for limiting the ability to configure clusters based on a user defined set of rules. Type: string (or Expression with resultType string). |
typeProperties.workspaceResourceId |
object |
Workspace resource id for databricks REST API. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Azure Data Explorer (Kusto) linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.database |
object |
Database name for connection. Type: string (or Expression with resultType string). |
typeProperties.endpoint |
object |
The endpoint of Azure Data Explorer (the engine's endpoint). URL will be in the format https://..kusto.windows.net. Type: string (or Expression with resultType string) |
typeProperties.servicePrincipalId |
object |
The ID of the service principal used to authenticate against Azure Data Explorer. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
The key of the service principal used to authenticate against Kusto. |
typeProperties.tenant |
object |
The name or ID of the tenant to which the service principal belongs. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Azure Data Lake Analytics linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.accountName |
object |
The Azure Data Lake Analytics account name. Type: string (or Expression with resultType string). |
typeProperties.dataLakeAnalyticsUri |
object |
Azure Data Lake Analytics URI Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.resourceGroupName |
object |
Data Lake Analytics account resource group name (if different from Data Factory account). Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
The ID of the application used to authenticate against the Azure Data Lake Analytics account. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
The Key of the application used to authenticate against the Azure Data Lake Analytics account. |
typeProperties.subscriptionId |
object |
Data Lake Analytics account subscription ID (if different from Data Factory account). Type: string (or Expression with resultType string). |
typeProperties.tenant |
object |
The name or ID of the tenant to which the service principal belongs. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Azure Data Lake Store linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.accountName |
object |
Data Lake Store account name. Type: string (or Expression with resultType string). |
typeProperties.azureCloudType |
object |
Indicates the azure cloud type of the service principle auth. Allowed values are AzurePublic, AzureChina, AzureUsGovernment, AzureGermany. Default value is the data factory regions’ cloud type. Type: string (or Expression with resultType string). |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.dataLakeStoreUri |
object |
Data Lake Store service URI. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.resourceGroupName |
object |
Data Lake Store account resource group name (if different from Data Factory account). Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
The ID of the application used to authenticate against the Azure Data Lake Store account. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
The Key of the application used to authenticate against the Azure Data Lake Store account. |
typeProperties.subscriptionId |
object |
Data Lake Store account subscription ID (if different from Data Factory account). Type: string (or Expression with resultType string). |
typeProperties.tenant |
object |
The name or ID of the tenant to which the service principal belongs. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Azure File Storage linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.accountKey |
The Azure key vault secret reference of accountKey in connection string. |
|
typeProperties.connectionString |
object |
The connection string. It is mutually exclusive with sasUri property. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.fileShare |
object |
The azure file share name. It is required when auth with accountKey/sasToken. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
Host name of the server. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password to logon the server. |
typeProperties.sasToken |
The Azure key vault secret reference of sasToken in sas uri. |
|
typeProperties.sasUri |
object |
SAS URI of the Azure File resource. It is mutually exclusive with connectionString property. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.serviceEndpoint |
object |
File service endpoint of the Azure File Storage resource. It is mutually exclusive with connectionString, sasUri property. |
typeProperties.snapshot |
object |
The azure file share snapshot version. Type: string (or Expression with resultType string). |
typeProperties.userId |
object |
User ID to logon the server. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Azure Function linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.authentication |
object |
Type of authentication (Required to specify MSI) used to connect to AzureFunction. Type: string (or Expression with resultType string). |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.functionAppUrl |
object |
The endpoint of the Azure Function App. URL will be in the format https://.azurewebsites.net. |
typeProperties.functionKey | SecretBase: |
Function or Host key for Azure Function App. |
typeProperties.resourceId |
object |
Allowed token audiences for azure function. |
version |
string |
Version of the linked service. |
Azure Key Vault linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.baseUrl |
object |
The base URL of the Azure Key Vault. e.g. https://myakv.vault.azure.net Type: string (or Expression with resultType string). |
typeProperties.credential |
The credential reference containing authentication information. |
|
version |
string |
Version of the linked service. |
Azure Key Vault secret reference.
Name | Type | Description |
---|---|---|
secretName |
object |
The name of the secret in Azure Key Vault. Type: string (or Expression with resultType string). |
secretVersion |
object |
The version of the secret in Azure Key Vault. The default value is the latest version of the secret. Type: string (or Expression with resultType string). |
store |
The Azure Key Vault linked service reference. |
|
type |
string:
Azure |
Type of the secret. |
Azure Database for MariaDB linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.connectionString |
object |
An ODBC connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.pwd |
The Azure key vault secret reference of password in connection string. |
|
version |
string |
Version of the linked service. |
Azure ML Studio Web Service linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
AzureML |
Type of linked service. |
typeProperties.apiKey | SecretBase: |
The API key for accessing the Azure ML model endpoint. |
typeProperties.authentication |
object |
Type of authentication (Required to specify MSI) used to connect to AzureML. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.mlEndpoint |
object |
The Batch Execution REST URL for an Azure ML Studio Web Service endpoint. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
The ID of the service principal used to authenticate against the ARM-based updateResourceEndpoint of an Azure ML Studio web service. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
The key of the service principal used to authenticate against the ARM-based updateResourceEndpoint of an Azure ML Studio web service. |
typeProperties.tenant |
object |
The name or ID of the tenant to which the service principal belongs. Type: string (or Expression with resultType string). |
typeProperties.updateResourceEndpoint |
object |
The Update Resource REST URL for an Azure ML Studio Web Service endpoint. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Azure ML Service linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.authentication |
object |
Type of authentication (Required to specify MSI) used to connect to AzureML. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.mlWorkspaceName |
object |
Azure ML Service workspace name. Type: string (or Expression with resultType string). |
typeProperties.resourceGroupName |
object |
Azure ML Service workspace resource group name. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
The ID of the service principal used to authenticate against the endpoint of a published Azure ML Service pipeline. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
The key of the service principal used to authenticate against the endpoint of a published Azure ML Service pipeline. |
typeProperties.subscriptionId |
object |
Azure ML Service workspace subscription ID. Type: string (or Expression with resultType string). |
typeProperties.tenant |
object |
The name or ID of the tenant to which the service principal belongs. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Azure MySQL database linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.connectionString |
object |
The connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password |
The Azure key vault secret reference of password in connection string. |
|
version |
string |
Version of the linked service. |
Azure PostgreSQL linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.azureCloudType |
object |
Indicates the azure cloud type of the service principle auth. Allowed values are AzurePublic, AzureChina, AzureUsGovernment, AzureGermany. Default value is the data factory regions’ cloud type. Type: string (or Expression with resultType string). |
typeProperties.commandTimeout |
object |
The time to wait (in seconds) while trying to execute a command before terminating the attempt and generating an error. Set to zero for infinity. Type: integer. |
typeProperties.connectionString |
object |
An ODBC connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.database |
object |
Database name for connection. Type: string. |
typeProperties.encoding |
object |
Gets or sets the .NET encoding that will be used to encode/decode PostgreSQL string data. Type: string |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password |
The Azure key vault secret reference of password in connection string. |
|
typeProperties.port |
object |
The port for the connection. Type: integer. |
typeProperties.readBufferSize |
object |
Determines the size of the internal buffer uses when reading. Increasing may improve performance if transferring large values from the database. Type: integer. |
typeProperties.server |
object |
Server name for connection. Type: string. |
typeProperties.servicePrincipalCredentialType |
object |
The service principal credential type to use in Server-To-Server authentication. 'ServicePrincipalKey' for key/secret, 'ServicePrincipalCert' for certificate. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalEmbeddedCert | SecretBase: |
Specify the base64 encoded certificate of your application registered in Azure Active Directory. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalEmbeddedCertPassword | SecretBase: |
Specify the password of your certificate if your certificate has a password and you are using AadServicePrincipal authentication. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
The ID of the service principal used to authenticate against Azure Database for PostgreSQL Flexible server. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
The key of the service principal used to authenticate against Azure Database for PostgreSQL Flexible server. |
typeProperties.sslMode |
object |
SSL mode for connection. Type: integer. 0: disable, 1:allow, 2: prefer, 3: require, 4: verify-ca, 5: verify-full. Type: integer. |
typeProperties.tenant |
object |
The name or ID of the tenant to which the service principal belongs. Type: string (or Expression with resultType string). |
typeProperties.timeout |
object |
The time to wait (in seconds) while trying to establish a connection before terminating the attempt and generating an error. Type: integer. |
typeProperties.timezone |
object |
Gets or sets the session timezone. Type: string. |
typeProperties.trustServerCertificate |
object |
Whether to trust the server certificate without validating it. Type: boolean. |
typeProperties.username |
object |
Username for authentication. Type: string. |
version |
string |
Version of the linked service. |
Linked service for Windows Azure Search Service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.key | SecretBase: |
Admin Key for Azure Search service |
typeProperties.url |
object |
URL for Azure Search service. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
The type used for authentication. Type: string.
Value | Description |
---|---|
SQL | |
ServicePrincipal | |
SystemAssignedManagedIdentity | |
UserAssignedManagedIdentity |
Microsoft Azure SQL Database linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.alwaysEncryptedSettings |
Sql always encrypted properties. |
|
typeProperties.applicationIntent |
object |
The application workload type when connecting to a server, used by recommended version. Possible values are ReadOnly and ReadWrite. Type: string (or Expression with resultType string). |
typeProperties.authenticationType |
The type used for authentication. Type: string. |
|
typeProperties.azureCloudType |
object |
Indicates the azure cloud type of the service principle auth. Allowed values are AzurePublic, AzureChina, AzureUsGovernment, AzureGermany. Default value is the data factory regions’ cloud type. Type: string (or Expression with resultType string). |
typeProperties.commandTimeout |
object |
The default wait time (in seconds) before terminating the attempt to execute a command and generating an error, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.connectRetryCount |
object |
The number of re-connections attempted after identifying that there was an idle connection failure, used by recommended version. This must be an integer between 0 and 255. Type: integer (or Expression with resultType integer). |
typeProperties.connectRetryInterval |
object |
The amount of time (in seconds) between each re-connection attempt after identifying that there was an idle connection failure, used by recommended version. This must be an integer between 1 and 60. Type: integer (or Expression with resultType integer). |
typeProperties.connectTimeout |
object |
The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.connectionString |
object |
The connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.database |
object |
The name of the database, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.encrypt |
object |
Indicate whether TLS encryption is required for all data sent between the client and server, used by recommended version. Possible values are true/yes/mandatory, false/no/optional and strict. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.failoverPartner |
object |
The name or address of the partner server to connect to if the primary server is down, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.hostNameInCertificate |
object |
The host name to use when validating the server certificate for the connection. When not specified, the server name from the Data Source is used for certificate validation, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.integratedSecurity |
object |
Indicate whether User ID and Password are specified in the connection (when false) or whether the current Windows account credentials are used for authentication (when true), used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.loadBalanceTimeout |
object |
The minimum time, in seconds, for the connection to live in the connection pool before being destroyed, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.maxPoolSize |
object |
The maximum number of connections allowed in the connection pool for this specific connection string, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.minPoolSize |
object |
The minimum number of connections allowed in the connection pool for this specific connection string, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.multiSubnetFailover |
object |
If your application is connecting to an AlwaysOn availability group (AG) on different subnets, setting MultiSubnetFailover=true provides faster detection of and connection to the (currently) active server, used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.multipleActiveResultSets |
object |
When true, an application can maintain multiple active result sets (MARS). When false, an application must process or cancel all result sets from one batch before it can execute any other batch on that connection. Type: Boolean (or Expression with resultType boolean). |
typeProperties.packetSize |
object |
The size in bytes of the network packets used to communicate with an instance of server, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.password |
The Azure key vault secret reference of password in connection string. |
|
typeProperties.pooling |
object |
Indicate whether the connection will be pooled or explicitly opened every time that the connection is requested, used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.server |
object |
The name or network address of the instance of SQL Server to which to connect, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalCredential | SecretBase: |
The credential of the service principal object in Azure Active Directory. If servicePrincipalCredentialType is 'ServicePrincipalKey', servicePrincipalCredential can be SecureString or AzureKeyVaultSecretReference. If servicePrincipalCredentialType is 'ServicePrincipalCert', servicePrincipalCredential can only be AzureKeyVaultSecretReference. |
typeProperties.servicePrincipalCredentialType |
object |
The service principal credential type to use in Server-To-Server authentication. 'ServicePrincipalKey' for key/secret, 'ServicePrincipalCert' for certificate. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
The ID of the service principal used to authenticate against Azure SQL Database. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
The key of the service principal used to authenticate against Azure SQL Database. |
typeProperties.tenant |
object |
The name or ID of the tenant to which the service principal belongs. Type: string (or Expression with resultType string). |
typeProperties.trustServerCertificate |
object |
Indicate whether the channel will be encrypted while bypassing walking the certificate chain to validate trust, used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.userName |
object |
The user name to be used when connecting to server. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
The type used for authentication. Type: string.
Value | Description |
---|---|
SQL | |
ServicePrincipal | |
SystemAssignedManagedIdentity | |
UserAssignedManagedIdentity |
Azure SQL Data Warehouse linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.applicationIntent |
object |
The application workload type when connecting to a server, used by recommended version. Possible values are ReadOnly and ReadWrite. Type: string (or Expression with resultType string). |
typeProperties.authenticationType |
The type used for authentication. Type: string. |
|
typeProperties.azureCloudType |
object |
Indicates the azure cloud type of the service principle auth. Allowed values are AzurePublic, AzureChina, AzureUsGovernment, AzureGermany. Default value is the data factory regions’ cloud type. Type: string (or Expression with resultType string). |
typeProperties.commandTimeout |
object |
The default wait time (in seconds) before terminating the attempt to execute a command and generating an error, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.connectRetryCount |
object |
The number of re-connections attempted after identifying that there was an idle connection failure, used by recommended version. This must be an integer between 0 and 255. Type: integer (or Expression with resultType integer). |
typeProperties.connectRetryInterval |
object |
The amount of time (in seconds) between each re-connection attempt after identifying that there was an idle connection failure, used by recommended version. This must be an integer between 1 and 60. Type: integer (or Expression with resultType integer). |
typeProperties.connectTimeout |
object |
The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.connectionString |
object |
The connection string. Type: string, SecureString or AzureKeyVaultSecretReference. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.database |
object |
The name of the database, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.encrypt |
object |
Indicate whether TLS encryption is required for all data sent between the client and server, used by recommended version. Possible values are true/yes/mandatory, false/no/optional and strict. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.failoverPartner |
object |
The name or address of the partner server to connect to if the primary server is down, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.hostNameInCertificate |
object |
The host name to use when validating the server certificate for the connection. When not specified, the server name from the Data Source is used for certificate validation, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.integratedSecurity |
object |
Indicate whether User ID and Password are specified in the connection (when false) or whether the current Windows account credentials are used for authentication (when true), used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.loadBalanceTimeout |
object |
The minimum time, in seconds, for the connection to live in the connection pool before being destroyed, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.maxPoolSize |
object |
The maximum number of connections allowed in the connection pool for this specific connection string, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.minPoolSize |
object |
The minimum number of connections allowed in the connection pool for this specific connection string, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.multiSubnetFailover |
object |
If your application is connecting to an AlwaysOn availability group (AG) on different subnets, setting MultiSubnetFailover=true provides faster detection of and connection to the (currently) active server, used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.multipleActiveResultSets |
object |
When true, an application can maintain multiple active result sets (MARS). When false, an application must process or cancel all result sets from one batch before it can execute any other batch on that connection. Type: Boolean (or Expression with resultType boolean). |
typeProperties.packetSize |
object |
The size in bytes of the network packets used to communicate with an instance of server, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.password |
The Azure key vault secret reference of password in connection string. |
|
typeProperties.pooling |
object |
Indicate whether the connection will be pooled or explicitly opened every time that the connection is requested, used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.server |
object |
The name or network address of the instance of SQL Server to which to connect, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalCredential | SecretBase: |
The credential of the service principal object in Azure Active Directory. If servicePrincipalCredentialType is 'ServicePrincipalKey', servicePrincipalCredential can be SecureString or AzureKeyVaultSecretReference. If servicePrincipalCredentialType is 'ServicePrincipalCert', servicePrincipalCredential can only be AzureKeyVaultSecretReference. |
typeProperties.servicePrincipalCredentialType |
object |
The service principal credential type to use in Server-To-Server authentication. 'ServicePrincipalKey' for key/secret, 'ServicePrincipalCert' for certificate. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
The ID of the service principal used to authenticate against Azure SQL Data Warehouse. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
The key of the service principal used to authenticate against Azure SQL Data Warehouse. |
typeProperties.tenant |
object |
The name or ID of the tenant to which the service principal belongs. Type: string (or Expression with resultType string). |
typeProperties.trustServerCertificate |
object |
Indicate whether the channel will be encrypted while bypassing walking the certificate chain to validate trust, used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.userName |
object |
The user name to be used when connecting to server. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
The type used for authentication. Type: string.
Value | Description |
---|---|
SQL | |
ServicePrincipal | |
SystemAssignedManagedIdentity | |
UserAssignedManagedIdentity |
Azure SQL Managed Instance linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.alwaysEncryptedSettings |
Sql always encrypted properties. |
|
typeProperties.applicationIntent |
object |
The application workload type when connecting to a server, used by recommended version. Possible values are ReadOnly and ReadWrite. Type: string (or Expression with resultType string). |
typeProperties.authenticationType |
The type used for authentication. Type: string. |
|
typeProperties.azureCloudType |
object |
Indicates the azure cloud type of the service principle auth. Allowed values are AzurePublic, AzureChina, AzureUsGovernment, AzureGermany. Default value is the data factory regions’ cloud type. Type: string (or Expression with resultType string). |
typeProperties.commandTimeout |
object |
The default wait time (in seconds) before terminating the attempt to execute a command and generating an error, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.connectRetryCount |
object |
The number of re-connections attempted after identifying that there was an idle connection failure, used by recommended version. This must be an integer between 0 and 255. Type: integer (or Expression with resultType integer). |
typeProperties.connectRetryInterval |
object |
The amount of time (in seconds) between each re-connection attempt after identifying that there was an idle connection failure, used by recommended version. This must be an integer between 1 and 60. Type: integer (or Expression with resultType integer). |
typeProperties.connectTimeout |
object |
The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.connectionString |
object |
The connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.database |
object |
The name of the database, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.encrypt |
object |
Indicate whether TLS encryption is required for all data sent between the client and server, used by recommended version. Possible values are true/yes/mandatory, false/no/optional and strict. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.failoverPartner |
object |
The name or address of the partner server to connect to if the primary server is down, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.hostNameInCertificate |
object |
The host name to use when validating the server certificate for the connection. When not specified, the server name from the Data Source is used for certificate validation, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.integratedSecurity |
object |
Indicate whether User ID and Password are specified in the connection (when false) or whether the current Windows account credentials are used for authentication (when true), used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.loadBalanceTimeout |
object |
The minimum time, in seconds, for the connection to live in the connection pool before being destroyed, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.maxPoolSize |
object |
The maximum number of connections allowed in the connection pool for this specific connection string, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.minPoolSize |
object |
The minimum number of connections allowed in the connection pool for this specific connection string, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.multiSubnetFailover |
object |
If your application is connecting to an AlwaysOn availability group (AG) on different subnets, setting MultiSubnetFailover=true provides faster detection of and connection to the (currently) active server, used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.multipleActiveResultSets |
object |
When true, an application can maintain multiple active result sets (MARS). When false, an application must process or cancel all result sets from one batch before it can execute any other batch on that connection. Type: Boolean (or Expression with resultType boolean). |
typeProperties.packetSize |
object |
The size in bytes of the network packets used to communicate with an instance of server, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.password |
The Azure key vault secret reference of password in connection string. |
|
typeProperties.pooling |
object |
Indicate whether the connection will be pooled or explicitly opened every time that the connection is requested, used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.server |
object |
The name or network address of the instance of SQL Server to which to connect, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalCredential | SecretBase: |
The credential of the service principal object in Azure Active Directory. If servicePrincipalCredentialType is 'ServicePrincipalKey', servicePrincipalCredential can be SecureString or AzureKeyVaultSecretReference. If servicePrincipalCredentialType is 'ServicePrincipalCert', servicePrincipalCredential can only be AzureKeyVaultSecretReference. |
typeProperties.servicePrincipalCredentialType |
object |
The service principal credential type to use in Server-To-Server authentication. 'ServicePrincipalKey' for key/secret, 'ServicePrincipalCert' for certificate. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
The ID of the service principal used to authenticate against Azure SQL Managed Instance. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
The key of the service principal used to authenticate against Azure SQL Managed Instance. |
typeProperties.tenant |
object |
The name or ID of the tenant to which the service principal belongs. Type: string (or Expression with resultType string). |
typeProperties.trustServerCertificate |
object |
Indicate whether the channel will be encrypted while bypassing walking the certificate chain to validate trust, used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.userName |
object |
The user name to be used when connecting to server. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
The type used for authentication. Type: string.
Value | Description |
---|---|
AccountKey | |
Anonymous | |
Msi | |
SasUri | |
ServicePrincipal |
The storage account linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.accountKey |
The Azure key vault secret reference of accountKey in connection string. |
|
typeProperties.connectionString |
object |
The connection string. It is mutually exclusive with sasUri property. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.encryptedCredential |
string |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.sasToken |
The Azure key vault secret reference of sasToken in sas uri. |
|
typeProperties.sasUri |
object |
SAS URI of the Azure Storage resource. It is mutually exclusive with connectionString property. Type: string, SecureString or AzureKeyVaultSecretReference. |
version |
string |
Version of the linked service. |
Azure Synapse Analytics (Artifacts) linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.authentication |
object |
Required to specify MSI, if using system assigned managed identity as authentication method. Type: string (or Expression with resultType string). |
typeProperties.endpoint |
object |
https://.dev.azuresynapse.net, Azure Synapse Analytics workspace URL. Type: string (or Expression with resultType string). |
typeProperties.workspaceResourceId |
object |
The resource ID of the Synapse workspace. The format should be: /subscriptions/{subscriptionID}/resourceGroups/{resourceGroup}/providers/Microsoft.Synapse/workspaces/{workspaceName}. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
The azure table storage linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Azure |
Type of linked service. |
typeProperties.accountKey |
The Azure key vault secret reference of accountKey in connection string. |
|
typeProperties.connectionString |
object |
The connection string. It is mutually exclusive with sasUri property. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.encryptedCredential |
string |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.sasToken |
The Azure key vault secret reference of sasToken in sas uri. |
|
typeProperties.sasUri |
object |
SAS URI of the Azure Storage resource. It is mutually exclusive with connectionString property. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.serviceEndpoint |
object |
Table service endpoint of the Azure Table Storage resource. It is mutually exclusive with connectionString, sasUri property. |
version |
string |
Version of the linked service. |
Linked service for Cassandra data source.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Cassandra |
Type of linked service. |
typeProperties.authenticationType |
object |
AuthenticationType to be used for connection. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
Host name for connection. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password for authentication. |
typeProperties.port |
object |
The port for the connection. Type: integer (or Expression with resultType integer). |
typeProperties.username |
object |
Username for authentication. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
The object that defines the structure of an Azure Synapse error response.
Name | Type | Description |
---|---|---|
error.code |
string |
Error code. |
error.details |
Array with additional error details. |
|
error.message |
string |
Error message. |
error.target |
string |
Property name/path in request associated with error. |
Common Data Service for Apps linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Common |
Type of linked service. |
typeProperties.authenticationType |
object |
The authentication type to connect to Common Data Service for Apps server. 'Office365' for online scenario, 'Ifd' for on-premises with Ifd scenario. 'AADServicePrincipal' for Server-To-Server authentication in online scenario, 'Active Directory' for Dynamics on-premises with IFD. Type: string (or Expression with resultType string). |
typeProperties.deploymentType |
object |
The deployment type of the Common Data Service for Apps instance. 'Online' for Common Data Service for Apps Online and 'OnPremisesWithIfd' for Common Data Service for Apps on-premises with Ifd. Type: string (or Expression with resultType string). |
typeProperties.domain |
object |
The Active Directory domain that will verify user credentials. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.hostName |
object |
The host name of the on-premises Common Data Service for Apps server. The property is required for on-prem and not allowed for online. Type: string (or Expression with resultType string). |
typeProperties.organizationName |
object |
The organization name of the Common Data Service for Apps instance. The property is required for on-prem and required for online when there are more than one Common Data Service for Apps instances associated with the user. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password to access the Common Data Service for Apps instance. |
typeProperties.port |
object |
The port of on-premises Common Data Service for Apps server. The property is required for on-prem and not allowed for online. Default is 443. Type: integer (or Expression with resultType integer), minimum: 0. |
typeProperties.servicePrincipalCredential | SecretBase: |
The credential of the service principal object in Azure Active Directory. If servicePrincipalCredentialType is 'ServicePrincipalKey', servicePrincipalCredential can be SecureString or AzureKeyVaultSecretReference. If servicePrincipalCredentialType is 'ServicePrincipalCert', servicePrincipalCredential can only be AzureKeyVaultSecretReference. |
typeProperties.servicePrincipalCredentialType |
object |
A string from ServicePrincipalCredentialEnum or an expression |
typeProperties.servicePrincipalId |
object |
The client ID of the application in Azure Active Directory used for Server-To-Server authentication. Type: string (or Expression with resultType string). |
typeProperties.serviceUri |
object |
The URL to the Microsoft Common Data Service for Apps server. The property is required for on-line and not allowed for on-prem. Type: string (or Expression with resultType string). |
typeProperties.username |
object |
User name to access the Common Data Service for Apps instance. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Concur Service linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Concur |
Type of linked service. |
typeProperties.clientId |
object |
Application client_id supplied by Concur App Management. |
typeProperties.connectionProperties |
object |
Properties used to connect to Concur. It is mutually exclusive with any other properties in the linked service. Type: object. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
The password corresponding to the user name that you provided in the username field. |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. |
typeProperties.useHostVerification |
object |
Specifies whether to require the host name in the server's certificate to match the host name of the server when connecting over SSL. The default value is true. |
typeProperties.usePeerVerification |
object |
Specifies whether to verify the identity of the server when connecting over SSL. The default value is true. |
typeProperties.username |
object |
The user name that you use to access Concur Service. |
version |
string |
Version of the linked service. |
Microsoft Azure Cosmos Database (CosmosDB) linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Cosmos |
Type of linked service. |
typeProperties.accountEndpoint |
object |
The endpoint of the Azure CosmosDB account. Type: string (or Expression with resultType string) |
typeProperties.accountKey | SecretBase: |
The account key of the Azure CosmosDB account. Type: SecureString or AzureKeyVaultSecretReference. |
typeProperties.connectionString |
object |
The connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.database |
object |
The name of the database. Type: string (or Expression with resultType string) |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Linked service for CosmosDB (MongoDB API) data source.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Cosmos |
Type of linked service. |
typeProperties.connectionString |
object |
The CosmosDB (MongoDB API) connection string. Type: string, SecureString or AzureKeyVaultSecretReference. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.database |
object |
The name of the CosmosDB (MongoDB API) database that you want to access. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Couchbase server linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Couchbase |
Type of linked service. |
typeProperties.connectionString |
object |
An ODBC connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.credString |
The Azure key vault secret reference of credString in connection string. |
|
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Credential reference type.
Name | Type | Description |
---|---|---|
referenceName |
string |
Reference credential name. |
type |
Credential reference type. |
Credential reference type.
Value | Description |
---|---|
CredentialReference |
Custom linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Custom |
Type of linked service. |
version |
string |
Version of the linked service. |
Linked service for Dataworld.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Dataworld |
Type of linked service. |
typeProperties.apiToken | SecretBase: |
The api token for the Dataworld source. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
AuthenticationType to be used for connection. It is mutually exclusive with connectionString property.
Value | Description |
---|---|
Basic |
Linked service for DB2 data source.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Db2 |
Type of linked service. |
typeProperties.authenticationType |
AuthenticationType to be used for connection. It is mutually exclusive with connectionString property. |
|
typeProperties.certificateCommonName |
object |
Certificate Common Name when TLS is enabled. It is mutually exclusive with connectionString property. Type: string (or Expression with resultType string). |
typeProperties.connectionString |
object |
The connection string. It is mutually exclusive with server, database, authenticationType, userName, packageCollection and certificateCommonName property. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.database |
object |
Database name for connection. It is mutually exclusive with connectionString property. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. It is mutually exclusive with connectionString property. Type: string (or Expression with resultType string). |
typeProperties.packageCollection |
object |
Under where packages are created when querying database. It is mutually exclusive with connectionString property. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password for authentication. |
typeProperties.server |
object |
Server name for connection. It is mutually exclusive with connectionString property. Type: string (or Expression with resultType string). |
typeProperties.username |
object |
Username for authentication. It is mutually exclusive with connectionString property. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Drill server linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Drill |
Type of linked service. |
typeProperties.connectionString |
object |
An ODBC connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.pwd |
The Azure key vault secret reference of password in connection string. |
|
version |
string |
Version of the linked service. |
Dynamics AX linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
DynamicsAX |
Type of linked service. |
typeProperties.aadResourceId |
object |
Specify the resource you are requesting authorization. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
Specify the application's client ID. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
Specify the application's key. Mark this field as a SecureString to store it securely in Data Factory, or reference a secret stored in Azure Key Vault. Type: string (or Expression with resultType string). |
typeProperties.tenant |
object |
Specify the tenant information (domain name or tenant ID) under which your application resides. Retrieve it by hovering the mouse in the top-right corner of the Azure portal. Type: string (or Expression with resultType string). |
typeProperties.url |
object |
The Dynamics AX (or Dynamics 365 Finance and Operations) instance OData endpoint. |
version |
string |
Version of the linked service. |
Dynamics CRM linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Dynamics |
Type of linked service. |
typeProperties.authenticationType |
object |
The authentication type to connect to Dynamics CRM server. 'Office365' for online scenario, 'Ifd' for on-premises with Ifd scenario, 'AADServicePrincipal' for Server-To-Server authentication in online scenario, 'Active Directory' for Dynamics on-premises with IFD. Type: string (or Expression with resultType string). |
typeProperties.credential | SecretBase: |
The credential reference containing authentication information. |
typeProperties.deploymentType |
object |
The deployment type of the Dynamics CRM instance. 'Online' for Dynamics CRM Online and 'OnPremisesWithIfd' for Dynamics CRM on-premises with Ifd. Type: string (or Expression with resultType string). |
typeProperties.domain |
object |
The Active Directory domain that will verify user credentials. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.hostName |
object |
The host name of the on-premises Dynamics CRM server. The property is required for on-prem and not allowed for online. Type: string (or Expression with resultType string). |
typeProperties.organizationName |
object |
The organization name of the Dynamics CRM instance. The property is required for on-prem and required for online when there are more than one Dynamics CRM instances associated with the user. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password to access the Dynamics CRM instance. |
typeProperties.port |
object |
The port of on-premises Dynamics CRM server. The property is required for on-prem and not allowed for online. Default is 443. Type: integer (or Expression with resultType integer), minimum: 0. |
typeProperties.servicePrincipalCredential | SecretBase: |
The credential of the service principal object in Azure Active Directory. If servicePrincipalCredentialType is 'ServicePrincipalKey', servicePrincipalCredential can be SecureString or AzureKeyVaultSecretReference. If servicePrincipalCredentialType is 'ServicePrincipalCert', servicePrincipalCredential can only be AzureKeyVaultSecretReference. |
typeProperties.servicePrincipalCredentialType |
object |
A string from ServicePrincipalCredentialEnum or an expression |
typeProperties.servicePrincipalId |
object |
The client ID of the application in Azure Active Directory used for Server-To-Server authentication. Type: string (or Expression with resultType string). |
typeProperties.serviceUri |
object |
The URL to the Microsoft Dynamics CRM server. The property is required for on-line and not allowed for on-prem. Type: string (or Expression with resultType string). |
typeProperties.username |
object |
User name to access the Dynamics CRM instance. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Dynamics linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Dynamics |
Type of linked service. |
typeProperties.authenticationType |
object |
The authentication type to connect to Dynamics server. 'Office365' for online scenario, 'Ifd' for on-premises with Ifd scenario, 'AADServicePrincipal' for Server-To-Server authentication in online scenario, 'Active Directory' for Dynamics on-premises with IFD. Type: string (or Expression with resultType string). |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.deploymentType |
object |
The deployment type of the Dynamics instance. 'Online' for Dynamics Online and 'OnPremisesWithIfd' for Dynamics on-premises with Ifd. Type: string (or Expression with resultType string). |
typeProperties.domain |
object |
The Active Directory domain that will verify user credentials. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.hostName |
object |
The host name of the on-premises Dynamics server. The property is required for on-prem and not allowed for online. Type: string (or Expression with resultType string). |
typeProperties.organizationName |
object |
The organization name of the Dynamics instance. The property is required for on-prem and required for online when there are more than one Dynamics instances associated with the user. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password to access the Dynamics instance. |
typeProperties.port |
object |
The port of on-premises Dynamics server. The property is required for on-prem and not allowed for online. Default is 443. Type: integer (or Expression with resultType integer), minimum: 0. |
typeProperties.servicePrincipalCredential | SecretBase: |
The credential of the service principal object in Azure Active Directory. If servicePrincipalCredentialType is 'ServicePrincipalKey', servicePrincipalCredential can be SecureString or AzureKeyVaultSecretReference. If servicePrincipalCredentialType is 'ServicePrincipalCert', servicePrincipalCredential can only be AzureKeyVaultSecretReference. |
typeProperties.servicePrincipalCredentialType |
object |
The service principal credential type to use in Server-To-Server authentication. 'ServicePrincipalKey' for key/secret, 'ServicePrincipalCert' for certificate. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
The client ID of the application in Azure Active Directory used for Server-To-Server authentication. Type: string (or Expression with resultType string). |
typeProperties.serviceUri |
object |
The URL to the Microsoft Dynamics server. The property is required for on-line and not allowed for on-prem. Type: string (or Expression with resultType string). |
typeProperties.username |
object |
User name to access the Dynamics instance. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Eloqua server linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Eloqua |
Type of linked service. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.endpoint |
object |
The endpoint of the Eloqua server. (i.e. eloqua.example.com) |
typeProperties.password | SecretBase: |
The password corresponding to the user name. |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. |
typeProperties.useHostVerification |
object |
Specifies whether to require the host name in the server's certificate to match the host name of the server when connecting over SSL. The default value is true. |
typeProperties.usePeerVerification |
object |
Specifies whether to verify the identity of the server when connecting over SSL. The default value is true. |
typeProperties.username |
object |
The site name and user name of your Eloqua account in the form: sitename/username. (i.e. Eloqua/Alice) |
version |
string |
Version of the linked service. |
File system linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
File |
Type of linked service. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
Host name of the server. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password to logon the server. |
typeProperties.userId |
object |
User ID to logon the server. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
The authentication type to be used to connect to the FTP server.
Value | Description |
---|---|
Anonymous | |
Basic |
A FTP server Linked Service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Ftp |
Type of linked service. |
typeProperties.authenticationType |
The authentication type to be used to connect to the FTP server. |
|
typeProperties.enableServerCertificateValidation |
object |
If true, validate the FTP server SSL certificate when connect over SSL/TLS channel. Default value is true. Type: boolean (or Expression with resultType boolean). |
typeProperties.enableSsl |
object |
If true, connect to the FTP server over SSL/TLS channel. Default value is true. Type: boolean (or Expression with resultType boolean). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
Host name of the FTP server. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password to logon the FTP server. |
typeProperties.port |
object |
The TCP port number that the FTP server uses to listen for client connections. Default value is 21. Type: integer (or Expression with resultType integer), minimum: 0. |
typeProperties.userName |
object |
Username to logon the FTP server. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
The OAuth 2.0 authentication mechanism used for authentication. ServiceAuthentication can only be used on self-hosted IR.
Value | Description |
---|---|
ServiceAuthentication | |
UserAuthentication |
Google AdWords service linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Google |
Type of linked service. |
typeProperties.authenticationType |
The OAuth 2.0 authentication mechanism used for authentication. ServiceAuthentication can only be used on self-hosted IR. |
|
typeProperties.clientCustomerID |
object |
The Client customer ID of the AdWords account that you want to fetch report data for. |
typeProperties.clientId |
object |
The client id of the google application used to acquire the refresh token. Type: string (or Expression with resultType string). |
typeProperties.clientSecret | SecretBase: |
The client secret of the google application used to acquire the refresh token. |
typeProperties.connectionProperties |
object |
(Deprecated) Properties used to connect to GoogleAds. It is mutually exclusive with any other properties in the linked service. Type: object. |
typeProperties.developerToken | SecretBase: |
The developer token associated with the manager account that you use to grant access to the AdWords API. |
typeProperties.email |
object |
The service account email ID that is used for ServiceAuthentication and can only be used on self-hosted IR. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.googleAdsApiVersion |
object |
The Google Ads API major version such as v14. The supported major versions could be found on https://developers.google.com/google-ads/api/docs/release-notes. |
typeProperties.keyFilePath |
object |
(Deprecated) The full path to the .p12 key file that is used to authenticate the service account email address and can only be used on self-hosted IR. |
typeProperties.loginCustomerID |
object |
The customer ID of the Google Ads Manager account through which you want to fetch report data of specific Customer. |
typeProperties.privateKey | SecretBase: |
The private key that is used to authenticate the service account email address and can only be used on self-hosted IR. |
typeProperties.refreshToken | SecretBase: |
The refresh token obtained from Google for authorizing access to AdWords for UserAuthentication. |
typeProperties.supportLegacyDataTypes |
object |
Specifies whether to use the legacy data type mappings, which maps float, int32 and int64 from Google to string. Do not set this to true unless you want to keep backward compatibility with legacy driver's data type mappings. Type: boolean (or Expression with resultType boolean). |
typeProperties.trustedCertPath |
object |
(Deprecated) The full path of the .pem file containing trusted CA certificates for verifying the server when connecting over SSL. This property can only be set when using SSL on self-hosted IR. The default value is the cacerts.pem file installed with the IR. |
typeProperties.useSystemTrustStore |
object |
(Deprecated) Specifies whether to use a CA certificate from the system trust store or from a specified PEM file. The default value is false. |
version |
string |
Version of the linked service. |
The OAuth 2.0 authentication mechanism used for authentication. ServiceAuthentication can only be used on self-hosted IR.
Value | Description |
---|---|
ServiceAuthentication | |
UserAuthentication |
Google BigQuery service linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Google |
Type of linked service. |
typeProperties.additionalProjects |
object |
A comma-separated list of public BigQuery projects to access. |
typeProperties.authenticationType |
The OAuth 2.0 authentication mechanism used for authentication. ServiceAuthentication can only be used on self-hosted IR. |
|
typeProperties.clientId |
object |
The client id of the google application used to acquire the refresh token. Type: string (or Expression with resultType string). |
typeProperties.clientSecret | SecretBase: |
The client secret of the google application used to acquire the refresh token. |
typeProperties.email |
object |
The service account email ID that is used for ServiceAuthentication and can only be used on self-hosted IR. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.keyFilePath |
object |
The full path to the .p12 key file that is used to authenticate the service account email address and can only be used on self-hosted IR. |
typeProperties.project |
object |
The default BigQuery project to query against. |
typeProperties.refreshToken | SecretBase: |
The refresh token obtained from Google for authorizing access to BigQuery for UserAuthentication. |
typeProperties.requestGoogleDriveScope |
object |
Whether to request access to Google Drive. Allowing Google Drive access enables support for federated tables that combine BigQuery data with data from Google Drive. The default value is false. |
typeProperties.trustedCertPath |
object |
The full path of the .pem file containing trusted CA certificates for verifying the server when connecting over SSL. This property can only be set when using SSL on self-hosted IR. The default value is the cacerts.pem file installed with the IR. |
typeProperties.useSystemTrustStore |
object |
Specifies whether to use a CA certificate from the system trust store or from a specified PEM file. The default value is false. |
version |
string |
Version of the linked service. |
The OAuth 2.0 authentication mechanism used for authentication.
Value | Description |
---|---|
ServiceAuthentication | |
UserAuthentication |
Google BigQuery service linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Google |
Type of linked service. |
typeProperties.authenticationType |
The OAuth 2.0 authentication mechanism used for authentication. |
|
typeProperties.clientId |
object |
The client id of the google application used to acquire the refresh token. Type: string (or Expression with resultType string). |
typeProperties.clientSecret | SecretBase: |
The client secret of the google application used to acquire the refresh token. |
typeProperties.encryptedCredential |
string |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.keyFileContent | SecretBase: |
The content of the .json key file that is used to authenticate the service account. |
typeProperties.projectId |
object |
The default BigQuery project id to query against. |
typeProperties.refreshToken | SecretBase: |
The refresh token obtained from Google for authorizing access to BigQuery for UserAuthentication. |
version |
string |
Version of the linked service. |
Linked service for Google Cloud Storage.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Google |
Type of linked service. |
typeProperties.accessKeyId |
object |
The access key identifier of the Google Cloud Storage Identity and Access Management (IAM) user. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.secretAccessKey | SecretBase: |
The secret access key of the Google Cloud Storage Identity and Access Management (IAM) user. |
typeProperties.serviceUrl |
object |
This value specifies the endpoint to access with the Google Cloud Storage Connector. This is an optional property; change it only if you want to try a different service endpoint or want to switch between https and http. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Linked service for GoogleSheets.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Google |
Type of linked service. |
typeProperties.apiToken | SecretBase: |
The api token for the GoogleSheets source. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
The authentication type to use. Type: string. Only used for V2.
Value | Description |
---|---|
Basic |
Greenplum Database linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Greenplum |
Type of linked service. |
typeProperties.authenticationType |
The authentication type to use. Type: string. Only used for V2. |
|
typeProperties.commandTimeout |
object |
The time to wait (in seconds) while trying to execute a command before terminating the attempt and generating an error. Set to zero for infinity. Type: integer. Only used for V2. |
typeProperties.connectionString |
object |
An ODBC connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.connectionTimeout |
object |
The time to wait (in seconds) while trying to establish a connection before terminating the attempt and generating an error. Type: integer. Only used for V2. |
typeProperties.database |
object |
Database name for connection. Type: string. Only used for V2. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
Host name for connection. Type: string. Only used for V2. |
typeProperties.port |
object |
The port for the connection. Type: integer. Only used for V2. |
typeProperties.pwd |
The Azure key vault secret reference of password in connection string. |
|
typeProperties.sslMode |
object |
SSL mode for connection. Type: integer. 0: disable, 1:allow, 2: prefer, 3: require, 4: verify-ca, 5: verify-full. Type: integer. Only used for V2. |
typeProperties.username |
object |
Username for authentication. Type: string. Only used for V2. |
version |
string |
Version of the linked service. |
The authentication mechanism to use to connect to the HBase server.
Value | Description |
---|---|
Anonymous | |
Basic |
HBase server linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
HBase |
Type of linked service. |
typeProperties.allowHostNameCNMismatch |
object |
Specifies whether to require a CA-issued SSL certificate name to match the host name of the server when connecting over SSL. The default value is false. |
typeProperties.allowSelfSignedServerCert |
object |
Specifies whether to allow self-signed certificates from the server. The default value is false. |
typeProperties.authenticationType |
The authentication mechanism to use to connect to the HBase server. |
|
typeProperties.enableSsl |
object |
Specifies whether the connections to the server are encrypted using SSL. The default value is false. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
The IP address or host name of the HBase server. (i.e. 192.168.222.160) |
typeProperties.httpPath |
object |
The partial URL corresponding to the HBase server. (i.e. /gateway/sandbox/hbase/version) |
typeProperties.password | SecretBase: |
The password corresponding to the user name. |
typeProperties.port |
object |
The TCP port that the HBase instance uses to listen for client connections. The default value is 9090. |
typeProperties.trustedCertPath |
object |
The full path of the .pem file containing trusted CA certificates for verifying the server when connecting over SSL. This property can only be set when using SSL on self-hosted IR. The default value is the cacerts.pem file installed with the IR. |
typeProperties.username |
object |
The user name used to connect to the HBase instance. |
version |
string |
Version of the linked service. |
Hadoop Distributed File System (HDFS) linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Hdfs |
Type of linked service. |
typeProperties.authenticationType |
object |
Type of authentication used to connect to the HDFS. Possible values are: Anonymous and Windows. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password for Windows authentication. |
typeProperties.url |
object |
The URL of the HDFS service endpoint, e.g. http://myhostname:50070/webhdfs/v1 . Type: string (or Expression with resultType string). |
typeProperties.userName |
object |
User name for Windows authentication. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
HDInsight linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
HDInsight |
Type of linked service. |
typeProperties.clusterUri |
object |
HDInsight cluster URI. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.fileSystem |
object |
Specify the FileSystem if the main storage for the HDInsight is ADLS Gen2. Type: string (or Expression with resultType string). |
typeProperties.hcatalogLinkedServiceName |
A reference to the Azure SQL linked service that points to the HCatalog database. |
|
typeProperties.isEspEnabled |
object |
Specify if the HDInsight is created with ESP (Enterprise Security Package). Type: Boolean. |
typeProperties.linkedServiceName |
The Azure Storage linked service reference. |
|
typeProperties.password | SecretBase: |
HDInsight cluster password. |
typeProperties.userName |
object |
HDInsight cluster user name. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
HDInsight ondemand linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
HDInsight |
Type of linked service. |
typeProperties.additionalLinkedServiceNames |
Specifies additional storage accounts for the HDInsight linked service so that the Data Factory service can register them on your behalf. |
|
typeProperties.clusterNamePrefix |
object |
The prefix of cluster name, postfix will be distinct with timestamp. Type: string (or Expression with resultType string). |
typeProperties.clusterPassword | SecretBase: |
The password to access the cluster. |
typeProperties.clusterResourceGroup |
object |
The resource group where the cluster belongs. Type: string (or Expression with resultType string). |
typeProperties.clusterSize |
object |
Number of worker/data nodes in the cluster. Suggestion value: 4. Type: string (or Expression with resultType string). |
typeProperties.clusterSshPassword | SecretBase: |
The password to SSH remotely connect cluster’s node (for Linux). |
typeProperties.clusterSshUserName |
object |
The username to SSH remotely connect to cluster’s node (for Linux). Type: string (or Expression with resultType string). |
typeProperties.clusterType |
object |
The cluster type. Type: string (or Expression with resultType string). |
typeProperties.clusterUserName |
object |
The username to access the cluster. Type: string (or Expression with resultType string). |
typeProperties.coreConfiguration |
object |
Specifies the core configuration parameters (as in core-site.xml) for the HDInsight cluster to be created. |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.dataNodeSize |
object |
Specifies the size of the data node for the HDInsight cluster. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.hBaseConfiguration |
object |
Specifies the HBase configuration parameters (hbase-site.xml) for the HDInsight cluster. |
typeProperties.hcatalogLinkedServiceName |
The name of Azure SQL linked service that point to the HCatalog database. The on-demand HDInsight cluster is created by using the Azure SQL database as the metastore. |
|
typeProperties.hdfsConfiguration |
object |
Specifies the HDFS configuration parameters (hdfs-site.xml) for the HDInsight cluster. |
typeProperties.headNodeSize |
object |
Specifies the size of the head node for the HDInsight cluster. |
typeProperties.hiveConfiguration |
object |
Specifies the hive configuration parameters (hive-site.xml) for the HDInsight cluster. |
typeProperties.hostSubscriptionId |
object |
The customer’s subscription to host the cluster. Type: string (or Expression with resultType string). |
typeProperties.linkedServiceName |
Azure Storage linked service to be used by the on-demand cluster for storing and processing data. |
|
typeProperties.mapReduceConfiguration |
object |
Specifies the MapReduce configuration parameters (mapred-site.xml) for the HDInsight cluster. |
typeProperties.oozieConfiguration |
object |
Specifies the Oozie configuration parameters (oozie-site.xml) for the HDInsight cluster. |
typeProperties.scriptActions |
Custom script actions to run on HDI ondemand cluster once it's up. Please refer to https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-hadoop-customize-cluster-linux?toc=%2Fen-us%2Fazure%2Fhdinsight%2Fr-server%2FTOC.json&bc=%2Fen-us%2Fazure%2Fbread%2Ftoc.json#understanding-script-actions. |
|
typeProperties.servicePrincipalId |
object |
The service principal id for the hostSubscriptionId. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
The key for the service principal id. |
typeProperties.sparkVersion |
object |
The version of spark if the cluster type is 'spark'. Type: string (or Expression with resultType string). |
typeProperties.stormConfiguration |
object |
Specifies the Storm configuration parameters (storm-site.xml) for the HDInsight cluster. |
typeProperties.subnetName |
object |
The ARM resource ID for the subnet in the vNet. If virtualNetworkId was specified, then this property is required. Type: string (or Expression with resultType string). |
typeProperties.tenant |
object |
The Tenant id/name to which the service principal belongs. Type: string (or Expression with resultType string). |
typeProperties.timeToLive |
object |
The allowed idle time for the on-demand HDInsight cluster. Specifies how long the on-demand HDInsight cluster stays alive after completion of an activity run if there are no other active jobs in the cluster. The minimum value is 5 mins. Type: string (or Expression with resultType string). |
typeProperties.version |
object |
Version of the HDInsight cluster. Type: string (or Expression with resultType string). |
typeProperties.virtualNetworkId |
object |
The ARM resource ID for the vNet to which the cluster should be joined after creation. Type: string (or Expression with resultType string). |
typeProperties.yarnConfiguration |
object |
Specifies the Yarn configuration parameters (yarn-site.xml) for the HDInsight cluster. |
typeProperties.zookeeperNodeSize |
object |
Specifies the size of the Zoo Keeper node for the HDInsight cluster. |
version |
string |
Version of the linked service. |
The authentication method used to access the Hive server.
Value | Description |
---|---|
Anonymous | |
Username | |
UsernameAndPassword | |
WindowsAzureHDInsightService |
Hive Server linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Hive |
Type of linked service. |
typeProperties.allowHostNameCNMismatch |
object |
Specifies whether to require a CA-issued SSL certificate name to match the host name of the server when connecting over SSL. The default value is false. |
typeProperties.allowSelfSignedServerCert |
object |
Specifies whether to allow self-signed certificates from the server. The default value is false. |
typeProperties.authenticationType |
The authentication method used to access the Hive server. |
|
typeProperties.enableSsl |
object |
Specifies whether the connections to the server are encrypted using SSL. The default value is false. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
IP address or host name of the Hive server, separated by ';' for multiple hosts (only when serviceDiscoveryMode is enable). |
typeProperties.httpPath |
object |
The partial URL corresponding to the Hive server. |
typeProperties.password | SecretBase: |
The password corresponding to the user name that you provided in the Username field |
typeProperties.port |
object |
The TCP port that the Hive server uses to listen for client connections. |
typeProperties.serverType |
The type of Hive server. |
|
typeProperties.serviceDiscoveryMode |
object |
true to indicate using the ZooKeeper service, false not. |
typeProperties.thriftTransportProtocol |
The transport protocol to use in the Thrift layer. |
|
typeProperties.trustedCertPath |
object |
The full path of the .pem file containing trusted CA certificates for verifying the server when connecting over SSL. This property can only be set when using SSL on self-hosted IR. The default value is the cacerts.pem file installed with the IR. |
typeProperties.useNativeQuery |
object |
Specifies whether the driver uses native HiveQL queries,or converts them into an equivalent form in HiveQL. |
typeProperties.useSystemTrustStore |
object |
Specifies whether to use a CA certificate from the system trust store or from a specified PEM file. The default value is false. |
typeProperties.username |
object |
The user name that you use to access Hive Server. |
typeProperties.zooKeeperNameSpace |
object |
The namespace on ZooKeeper under which Hive Server 2 nodes are added. |
version |
string |
Version of the linked service. |
The type of Hive server.
Value | Description |
---|---|
HiveServer1 | |
HiveServer2 | |
HiveThriftServer |
The transport protocol to use in the Thrift layer.
Value | Description |
---|---|
Binary | |
HTTP | |
SASL |
The authentication type to be used to connect to the HTTP server.
Value | Description |
---|---|
Anonymous | |
Basic | |
ClientCertificate | |
Digest | |
Windows |
Linked service for an HTTP source.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Http |
Type of linked service. |
typeProperties.authenticationType |
The authentication type to be used to connect to the HTTP server. |
|
typeProperties.certThumbprint |
object |
Thumbprint of certificate for ClientCertificate authentication. Only valid for on-premises copy. For on-premises copy with ClientCertificate authentication, either CertThumbprint or EmbeddedCertData/Password should be specified. Type: string (or Expression with resultType string). |
typeProperties.embeddedCertData |
object |
Base64 encoded certificate data for ClientCertificate authentication. For on-premises copy with ClientCertificate authentication, either CertThumbprint or EmbeddedCertData/Password should be specified. Type: string (or Expression with resultType string). |
typeProperties.enableServerCertificateValidation |
object |
If true, validate the HTTPS server SSL certificate. Default value is true. Type: boolean (or Expression with resultType boolean). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password for Basic, Digest, Windows, or ClientCertificate with EmbeddedCertData authentication. |
typeProperties.url |
object |
The base URL of the HTTP endpoint, e.g. http://www.microsoft.com. Type: string (or Expression with resultType string). |
typeProperties.userName |
object |
User name for Basic, Digest, or Windows authentication. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Hubspot Service linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Hubspot |
Type of linked service. |
typeProperties.accessToken | SecretBase: |
The access token obtained when initially authenticating your OAuth integration. |
typeProperties.clientId |
object |
The client ID associated with your Hubspot application. |
typeProperties.clientSecret | SecretBase: |
The client secret associated with your Hubspot application. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.refreshToken | SecretBase: |
The refresh token obtained when initially authenticating your OAuth integration. |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. |
typeProperties.useHostVerification |
object |
Specifies whether to require the host name in the server's certificate to match the host name of the server when connecting over SSL. The default value is true. |
typeProperties.usePeerVerification |
object |
Specifies whether to verify the identity of the server when connecting over SSL. The default value is true. |
version |
string |
Version of the linked service. |
The authentication type to use.
Value | Description |
---|---|
Anonymous | |
SASLUsername | |
UsernameAndPassword |
Impala server linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Impala |
Type of linked service. |
typeProperties.allowHostNameCNMismatch |
object |
Specifies whether to require a CA-issued SSL certificate name to match the host name of the server when connecting over SSL. The default value is false. |
typeProperties.allowSelfSignedServerCert |
object |
Specifies whether to allow self-signed certificates from the server. The default value is false. |
typeProperties.authenticationType |
The authentication type to use. |
|
typeProperties.enableSsl |
object |
Specifies whether the connections to the server are encrypted using SSL. The default value is false. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
The IP address or host name of the Impala server. (i.e. 192.168.222.160) |
typeProperties.password | SecretBase: |
The password corresponding to the user name when using UsernameAndPassword. |
typeProperties.port |
object |
The TCP port that the Impala server uses to listen for client connections. The default value is 21050. |
typeProperties.trustedCertPath |
object |
The full path of the .pem file containing trusted CA certificates for verifying the server when connecting over SSL. This property can only be set when using SSL on self-hosted IR. The default value is the cacerts.pem file installed with the IR. |
typeProperties.useSystemTrustStore |
object |
Specifies whether to use a CA certificate from the system trust store or from a specified PEM file. The default value is false. |
typeProperties.username |
object |
The user name used to access the Impala server. The default value is anonymous when using SASLUsername. |
version |
string |
Version of the linked service. |
Informix linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Informix |
Type of linked service. |
typeProperties.authenticationType |
object |
Type of authentication used to connect to the Informix as ODBC data store. Possible values are: Anonymous and Basic. Type: string (or Expression with resultType string). |
typeProperties.connectionString |
object |
The non-access credential portion of the connection string as well as an optional encrypted credential. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.credential | SecretBase: |
The access credential portion of the connection string specified in driver-specific property-value format. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password for Basic authentication. |
typeProperties.userName |
object |
User name for Basic authentication. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Integration runtime reference type.
Name | Type | Description |
---|---|---|
parameters |
object |
Arguments for integration runtime. |
referenceName |
string |
Reference integration runtime name. |
type |
Type of integration runtime. |
Type of integration runtime.
Value | Description |
---|---|
IntegrationRuntimeReference |
Jira Service linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Jira |
Type of linked service. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
The IP address or host name of the Jira service. (e.g. jira.example.com) |
typeProperties.password | SecretBase: |
The password corresponding to the user name that you provided in the username field. |
typeProperties.port |
object |
The TCP port that the Jira server uses to listen for client connections. The default value is 443 if connecting through HTTPS, or 8080 if connecting through HTTP. |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. |
typeProperties.useHostVerification |
object |
Specifies whether to require the host name in the server's certificate to match the host name of the server when connecting over SSL. The default value is true. |
typeProperties.usePeerVerification |
object |
Specifies whether to verify the identity of the server when connecting over SSL. The default value is true. |
typeProperties.username |
object |
The user name that you use to access Jira Service. |
version |
string |
Version of the linked service. |
Microsoft Fabric Lakehouse linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Lakehouse |
Type of linked service. |
typeProperties.artifactId |
object |
The ID of Microsoft Fabric Lakehouse artifact. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
string |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string. |
typeProperties.servicePrincipalCredential | SecretBase: |
The credential of the service principal object in Azure Active Directory. If servicePrincipalCredentialType is 'ServicePrincipalKey', servicePrincipalCredential can be SecureString or AzureKeyVaultSecretReference. If servicePrincipalCredentialType is 'ServicePrincipalCert', servicePrincipalCredential can only be AzureKeyVaultSecretReference. |
typeProperties.servicePrincipalCredentialType |
object |
The service principal credential type to use in Server-To-Server authentication. 'ServicePrincipalKey' for key/secret, 'ServicePrincipalCert' for certificate. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
The ID of the application used to authenticate against Microsoft Fabric Lakehouse. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
The Key of the application used to authenticate against Microsoft Fabric Lakehouse. |
typeProperties.tenant |
object |
The name or ID of the tenant to which the service principal belongs. Type: string (or Expression with resultType string). |
typeProperties.workspaceId |
object |
The ID of Microsoft Fabric workspace. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
A list of linked service resources.
Name | Type | Description |
---|---|---|
nextLink |
string |
The link to the next page of results, if any remaining results exist. |
value |
List of linked services. |
Linked service reference type.
Name | Type | Description |
---|---|---|
parameters |
object |
Arguments for LinkedService. |
referenceName |
string |
Reference LinkedService name. |
type |
Linked service reference type. |
Linked service resource type.
Magento server linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Magento |
Type of linked service. |
typeProperties.accessToken | SecretBase: |
The access token from Magento. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
The URL of the Magento instance. (i.e. 192.168.222.110/magento3) |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. |
typeProperties.useHostVerification |
object |
Specifies whether to require the host name in the server's certificate to match the host name of the server when connecting over SSL. The default value is true. |
typeProperties.usePeerVerification |
object |
Specifies whether to verify the identity of the server when connecting over SSL. The default value is true. |
version |
string |
Version of the linked service. |
MariaDB server linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
MariaDB |
Type of linked service. |
typeProperties.connectionString |
object |
An ODBC connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.database |
object |
Database name for connection. Type: string. |
typeProperties.driverVersion |
object |
The version of the MariaDB driver. Type: string. V1 or empty for legacy driver, V2 for new driver. V1 can support connection string and property bag, V2 can only support connection string. The legacy driver is scheduled for deprecation by October 2024. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password |
The Azure key vault secret reference of password in connection string. |
|
typeProperties.port |
object |
The port for the connection. Type: integer. |
typeProperties.server |
object |
Server name for connection. Type: string. |
typeProperties.sslMode |
object |
This option specifies whether the driver uses TLS encryption and verification when connecting to MariaDB. E.g., SSLMode=<0/1/2/3/4>. Options: DISABLED (0) / PREFERRED (1) (Default) / REQUIRED (2) / VERIFY_CA (3) / VERIFY_IDENTITY (4), REQUIRED (2) is recommended to only allow connections encrypted with SSL/TLS. |
typeProperties.useSystemTrustStore |
object |
This option specifies whether to use a CA certificate from the system trust store, or from a specified PEM file. E.g. UseSystemTrustStore=<0/1>; Options: Enabled (1) / Disabled (0) (Default) |
typeProperties.username |
object |
Username for authentication. Type: string. |
version |
string |
Version of the linked service. |
Marketo server linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Marketo |
Type of linked service. |
typeProperties.clientId |
object |
The client Id of your Marketo service. |
typeProperties.clientSecret | SecretBase: |
The client secret of your Marketo service. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.endpoint |
object |
The endpoint of the Marketo server. (i.e. 123-ABC-321.mktorest.com) |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. |
typeProperties.useHostVerification |
object |
Specifies whether to require the host name in the server's certificate to match the host name of the server when connecting over SSL. The default value is true. |
typeProperties.usePeerVerification |
object |
Specifies whether to verify the identity of the server when connecting over SSL. The default value is true. |
version |
string |
Version of the linked service. |
Microsoft Access linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Microsoft |
Type of linked service. |
typeProperties.authenticationType |
object |
Type of authentication used to connect to the Microsoft Access as ODBC data store. Possible values are: Anonymous and Basic. Type: string (or Expression with resultType string). |
typeProperties.connectionString |
object |
The non-access credential portion of the connection string as well as an optional encrypted credential. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.credential | SecretBase: |
The access credential portion of the connection string specified in driver-specific property-value format. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password for Basic authentication. |
typeProperties.userName |
object |
User name for Basic authentication. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Linked service for MongoDB Atlas data source.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Mongo |
Type of linked service. |
typeProperties.connectionString |
object |
The MongoDB Atlas connection string. Type: string, SecureString or AzureKeyVaultSecretReference. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.database |
object |
The name of the MongoDB Atlas database that you want to access. Type: string (or Expression with resultType string). |
typeProperties.driverVersion |
object |
The driver version that you want to choose. Allowed value are v1 and v2. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
The authentication type to be used to connect to the MongoDB database.
Value | Description |
---|---|
Anonymous | |
Basic |
Linked service for MongoDb data source.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Mongo |
Type of linked service. |
typeProperties.allowSelfSignedServerCert |
object |
Specifies whether to allow self-signed certificates from the server. The default value is false. Type: boolean (or Expression with resultType boolean). |
typeProperties.authSource |
object |
Database to verify the username and password. Type: string (or Expression with resultType string). |
typeProperties.authenticationType |
The authentication type to be used to connect to the MongoDB database. |
|
typeProperties.databaseName |
object |
The name of the MongoDB database that you want to access. Type: string (or Expression with resultType string). |
typeProperties.enableSsl |
object |
Specifies whether the connections to the server are encrypted using SSL. The default value is false. Type: boolean (or Expression with resultType boolean). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password for authentication. |
typeProperties.port |
object |
The TCP port number that the MongoDB server uses to listen for client connections. The default value is 27017. Type: integer (or Expression with resultType integer), minimum: 0. |
typeProperties.server |
object |
The IP address or server name of the MongoDB server. Type: string (or Expression with resultType string). |
typeProperties.username |
object |
Username for authentication. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Linked service for MongoDB data source.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Mongo |
Type of linked service. |
typeProperties.connectionString |
object |
The MongoDB connection string. Type: string, SecureString or AzureKeyVaultSecretReference. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.database |
object |
The name of the MongoDB database that you want to access. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Linked service for MySQL data source.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
My |
Type of linked service. |
typeProperties.allowZeroDateTime |
object |
This allows the special “zero” date value 0000-00-00 to be retrieved from the database. Type: boolean. |
typeProperties.connectionString |
object |
The connection string. |
typeProperties.connectionTimeout |
object |
The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. Type: integer. |
typeProperties.convertZeroDateTime |
object |
True to return DateTime.MinValue for date or datetime columns that have disallowed values. Type: boolean. |
typeProperties.database |
object |
Database name for connection. Type: string. |
typeProperties.driverVersion |
object |
The version of the MySQL driver. Type: string. V1 or empty for legacy driver, V2 for new driver. V1 can support connection string and property bag, V2 can only support connection string. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.guidFormat |
object |
Determines which column type (if any) should be read as a GUID. Type: string. None: No column types are automatically read as a Guid; Char36: All CHAR(36) columns are read/written as a Guid using lowercase hex with hyphens, which matches UUID. |
typeProperties.password |
The Azure key vault secret reference of password in connection string. |
|
typeProperties.port |
object |
The port for the connection. Type: integer. |
typeProperties.server |
object |
Server name for connection. Type: string. |
typeProperties.sslCert |
object |
The path to the client’s SSL certificate file in PEM format. SslKey must also be specified. Type: string. |
typeProperties.sslKey |
object |
The path to the client’s SSL private key in PEM format. SslCert must also be specified. Type: string. |
typeProperties.sslMode |
object |
SSL mode for connection. Type: integer. 0: disable, 1: prefer, 2: require, 3: verify-ca, 4: verify-full. |
typeProperties.treatTinyAsBoolean |
object |
When set to true, TINYINT(1) values are returned as booleans. Type: bool. |
typeProperties.useSystemTrustStore |
object |
Use system trust store for connection. Type: integer. 0: enable, 1: disable. |
typeProperties.username |
object |
Username for authentication. Type: string. |
version |
string |
Version of the linked service. |
Netezza linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Netezza |
Type of linked service. |
typeProperties.connectionString |
object |
An ODBC connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.pwd |
The Azure key vault secret reference of password in connection string. |
|
version |
string |
Version of the linked service. |
Specify the credential type (key or cert) is used for service principal.
Value | Description |
---|---|
ServicePrincipalCert | |
ServicePrincipalKey |
Type of authentication used to connect to the OData service.
Value | Description |
---|---|
AadServicePrincipal | |
Anonymous | |
Basic | |
ManagedServiceIdentity | |
Windows |
Open Data Protocol (OData) linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
OData |
Type of linked service. |
typeProperties.aadResourceId |
object |
Specify the resource you are requesting authorization to use Directory. Type: string (or Expression with resultType string). |
typeProperties.aadServicePrincipalCredentialType |
Specify the credential type (key or cert) is used for service principal. |
|
typeProperties.authenticationType |
Type of authentication used to connect to the OData service. |
|
typeProperties.azureCloudType |
object |
Indicates the azure cloud type of the service principle auth. Allowed values are AzurePublic, AzureChina, AzureUsGovernment, AzureGermany. Default value is the data factory regions’ cloud type. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password of the OData service. |
typeProperties.servicePrincipalEmbeddedCert | SecretBase: |
Specify the base64 encoded certificate of your application registered in Azure Active Directory. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalEmbeddedCertPassword | SecretBase: |
Specify the password of your certificate if your certificate has a password and you are using AadServicePrincipal authentication. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
Specify the application id of your application registered in Azure Active Directory. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
Specify the secret of your application registered in Azure Active Directory. Type: string (or Expression with resultType string). |
typeProperties.tenant |
object |
Specify the tenant information (domain name or tenant ID) under which your application resides. Type: string (or Expression with resultType string). |
typeProperties.url |
object |
The URL of the OData service endpoint. Type: string (or Expression with resultType string). |
typeProperties.userName |
object |
User name of the OData service. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Open Database Connectivity (ODBC) linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Odbc |
Type of linked service. |
typeProperties.authenticationType |
object |
Type of authentication used to connect to the ODBC data store. Possible values are: Anonymous and Basic. Type: string (or Expression with resultType string). |
typeProperties.connectionString |
object |
The non-access credential portion of the connection string as well as an optional encrypted credential. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.credential | SecretBase: |
The access credential portion of the connection string specified in driver-specific property-value format. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password for Basic authentication. |
typeProperties.userName |
object |
User name for Basic authentication. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Office365 linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Office365 |
Type of linked service. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.office365TenantId |
object |
Azure tenant ID to which the Office 365 account belongs. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalCredentialType |
object |
The service principal credential type for authentication.'ServicePrincipalKey' for key/secret, 'ServicePrincipalCert' for certificate. If not specified, 'ServicePrincipalKey' is in use. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalEmbeddedCert | SecretBase: |
Specify the base64 encoded certificate of your application registered in Azure Active Directory. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalEmbeddedCertPassword | SecretBase: |
Specify the password of your certificate if your certificate has a password and you are using AadServicePrincipal authentication. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
Specify the application's client ID. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
Specify the application's key. |
typeProperties.servicePrincipalTenantId |
object |
Specify the tenant information under which your Azure AD web application resides. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Authentication type for connecting to the Oracle database. Only used for Version 2.0.
Value | Description |
---|---|
Basic |
Oracle database. This linked service has supported version property. The Version 1.0 is scheduled for deprecation while your pipeline will continue to run after EOL but without any bug fix or new features.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Oracle |
Type of linked service. |
typeProperties.authenticationType |
Authentication type for connecting to the Oracle database. Only used for Version 2.0. |
|
typeProperties.connectionString |
object |
The connection string. Type: string, SecureString or AzureKeyVaultSecretReference. Only used for Version 1.0. |
typeProperties.cryptoChecksumClient |
object |
Specifies the desired data integrity behavior when this client connects to a server. Supported values are accepted, rejected, requested or required, default value is required. Type: string. Only used for Version 2.0. |
typeProperties.cryptoChecksumTypesClient |
object |
Specifies the crypto-checksum algorithms that client can use. Supported values are SHA1, SHA256, SHA384, SHA512, default value is (SHA512). Type: string. Only used for Version 2.0. |
typeProperties.enableBulkLoad |
object |
Specifies whether to use bulk copy or batch insert when loading data into the database, default value is true. Type: boolean. Only used for Version 2.0. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.encryptionClient |
object |
Specifies the encryption client behavior. Supported values are accepted, rejected, requested or required, default value is required. Type: string. Only used for Version 2.0. |
typeProperties.encryptionTypesClient |
object |
Specifies the encryption algorithms that client can use. Supported values are AES128, AES192, AES256, 3DES112, 3DES168, default value is (AES256). Type: string. Only used for Version 2.0. |
typeProperties.fetchSize |
object |
Specifies the number of bytes that the driver allocates to fetch the data in one database round-trip, default value is 10485760. Type: integer. Only used for Version 2.0. |
typeProperties.fetchTswtzAsTimestamp |
object |
Specifies whether the driver returns column value with the TIMESTAMP WITH TIME ZONE data type as DateTime or string. This setting is ignored if supportV1DataTypes is not true, default value is true. Type: boolean. Only used for Version 2.0. |
typeProperties.initialLobFetchSize |
object |
Specifies the amount that the source initially fetches for LOB columns, default value is 0. Type: integer. Only used for Version 2.0. |
typeProperties.initializationString |
object |
Specifies a command that is issued immediately after connecting to the database to manage session settings. Type: string. Only used for Version 2.0. |
typeProperties.password |
The Azure key vault secret reference of password in connection string. |
|
typeProperties.server |
object |
The location of Oracle database you want to connect to, the supported forms include connector descriptor, Easy Connect (Plus) Naming and Oracle Net Services Name (Only self-hosted IR). Type: string. Only used for Version 2.0. |
typeProperties.statementCacheSize |
object |
Specifies the number of cursors or statements to be cached for each database connection, default value is 0. Type: integer. Only used for Version 2.0. |
typeProperties.supportV1DataTypes |
object |
Specifies whether to use the Version 1.0 data type mappings. Do not set this to true unless you want to keep backward compatibility with Version 1.0's data type mappings, default value is false. Type: boolean. Only used for Version 2.0. |
typeProperties.username |
object |
The Oracle database username. Type: string. Only used for Version 2.0. |
version |
string |
Version of the linked service. |
Oracle Service Cloud linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Oracle |
Type of linked service. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
The URL of the Oracle Service Cloud instance. |
typeProperties.password | SecretBase: |
The password corresponding to the user name that you provided in the username key. |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. Type: boolean (or Expression with resultType boolean). |
typeProperties.useHostVerification |
object |
Specifies whether to require the host name in the server's certificate to match the host name of the server when connecting over SSL. The default value is true. Type: boolean (or Expression with resultType boolean). |
typeProperties.usePeerVerification |
object |
Specifies whether to verify the identity of the server when connecting over SSL. The default value is true. Type: boolean (or Expression with resultType boolean). |
typeProperties.username |
object |
The user name that you use to access Oracle Service Cloud server. |
version |
string |
Version of the linked service. |
Definition of a single parameter for an entity.
Name | Type | Description |
---|---|---|
defaultValue |
object |
Default value of parameter. |
type |
Parameter type. |
Parameter type.
Value | Description |
---|---|
Array | |
Bool | |
Float | |
Int | |
Object | |
SecureString | |
String |
Paypal Service linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Paypal |
Type of linked service. |
typeProperties.clientId |
object |
The client ID associated with your PayPal application. |
typeProperties.clientSecret | SecretBase: |
The client secret associated with your PayPal application. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
The URL of the PayPal instance. (i.e. api.sandbox.paypal.com) |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. |
typeProperties.useHostVerification |
object |
Specifies whether to require the host name in the server's certificate to match the host name of the server when connecting over SSL. The default value is true. |
typeProperties.usePeerVerification |
object |
Specifies whether to verify the identity of the server when connecting over SSL. The default value is true. |
version |
string |
Version of the linked service. |
The authentication mechanism used to connect to the Phoenix server.
Value | Description |
---|---|
Anonymous | |
UsernameAndPassword | |
WindowsAzureHDInsightService |
Phoenix server linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Phoenix |
Type of linked service. |
typeProperties.allowHostNameCNMismatch |
object |
Specifies whether to require a CA-issued SSL certificate name to match the host name of the server when connecting over SSL. The default value is false. |
typeProperties.allowSelfSignedServerCert |
object |
Specifies whether to allow self-signed certificates from the server. The default value is false. |
typeProperties.authenticationType |
The authentication mechanism used to connect to the Phoenix server. |
|
typeProperties.enableSsl |
object |
Specifies whether the connections to the server are encrypted using SSL. The default value is false. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
The IP address or host name of the Phoenix server. (i.e. 192.168.222.160) |
typeProperties.httpPath |
object |
The partial URL corresponding to the Phoenix server. (i.e. /gateway/sandbox/phoenix/version). The default value is hbasephoenix if using WindowsAzureHDInsightService. |
typeProperties.password | SecretBase: |
The password corresponding to the user name. |
typeProperties.port |
object |
The TCP port that the Phoenix server uses to listen for client connections. The default value is 8765. |
typeProperties.trustedCertPath |
object |
The full path of the .pem file containing trusted CA certificates for verifying the server when connecting over SSL. This property can only be set when using SSL on self-hosted IR. The default value is the cacerts.pem file installed with the IR. |
typeProperties.useSystemTrustStore |
object |
Specifies whether to use a CA certificate from the system trust store or from a specified PEM file. The default value is false. |
typeProperties.username |
object |
The user name used to connect to the Phoenix server. |
version |
string |
Version of the linked service. |
Linked service for PostgreSQL data source.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Postgre |
Type of linked service. |
typeProperties.connectionString |
object |
The connection string. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password |
The Azure key vault secret reference of password in connection string. |
|
version |
string |
Version of the linked service. |
Linked service for PostgreSQLV2 data source.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Postgre |
Type of linked service. |
typeProperties.authenticationType |
object |
The authentication type to use. Type: string. |
typeProperties.commandTimeout |
object |
The time to wait (in seconds) while trying to execute a command before terminating the attempt and generating an error. Set to zero for infinity. Type: integer. |
typeProperties.connectionTimeout |
object |
The time to wait (in seconds) while trying to establish a connection before terminating the attempt and generating an error. Type: integer. |
typeProperties.database |
object |
Database name for connection. Type: string. |
typeProperties.encoding |
object |
Gets or sets the .NET encoding that will be used to encode/decode PostgreSQL string data. Type: string |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.logParameters |
object |
When enabled, parameter values are logged when commands are executed. Type: boolean. |
typeProperties.password |
The Azure key vault secret reference of password in connection string. Type: string. |
|
typeProperties.pooling |
object |
Whether connection pooling should be used. Type: boolean. |
typeProperties.port |
object |
The port for the connection. Type: integer. |
typeProperties.readBufferSize |
object |
Determines the size of the internal buffer uses when reading. Increasing may improve performance if transferring large values from the database. Type: integer. |
typeProperties.schema |
object |
Sets the schema search path. Type: string. |
typeProperties.server |
object |
Server name for connection. Type: string. |
typeProperties.sslCertificate |
object |
Location of a client certificate to be sent to the server. Type: string. |
typeProperties.sslKey |
object |
Location of a client key for a client certificate to be sent to the server. Type: string. |
typeProperties.sslMode |
object |
SSL mode for connection. Type: integer. 0: disable, 1:allow, 2: prefer, 3: require, 4: verify-ca, 5: verify-full. Type: integer. |
typeProperties.sslPassword |
object |
Password for a key for a client certificate. Type: string. |
typeProperties.timezone |
object |
Gets or sets the session timezone. Type: string. |
typeProperties.trustServerCertificate |
object |
Whether to trust the server certificate without validating it. Type: boolean. |
typeProperties.username |
object |
Username for authentication. Type: string. |
version |
string |
Version of the linked service. |
Power BI Workspace linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Power |
Type of linked service. |
typeProperties.tenantId |
string |
The tenant id to which the Power BI workspace belongs. |
typeProperties.workspaceId |
string |
The Power BI workspace id. |
version |
string |
Version of the linked service. |
The authentication mechanism used to connect to the Presto server.
Value | Description |
---|---|
Anonymous | |
LDAP |
Presto server linked service. This linked service has supported version property. The Version 1.0 is scheduled for deprecation while your pipeline will continue to run after EOL but without any bug fix or new features.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Presto |
Type of linked service. |
typeProperties.allowHostNameCNMismatch |
object |
Specifies whether to require a CA-issued SSL certificate name to match the host name of the server when connecting over SSL. The default value is false. Only used for Version 1.0. |
typeProperties.allowSelfSignedServerCert |
object |
Specifies whether to allow self-signed certificates from the server. The default value is false. Only used for Version 1.0. |
typeProperties.authenticationType |
The authentication mechanism used to connect to the Presto server. |
|
typeProperties.catalog |
object |
The catalog context for all request against the server. |
typeProperties.enableServerCertificateValidation |
object |
Specifies whether the connections to the server will validate server certificate, the default value is True. Only used for Version 2.0 |
typeProperties.enableSsl |
object |
Specifies whether the connections to the server are encrypted using SSL. The default value for legacy version is False. The default value for version 2.0 is True. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
The IP address or host name of the Presto server. (i.e. 192.168.222.160) |
typeProperties.password | SecretBase: |
The password corresponding to the user name. |
typeProperties.port |
object |
The TCP port that the Presto server uses to listen for client connections. The default value is 8080 when disable SSL, default value is 443 when enable SSL. |
typeProperties.serverVersion |
object |
The version of the Presto server. (i.e. 0.148-t) Only used for Version 1.0. |
typeProperties.timeZoneID |
object |
The local time zone used by the connection. Valid values for this option are specified in the IANA Time Zone Database. The default value for Version 1.0 is the client system time zone. The default value for Version 2.0 is server system timeZone |
typeProperties.trustedCertPath |
object |
The full path of the .pem file containing trusted CA certificates for verifying the server when connecting over SSL. This property can only be set when using SSL on self-hosted IR. The default value is the cacerts.pem file installed with the IR. Only used for Version 1.0. |
typeProperties.useSystemTrustStore |
object |
Specifies whether to use a CA certificate from the system trust store or from a specified PEM file. The default value is false. Only used for Version 1.0. |
typeProperties.username |
object |
The user name used to connect to the Presto server. |
version |
string |
Version of the linked service. |
Linked service for Quickbase.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Quickbase |
Type of linked service. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.url |
object |
The url to connect Quickbase source. Type: string (or Expression with resultType string). |
typeProperties.userToken | SecretBase: |
The user token for the Quickbase source. |
version |
string |
Version of the linked service. |
QuickBooks server linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Quick |
Type of linked service. |
typeProperties.accessToken | SecretBase: |
The access token for OAuth 1.0 authentication. |
typeProperties.accessTokenSecret | SecretBase: |
The access token secret for OAuth 1.0 authentication. |
typeProperties.companyId |
object |
The company ID of the QuickBooks company to authorize. |
typeProperties.connectionProperties |
object |
Properties used to connect to QuickBooks. It is mutually exclusive with any other properties in the linked service. Type: object. |
typeProperties.consumerKey |
object |
The consumer key for OAuth 1.0 authentication. |
typeProperties.consumerSecret | SecretBase: |
The consumer secret for OAuth 1.0 authentication. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.endpoint |
object |
The endpoint of the QuickBooks server. (i.e. quickbooks.api.intuit.com) |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. |
version |
string |
Version of the linked service. |
Responsys linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Responsys |
Type of linked service. |
typeProperties.clientId |
object |
The client ID associated with the Responsys application. Type: string (or Expression with resultType string). |
typeProperties.clientSecret | SecretBase: |
The client secret associated with the Responsys application. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.endpoint |
object |
The endpoint of the Responsys server. |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. Type: boolean (or Expression with resultType boolean). |
typeProperties.useHostVerification |
object |
Specifies whether to require the host name in the server's certificate to match the host name of the server when connecting over SSL. The default value is true. Type: boolean (or Expression with resultType boolean). |
typeProperties.usePeerVerification |
object |
Specifies whether to verify the identity of the server when connecting over SSL. The default value is true. Type: boolean (or Expression with resultType boolean). |
version |
string |
Version of the linked service. |
Type of authentication used to connect to the REST service.
Value | Description |
---|---|
AadServicePrincipal | |
Anonymous | |
Basic | |
ManagedServiceIdentity | |
OAuth2ClientCredential |
Rest Service linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Rest |
Type of linked service. |
typeProperties.aadResourceId |
object |
The resource you are requesting authorization to use. |
typeProperties.authHeaders |
object |
The additional HTTP headers in the request to RESTful API used for authorization. Type: object (or Expression with resultType object). |
typeProperties.authenticationType |
Type of authentication used to connect to the REST service. |
|
typeProperties.azureCloudType |
object |
Indicates the azure cloud type of the service principle auth. Allowed values are AzurePublic, AzureChina, AzureUsGovernment, AzureGermany. Default value is the data factory regions’ cloud type. Type: string (or Expression with resultType string). |
typeProperties.clientId |
object |
The client ID associated with your application. Type: string (or Expression with resultType string). |
typeProperties.clientSecret | SecretBase: |
The client secret associated with your application. |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.enableServerCertificateValidation |
object |
Whether to validate server side SSL certificate when connecting to the endpoint.The default value is true. Type: boolean (or Expression with resultType boolean). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
The password used in Basic authentication type. |
typeProperties.resource |
object |
The target service or resource to which the access will be requested. Type: string (or Expression with resultType string). |
typeProperties.scope |
object |
The scope of the access required. It describes what kind of access will be requested. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalCredentialType |
object |
The service principal credential type to use in Server-To-Server authentication. 'ServicePrincipalKey' for key/secret, 'ServicePrincipalCert' for certificate. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalEmbeddedCert | SecretBase: |
Specify the base64 encoded certificate of your application registered in Azure Active Directory. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalEmbeddedCertPassword | SecretBase: |
Specify the password of your certificate if your certificate has a password and you are using AadServicePrincipal authentication. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
The application's client ID used in AadServicePrincipal authentication type. |
typeProperties.servicePrincipalKey | SecretBase: |
The application's key used in AadServicePrincipal authentication type. |
typeProperties.tenant |
object |
The tenant information (domain name or tenant ID) used in AadServicePrincipal authentication type under which your application resides. |
typeProperties.tokenEndpoint |
object |
The token endpoint of the authorization server to acquire access token. Type: string (or Expression with resultType string). |
typeProperties.url |
object |
The base URL of the REST service. |
typeProperties.userName |
object |
The user name used in Basic authentication type. |
version |
string |
Version of the linked service. |
Linked service for Salesforce.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Salesforce |
Type of linked service. |
typeProperties.apiVersion |
object |
The Salesforce API version used in ADF. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.environmentUrl |
object |
The URL of Salesforce instance. Default is 'https://login.salesforce.com'. To copy data from sandbox, specify 'https://test.salesforce.com'. To copy data from custom domain, specify, for example, 'https://[domain].my.salesforce.com'. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
The password for Basic authentication of the Salesforce instance. |
typeProperties.securityToken | SecretBase: |
The security token is optional to remotely access Salesforce instance. |
typeProperties.username |
object |
The username for Basic authentication of the Salesforce instance. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Salesforce Marketing Cloud linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Salesforce |
Type of linked service. |
typeProperties.clientId |
object |
The client ID associated with the Salesforce Marketing Cloud application. Type: string (or Expression with resultType string). |
typeProperties.clientSecret | SecretBase: |
The client secret associated with the Salesforce Marketing Cloud application. Type: string (or Expression with resultType string). |
typeProperties.connectionProperties |
object |
Properties used to connect to Salesforce Marketing Cloud. It is mutually exclusive with any other properties in the linked service. Type: object. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. Type: boolean (or Expression with resultType boolean). |
typeProperties.useHostVerification |
object |
Specifies whether to require the host name in the server's certificate to match the host name of the server when connecting over SSL. The default value is true. Type: boolean (or Expression with resultType boolean). |
typeProperties.usePeerVerification |
object |
Specifies whether to verify the identity of the server when connecting over SSL. The default value is true. Type: boolean (or Expression with resultType boolean). |
version |
string |
Version of the linked service. |
Linked service for Salesforce Service Cloud.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Salesforce |
Type of linked service. |
typeProperties.apiVersion |
object |
The Salesforce API version used in ADF. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.environmentUrl |
object |
The URL of Salesforce Service Cloud instance. Default is 'https://login.salesforce.com'. To copy data from sandbox, specify 'https://test.salesforce.com'. To copy data from custom domain, specify, for example, 'https://[domain].my.salesforce.com'. Type: string (or Expression with resultType string). |
typeProperties.extendedProperties |
object |
Extended properties appended to the connection string. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
The password for Basic authentication of the Salesforce instance. |
typeProperties.securityToken | SecretBase: |
The security token is optional to remotely access Salesforce instance. |
typeProperties.username |
object |
The username for Basic authentication of the Salesforce instance. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Linked service for Salesforce Service Cloud V2.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Salesforce |
Type of linked service. |
typeProperties.apiVersion |
object |
The Salesforce API version used in ADF. The version must be larger than or equal to 47.0 which is required by Salesforce BULK API 2.0. Type: string (or Expression with resultType string). |
typeProperties.authenticationType |
object |
The authentication type to be used to connect to the Salesforce. Currently, we only support OAuth2ClientCredentials, it is also the default value |
typeProperties.clientId |
object |
The client Id for OAuth 2.0 Client Credentials Flow authentication of the Salesforce instance. Type: string (or Expression with resultType string). |
typeProperties.clientSecret | SecretBase: |
The client secret for OAuth 2.0 Client Credentials Flow authentication of the Salesforce instance. |
typeProperties.encryptedCredential |
string |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string. |
typeProperties.environmentUrl |
object |
The URL of Salesforce Service Cloud instance. For example, 'https://[domain].my.salesforce.com'. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Linked service for Salesforce V2.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
SalesforceV2 |
Type of linked service. |
typeProperties.apiVersion |
object |
The Salesforce API version used in ADF. The version must be larger than or equal to 47.0 which is required by Salesforce BULK API 2.0. Type: string (or Expression with resultType string). |
typeProperties.authenticationType |
object |
The authentication type to be used to connect to the Salesforce. Currently, we only support OAuth2ClientCredentials, it is also the default value |
typeProperties.clientId |
object |
The client Id for OAuth 2.0 Client Credentials Flow authentication of the Salesforce instance. Type: string (or Expression with resultType string). |
typeProperties.clientSecret | SecretBase: |
The client secret for OAuth 2.0 Client Credentials Flow authentication of the Salesforce instance. |
typeProperties.encryptedCredential |
string |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string. |
typeProperties.environmentUrl |
object |
The URL of Salesforce instance. For example, 'https://[domain].my.salesforce.com'. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
SAP Business Warehouse Linked Service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
SapBW |
Type of linked service. |
typeProperties.clientId |
object |
Client ID of the client on the BW system. (Usually a three-digit decimal number represented as a string) Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password to access the SAP BW server. |
typeProperties.server |
object |
Host name of the SAP BW instance. Type: string (or Expression with resultType string). |
typeProperties.systemNumber |
object |
System number of the BW system. (Usually a two-digit decimal number represented as a string.) Type: string (or Expression with resultType string). |
typeProperties.userName |
object |
Username to access the SAP BW server. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Linked service for SAP Cloud for Customer.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Sap |
Type of linked service. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Either encryptedCredential or username/password must be provided. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
The password for Basic authentication. |
typeProperties.url |
object |
The URL of SAP Cloud for Customer OData API. For example, '[https://[tenantname].crm.ondemand.com/sap/c4c/odata/v1]'. Type: string (or Expression with resultType string). |
typeProperties.username |
object |
The username for Basic authentication. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Linked service for SAP ERP Central Component(SAP ECC).
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Sap |
Type of linked service. |
typeProperties.encryptedCredential |
string |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Either encryptedCredential or username/password must be provided. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
The password for Basic authentication. |
typeProperties.url |
string |
The URL of SAP ECC OData API. For example, '[https://hostname:port/sap/opu/odata/sap/servicename/]'. Type: string (or Expression with resultType string). |
typeProperties.username |
string |
The username for Basic authentication. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
The authentication type to be used to connect to the SAP HANA server.
Value | Description |
---|---|
Basic | |
Windows |
SAP HANA Linked Service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Sap |
Type of linked service. |
typeProperties.authenticationType |
The authentication type to be used to connect to the SAP HANA server. |
|
typeProperties.connectionString |
object |
SAP HANA ODBC connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password to access the SAP HANA server. |
typeProperties.server |
object |
Host name of the SAP HANA server. Type: string (or Expression with resultType string). |
typeProperties.userName |
object |
Username to access the SAP HANA server. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
SAP ODP Linked Service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Sap |
Type of linked service. |
typeProperties.clientId |
object |
Client ID of the client on the SAP system where the table is located. (Usually a three-digit decimal number represented as a string) Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.language |
object |
Language of the SAP system where the table is located. The default value is EN. Type: string (or Expression with resultType string). |
typeProperties.logonGroup |
object |
The Logon Group for the SAP System. Type: string (or Expression with resultType string). |
typeProperties.messageServer |
object |
The hostname of the SAP Message Server. Type: string (or Expression with resultType string). |
typeProperties.messageServerService |
object |
The service name or port number of the Message Server. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password to access the SAP server where the table is located. |
typeProperties.server |
object |
Host name of the SAP instance where the table is located. Type: string (or Expression with resultType string). |
typeProperties.sncLibraryPath |
object |
External security product's library to access the SAP server where the table is located. Type: string (or Expression with resultType string). |
typeProperties.sncMode |
object |
SNC activation flag (Boolean) to access the SAP server where the table is located. Type: boolean (or Expression with resultType boolean). |
typeProperties.sncMyName |
object |
Initiator's SNC name to access the SAP server where the table is located. Type: string (or Expression with resultType string). |
typeProperties.sncPartnerName |
object |
Communication partner's SNC name to access the SAP server where the table is located. Type: string (or Expression with resultType string). |
typeProperties.sncQop |
object |
SNC Quality of Protection. Allowed value include: 1, 2, 3, 8, 9. Type: string (or Expression with resultType string). |
typeProperties.subscriberName |
object |
The subscriber name. Type: string (or Expression with resultType string). |
typeProperties.systemId |
object |
SystemID of the SAP system where the table is located. Type: string (or Expression with resultType string). |
typeProperties.systemNumber |
object |
System number of the SAP system where the table is located. (Usually a two-digit decimal number represented as a string.) Type: string (or Expression with resultType string). |
typeProperties.userName |
object |
Username to access the SAP server where the table is located. Type: string (or Expression with resultType string). |
typeProperties.x509CertificatePath |
object |
SNC X509 certificate file path. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
SAP Business Warehouse Open Hub Destination Linked Service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Sap |
Type of linked service. |
typeProperties.clientId |
object |
Client ID of the client on the BW system where the open hub destination is located. (Usually a three-digit decimal number represented as a string) Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.language |
object |
Language of the BW system where the open hub destination is located. The default value is EN. Type: string (or Expression with resultType string). |
typeProperties.logonGroup |
object |
The Logon Group for the SAP System. Type: string (or Expression with resultType string). |
typeProperties.messageServer |
object |
The hostname of the SAP Message Server. Type: string (or Expression with resultType string). |
typeProperties.messageServerService |
object |
The service name or port number of the Message Server. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password to access the SAP BW server where the open hub destination is located. |
typeProperties.server |
object |
Host name of the SAP BW instance where the open hub destination is located. Type: string (or Expression with resultType string). |
typeProperties.systemId |
object |
SystemID of the SAP system where the table is located. Type: string (or Expression with resultType string). |
typeProperties.systemNumber |
object |
System number of the BW system where the open hub destination is located. (Usually a two-digit decimal number represented as a string.) Type: string (or Expression with resultType string). |
typeProperties.userName |
object |
Username to access the SAP BW server where the open hub destination is located. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
SAP Table Linked Service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Sap |
Type of linked service. |
typeProperties.clientId |
object |
Client ID of the client on the SAP system where the table is located. (Usually a three-digit decimal number represented as a string) Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.language |
object |
Language of the SAP system where the table is located. The default value is EN. Type: string (or Expression with resultType string). |
typeProperties.logonGroup |
object |
The Logon Group for the SAP System. Type: string (or Expression with resultType string). |
typeProperties.messageServer |
object |
The hostname of the SAP Message Server. Type: string (or Expression with resultType string). |
typeProperties.messageServerService |
object |
The service name or port number of the Message Server. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password to access the SAP server where the table is located. |
typeProperties.server |
object |
Host name of the SAP instance where the table is located. Type: string (or Expression with resultType string). |
typeProperties.sncLibraryPath |
object |
External security product's library to access the SAP server where the table is located. Type: string (or Expression with resultType string). |
typeProperties.sncMode |
object |
SNC activation flag (Boolean) to access the SAP server where the table is located. Type: boolean (or Expression with resultType boolean). |
typeProperties.sncMyName |
object |
Initiator's SNC name to access the SAP server where the table is located. Type: string (or Expression with resultType string). |
typeProperties.sncPartnerName |
object |
Communication partner's SNC name to access the SAP server where the table is located. Type: string (or Expression with resultType string). |
typeProperties.sncQop |
object |
SNC Quality of Protection. Allowed value include: 1, 2, 3, 8, 9. Type: string (or Expression with resultType string). |
typeProperties.systemId |
object |
SystemID of the SAP system where the table is located. Type: string (or Expression with resultType string). |
typeProperties.systemNumber |
object |
System number of the SAP system where the table is located. (Usually a two-digit decimal number represented as a string.) Type: string (or Expression with resultType string). |
typeProperties.userName |
object |
Username to access the SAP server where the table is located. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Custom script action to run on HDI ondemand cluster once it's up.
Name | Type | Description |
---|---|---|
name |
string |
The user provided name of the script action. |
parameters |
string |
The parameters for the script action. |
roles |
object |
The node types on which the script action should be executed. |
uri |
string |
The URI for the script action. |
Azure Synapse secure string definition. The string value will be masked with asterisks '*' during Get or List API calls.
Name | Type | Description |
---|---|---|
type | string: |
Type of the secret. |
value |
string |
Value of secure string. |
The authentication type to use.
Value | Description |
---|---|
Basic | |
OAuth2 |
ServiceNow server linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Service |
Type of linked service. |
typeProperties.authenticationType |
The authentication type to use. |
|
typeProperties.clientId |
object |
The client id for OAuth2 authentication. |
typeProperties.clientSecret | SecretBase: |
The client secret for OAuth2 authentication. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.endpoint |
object |
The endpoint of the ServiceNow server. (i.e. .service-now.com) |
typeProperties.password | SecretBase: |
The password corresponding to the user name for Basic and OAuth2 authentication. |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. |
typeProperties.useHostVerification |
object |
Specifies whether to require the host name in the server's certificate to match the host name of the server when connecting over SSL. The default value is true. |
typeProperties.usePeerVerification |
object |
Specifies whether to verify the identity of the server when connecting over SSL. The default value is true. |
typeProperties.username |
object |
The user name used to connect to the ServiceNow server for Basic and OAuth2 authentication. |
version |
string |
Version of the linked service. |
The authentication type to be used to connect to the FTP server.
Value | Description |
---|---|
Basic | |
SshPublicKey |
A linked service for an SSH File Transfer Protocol (SFTP) server.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Sftp |
Type of linked service. |
typeProperties.authenticationType |
The authentication type to be used to connect to the FTP server. |
|
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
The SFTP server host name. Type: string (or Expression with resultType string). |
typeProperties.hostKeyFingerprint |
object |
The host key finger-print of the SFTP server. When SkipHostKeyValidation is false, HostKeyFingerprint should be specified. Type: string (or Expression with resultType string). |
typeProperties.passPhrase | SecretBase: |
The password to decrypt the SSH private key if the SSH private key is encrypted. |
typeProperties.password | SecretBase: |
Password to logon the SFTP server for Basic authentication. |
typeProperties.port |
object |
The TCP port number that the SFTP server uses to listen for client connections. Default value is 22. Type: integer (or Expression with resultType integer), minimum: 0. |
typeProperties.privateKeyContent | SecretBase: |
Base64 encoded SSH private key content for SshPublicKey authentication. For on-premises copy with SshPublicKey authentication, either PrivateKeyPath or PrivateKeyContent should be specified. SSH private key should be OpenSSH format. |
typeProperties.privateKeyPath |
object |
The SSH private key file path for SshPublicKey authentication. Only valid for on-premises copy. For on-premises copy with SshPublicKey authentication, either PrivateKeyPath or PrivateKeyContent should be specified. SSH private key should be OpenSSH format. Type: string (or Expression with resultType string). |
typeProperties.skipHostKeyValidation |
object |
If true, skip the SSH host key validation. Default value is false. Type: boolean (or Expression with resultType boolean). |
typeProperties.userName |
object |
The username used to log on to the SFTP server. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
SharePoint Online List linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Share |
Type of linked service. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalCredentialType |
object |
The service principal credential type to use in Server-To-Server authentication. 'ServicePrincipalKey' for key/secret, 'ServicePrincipalCert' for certificate. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalEmbeddedCert | SecretBase: |
Specify the base64 encoded certificate of your application registered in Azure Active Directory. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalEmbeddedCertPassword | SecretBase: |
Specify the password of your certificate if your certificate has a password and you are using AadServicePrincipal authentication. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
The application (client) ID of your application registered in Azure Active Directory. Make sure to grant SharePoint site permission to this application. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
The client secret of your application registered in Azure Active Directory. Type: string (or Expression with resultType string). |
typeProperties.siteUrl |
object |
The URL of the SharePoint Online site. For example, https://contoso.sharepoint.com/sites/siteName. Type: string (or Expression with resultType string). |
typeProperties.tenantId |
object |
The tenant ID under which your application resides. You can find it from Azure portal Active Directory overview page. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Shopify Service linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Shopify |
Type of linked service. |
typeProperties.accessToken | SecretBase: |
The API access token that can be used to access Shopify’s data. The token won't expire if it is offline mode. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
The endpoint of the Shopify server. (i.e. mystore.myshopify.com) |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. |
typeProperties.useHostVerification |
object |
Specifies whether to require the host name in the server's certificate to match the host name of the server when connecting over SSL. The default value is true. |
typeProperties.usePeerVerification |
object |
Specifies whether to verify the identity of the server when connecting over SSL. The default value is true. |
version |
string |
Version of the linked service. |
Linked service for Smartsheet.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Smartsheet |
Type of linked service. |
typeProperties.apiToken | SecretBase: |
The api token for the Smartsheet source. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
The type used for authentication. Type: string.
Value | Description |
---|---|
AADServicePrincipal | |
Basic | |
KeyPair |
Snowflake linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Snowflake |
Type of linked service. |
typeProperties.connectionString |
object |
The connection string of snowflake. Type: string, SecureString. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password |
The Azure key vault secret reference of password in connection string. |
|
version |
string |
Version of the linked service. |
Snowflake linked service.
Name | Type | Default value | Description |
---|---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
|
connectVia |
The integration runtime reference. |
||
description |
string |
Linked service description. |
|
parameters |
<string,
Parameter |
Parameters for linked service. |
|
type |
string:
SnowflakeV2 |
Type of linked service. |
|
typeProperties.accountIdentifier |
object |
The account identifier of your Snowflake account, e.g. xy12345.east-us-2.azure |
|
typeProperties.authenticationType | Basic |
The type used for authentication. Type: string. |
|
typeProperties.clientId |
object |
The client ID of the application registered in Azure Active Directory for AADServicePrincipal authentication. |
|
typeProperties.clientSecret | SecretBase: |
The Azure key vault secret reference of client secret for AADServicePrincipal authentication. |
|
typeProperties.database |
object |
The name of the Snowflake database. |
|
typeProperties.encryptedCredential |
string |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string. |
|
typeProperties.host |
object |
The host name of the Snowflake account. Type: string (or Expression with resultType string). |
|
typeProperties.password | SecretBase: |
The Azure key vault secret reference of password in connection string. |
|
typeProperties.privateKey | SecretBase: |
The Azure key vault secret reference of privateKey for KeyPair auth. |
|
typeProperties.privateKeyPassphrase | SecretBase: |
The Azure key vault secret reference of private key password for KeyPair auth with encrypted private key. |
|
typeProperties.role |
object |
The default access control role to use in the Snowflake session. Type: string (or Expression with resultType string). |
|
typeProperties.schema |
object |
Schema name for connection. Type: string (or Expression with resultType string). |
|
typeProperties.scope |
object |
The scope of the application registered in Azure Active Directory for AADServicePrincipal authentication. |
|
typeProperties.tenantId |
object |
The tenant ID of the application registered in Azure Active Directory for AADServicePrincipal authentication. |
|
typeProperties.user |
object |
The name of the Snowflake user. |
|
typeProperties.warehouse |
object |
The name of the Snowflake warehouse. |
|
version |
string |
Version of the linked service. |
The authentication method used to access the Spark server.
Value | Description |
---|---|
Anonymous | |
Username | |
UsernameAndPassword | |
WindowsAzureHDInsightService |
Spark Server linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Spark |
Type of linked service. |
typeProperties.allowHostNameCNMismatch |
object |
Specifies whether to require a CA-issued SSL certificate name to match the host name of the server when connecting over SSL. The default value is false. |
typeProperties.allowSelfSignedServerCert |
object |
Specifies whether to allow self-signed certificates from the server. The default value is false. |
typeProperties.authenticationType |
The authentication method used to access the Spark server. |
|
typeProperties.enableSsl |
object |
Specifies whether the connections to the server are encrypted using SSL. The default value is false. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
IP address or host name of the Spark server |
typeProperties.httpPath |
object |
The partial URL corresponding to the Spark server. |
typeProperties.password | SecretBase: |
The password corresponding to the user name that you provided in the Username field |
typeProperties.port |
object |
The TCP port that the Spark server uses to listen for client connections. |
typeProperties.serverType |
The type of Spark server. |
|
typeProperties.thriftTransportProtocol |
The transport protocol to use in the Thrift layer. |
|
typeProperties.trustedCertPath |
object |
The full path of the .pem file containing trusted CA certificates for verifying the server when connecting over SSL. This property can only be set when using SSL on self-hosted IR. The default value is the cacerts.pem file installed with the IR. |
typeProperties.useSystemTrustStore |
object |
Specifies whether to use a CA certificate from the system trust store or from a specified PEM file. The default value is false. |
typeProperties.username |
object |
The user name that you use to access Spark Server. |
version |
string |
Version of the linked service. |
The type of Spark server.
Value | Description |
---|---|
SharkServer | |
SharkServer2 | |
SparkThriftServer |
The transport protocol to use in the Thrift layer.
Value | Description |
---|---|
Binary | |
HTTP | |
SASL |
Sql always encrypted AKV authentication type. Type: string.
Value | Description |
---|---|
ManagedIdentity | |
ServicePrincipal | |
UserAssignedManagedIdentity |
Sql always encrypted properties.
Name | Type | Description |
---|---|---|
alwaysEncryptedAkvAuthType |
Sql always encrypted AKV authentication type. Type: string. |
|
credential |
The credential reference containing authentication information. |
|
servicePrincipalId |
object |
The client ID of the application in Azure Active Directory used for Azure Key Vault authentication. Type: string (or Expression with resultType string). |
servicePrincipalKey | SecretBase: |
The key of the service principal used to authenticate against Azure Key Vault. |
The type used for authentication. Type: string.
Value | Description |
---|---|
SQL | |
UserAssignedManagedIdentity | |
Windows |
SQL Server linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Sql |
Type of linked service. |
typeProperties.alwaysEncryptedSettings |
Sql always encrypted properties. |
|
typeProperties.applicationIntent |
object |
The application workload type when connecting to a server, used by recommended version. Possible values are ReadOnly and ReadWrite. Type: string (or Expression with resultType string). |
typeProperties.authenticationType |
The type used for authentication. Type: string. |
|
typeProperties.commandTimeout |
object |
The default wait time (in seconds) before terminating the attempt to execute a command and generating an error, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.connectRetryCount |
object |
The number of re-connections attempted after identifying that there was an idle connection failure, used by recommended version. This must be an integer between 0 and 255. Type: integer (or Expression with resultType integer). |
typeProperties.connectRetryInterval |
object |
The amount of time (in seconds) between each re-connection attempt after identifying that there was an idle connection failure, used by recommended version. This must be an integer between 1 and 60. Type: integer (or Expression with resultType integer). |
typeProperties.connectTimeout |
object |
The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.connectionString |
object |
The connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.credential |
The credential reference containing authentication information. |
|
typeProperties.database |
object |
The name of the database, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.encrypt |
object |
Indicate whether TLS encryption is required for all data sent between the client and server, used by recommended version. Possible values are true/yes/mandatory, false/no/optional and strict. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.failoverPartner |
object |
The name or address of the partner server to connect to if the primary server is down, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.hostNameInCertificate |
object |
The host name to use when validating the server certificate for the connection. When not specified, the server name from the Data Source is used for certificate validation, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.integratedSecurity |
object |
Indicate whether User ID and Password are specified in the connection (when false) or whether the current Windows account credentials are used for authentication (when true), used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.loadBalanceTimeout |
object |
The minimum time, in seconds, for the connection to live in the connection pool before being destroyed, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.maxPoolSize |
object |
The maximum number of connections allowed in the connection pool for this specific connection string, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.minPoolSize |
object |
The minimum number of connections allowed in the connection pool for this specific connection string, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.multiSubnetFailover |
object |
If your application is connecting to an AlwaysOn availability group (AG) on different subnets, setting MultiSubnetFailover=true provides faster detection of and connection to the (currently) active server, used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.multipleActiveResultSets |
object |
When true, an application can maintain multiple active result sets (MARS). When false, an application must process or cancel all result sets from one batch before it can execute any other batch on that connection. Type: Boolean (or Expression with resultType boolean). |
typeProperties.packetSize |
object |
The size in bytes of the network packets used to communicate with an instance of server, used by recommended version. Type: integer (or Expression with resultType integer). |
typeProperties.password | SecretBase: |
The on-premises Windows authentication password. |
typeProperties.pooling |
object |
Indicate whether the connection will be pooled or explicitly opened every time that the connection is requested, used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.server |
object |
The name or network address of the instance of SQL Server to which to connect, used by recommended version. Type: string (or Expression with resultType string). |
typeProperties.trustServerCertificate |
object |
Indicate whether the channel will be encrypted while bypassing walking the certificate chain to validate trust, used by recommended version. Type: Boolean (or Expression with resultType boolean). |
typeProperties.userName |
object |
The on-premises Windows authentication user name. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Square Service linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Square |
Type of linked service. |
typeProperties.clientId |
object |
The client ID associated with your Square application. |
typeProperties.clientSecret | SecretBase: |
The client secret associated with your Square application. |
typeProperties.connectionProperties |
object |
Properties used to connect to Square. It is mutually exclusive with any other properties in the linked service. Type: object. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
The URL of the Square instance. (i.e. mystore.mysquare.com) |
typeProperties.redirectUri |
object |
The redirect URL assigned in the Square application dashboard. (i.e. http://localhost:2500) |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. |
typeProperties.useHostVerification |
object |
Specifies whether to require the host name in the server's certificate to match the host name of the server when connecting over SSL. The default value is true. |
typeProperties.usePeerVerification |
object |
Specifies whether to verify the identity of the server when connecting over SSL. The default value is true. |
version |
string |
Version of the linked service. |
AuthenticationType to be used for connection.
Value | Description |
---|---|
Basic | |
Windows |
Linked service for Sybase data source.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Sybase |
Type of linked service. |
typeProperties.authenticationType |
AuthenticationType to be used for connection. |
|
typeProperties.database |
object |
Database name for connection. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
Password for authentication. |
typeProperties.schema |
object |
Schema name for connection. Type: string (or Expression with resultType string). |
typeProperties.server |
object |
Server name for connection. Type: string (or Expression with resultType string). |
typeProperties.username |
object |
Username for authentication. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
The authentication type to use.
Value | Description |
---|---|
Basic | |
Token |
Linked service for TeamDesk.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Team |
Type of linked service. |
typeProperties.apiToken | SecretBase: |
The api token for the TeamDesk source. |
typeProperties.authenticationType |
The authentication type to use. |
|
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
The password of the TeamDesk source. |
typeProperties.url |
object |
The url to connect TeamDesk source. Type: string (or Expression with resultType string). |
typeProperties.userName |
object |
The username of the TeamDesk source. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
AuthenticationType to be used for connection.
Value | Description |
---|---|
Basic | |
Windows |
Linked service for Teradata data source.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Teradata |
Type of linked service. |
typeProperties.authenticationType |
AuthenticationType to be used for connection. |
|
typeProperties.characterSet |
object |
The character set to use for the connection. Type: string (or Expression with resultType string). Only applied for version 2.0. |
typeProperties.connectionString |
object |
Teradata ODBC connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.httpsPortNumber |
object |
The port numbers when connecting to server through HTTPS/TLS connections. Type: integer (or Expression with resultType integer). Only applied for version 2.0. |
typeProperties.maxRespSize |
object |
The maximum size of the response buffer for SQL requests, in bytes. Type: integer. Only applied for version 2.0. |
typeProperties.password | SecretBase: |
Password for authentication. |
typeProperties.portNumber |
object |
The port numbers when connecting to server through non HTTPS/TLS connections. Type: integer (or Expression with resultType integer). Only used for V2. Only applied for version 2.0. |
typeProperties.server |
object |
Server name for connection. Type: string (or Expression with resultType string). |
typeProperties.sslMode |
object |
SSL mode for connection. Valid values including: “Disable”, “Allow”, “Prefer”, “Require”, “Verify-CA”, “Verify-Full”. Default value is “Verify-Full”. Type: string (or Expression with resultType string). Only applied for version 2.0. |
typeProperties.useDataEncryption |
object |
Specifies whether to encrypt all communication with the Teradata database. Allowed values are 0 or 1. This setting will be ignored for HTTPS/TLS connections. Type: integer (or Expression with resultType integer). Only applied for version 2.0. |
typeProperties.username |
object |
Username for authentication. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Linked service for Twilio.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Twilio |
Type of linked service. |
typeProperties.password | SecretBase: |
The auth token of Twilio service. |
typeProperties.userName |
object |
The Account SID of Twilio service. |
version |
string |
Version of the linked service. |
Linked service reference type.
Value | Description |
---|---|
LinkedServiceReference |
Vertica linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Vertica |
Type of linked service. |
typeProperties.connectionString |
object |
An ODBC connection string. Type: string, SecureString or AzureKeyVaultSecretReference. |
typeProperties.database |
object |
Database name for connection. Type: string. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.port |
object |
The port for the connection. Type: integer. |
typeProperties.pwd |
The Azure key vault secret reference of password in connection string. |
|
typeProperties.server |
object |
Server name for connection. Type: string. |
typeProperties.uid |
object |
Username for authentication. Type: string. |
version |
string |
Version of the linked service. |
Microsoft Fabric Warehouse linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Warehouse |
Type of linked service. |
typeProperties.artifactId |
object |
The ID of Microsoft Fabric Warehouse artifact. Type: string (or Expression with resultType string). |
typeProperties.encryptedCredential |
string |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string. |
typeProperties.endpoint |
object |
The endpoint of Microsoft Fabric Warehouse server. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalCredential | SecretBase: |
The credential of the service principal object in Azure Active Directory. If servicePrincipalCredentialType is 'ServicePrincipalKey', servicePrincipalCredential can be SecureString or AzureKeyVaultSecretReference. If servicePrincipalCredentialType is 'ServicePrincipalCert', servicePrincipalCredential can only be AzureKeyVaultSecretReference. |
typeProperties.servicePrincipalCredentialType |
object |
The service principal credential type to use in Server-To-Server authentication. 'ServicePrincipalKey' for key/secret, 'ServicePrincipalCert' for certificate. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalId |
object |
The ID of the application used to authenticate against Microsoft Fabric Warehouse. Type: string (or Expression with resultType string). |
typeProperties.servicePrincipalKey | SecretBase: |
The Key of the application used to authenticate against Microsoft Fabric Warehouse. |
typeProperties.tenant |
object |
The name or ID of the tenant to which the service principal belongs. Type: string (or Expression with resultType string). |
typeProperties.workspaceId |
object |
The ID of Microsoft Fabric workspace. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
A WebLinkedService that uses anonymous authentication to communicate with an HTTP endpoint.
Name | Type | Description |
---|---|---|
authenticationType |
string:
Anonymous |
Type of authentication used to connect to the web table source. |
url |
object |
The URL of the web service endpoint, e.g. http://www.microsoft.com . Type: string (or Expression with resultType string). |
A WebLinkedService that uses basic authentication to communicate with an HTTP endpoint.
Name | Type | Description |
---|---|---|
authenticationType |
string:
Basic |
Type of authentication used to connect to the web table source. |
password | SecretBase: |
The password for Basic authentication. |
url |
object |
The URL of the web service endpoint, e.g. http://www.microsoft.com . Type: string (or Expression with resultType string). |
username |
object |
User name for Basic authentication. Type: string (or Expression with resultType string). |
A WebLinkedService that uses client certificate based authentication to communicate with an HTTP endpoint. This scheme follows mutual authentication; the server must also provide valid credentials to the client.
Name | Type | Description |
---|---|---|
authenticationType |
string:
Client |
Type of authentication used to connect to the web table source. |
password | SecretBase: |
Password for the PFX file. |
pfx | SecretBase: |
Base64-encoded contents of a PFX file. |
url |
object |
The URL of the web service endpoint, e.g. http://www.microsoft.com . Type: string (or Expression with resultType string). |
Web linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Web |
Type of linked service. |
typeProperties | WebLinkedServiceTypeProperties: |
Web linked service properties. |
version |
string |
Version of the linked service. |
Xero Service linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Xero |
Type of linked service. |
typeProperties.connectionProperties |
object |
Properties used to connect to Xero. It is mutually exclusive with any other properties in the linked service. Type: object. |
typeProperties.consumerKey | SecretBase: |
The consumer key associated with the Xero application. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.host |
object |
The endpoint of the Xero server. (i.e. api.xero.com) |
typeProperties.privateKey | SecretBase: |
The private key from the .pem file that was generated for your Xero private application. You must include all the text from the .pem file, including the Unix line endings( ). |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. |
typeProperties.useHostVerification |
object |
Specifies whether to require the host name in the server's certificate to match the host name of the server when connecting over SSL. The default value is true. |
typeProperties.usePeerVerification |
object |
Specifies whether to verify the identity of the server when connecting over SSL. The default value is true. |
version |
string |
Version of the linked service. |
The authentication type to use.
Value | Description |
---|---|
Basic | |
Token |
Linked service for Zendesk.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Zendesk |
Type of linked service. |
typeProperties.apiToken | SecretBase: |
The api token for the Zendesk source. |
typeProperties.authenticationType |
The authentication type to use. |
|
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.password | SecretBase: |
The password of the Zendesk source. |
typeProperties.url |
object |
The url to connect Zendesk source. Type: string (or Expression with resultType string). |
typeProperties.userName |
object |
The username of the Zendesk source. Type: string (or Expression with resultType string). |
version |
string |
Version of the linked service. |
Zoho server linked service.
Name | Type | Description |
---|---|---|
annotations |
object[] |
List of tags that can be used for describing the linked service. |
connectVia |
The integration runtime reference. |
|
description |
string |
Linked service description. |
parameters |
<string,
Parameter |
Parameters for linked service. |
type |
string:
Zoho |
Type of linked service. |
typeProperties.accessToken | SecretBase: |
The access token for Zoho authentication. |
typeProperties.connectionProperties |
object |
Properties used to connect to Zoho. It is mutually exclusive with any other properties in the linked service. Type: object. |
typeProperties.encryptedCredential |
object |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string (or Expression with resultType string). |
typeProperties.endpoint |
object |
The endpoint of the Zoho server. (i.e. crm.zoho.com/crm/private) |
typeProperties.useEncryptedEndpoints |
object |
Specifies whether the data source endpoints are encrypted using HTTPS. The default value is true. |
typeProperties.useHostVerification |
object |
Specifies whether to require the host name in the server's certificate to match the host name of the server when connecting over SSL. The default value is true. |
typeProperties.usePeerVerification |
object |
Specifies whether to verify the identity of the server when connecting over SSL. The default value is true. |
version |
string |
Version of the linked service. |