Skip to main content

Microsoft Access (Basic Authentication)

Connect to a Microsoft Access database using basic authentication

To use this connection type within the API, use a ConnectionTypeCode of MSACCESS-BASIC.

Variable Reference​

The following variables are supported:

  • DatabaseConnectionStringSecretName - (Required) The name of the Key Vault secret containing the connection string to the database.

  • DatabaseUsernameSecretName - (Required) The name of the Key Vault Secret containing the value of the Application ID of the Service Principal used to access the source database.

  • DatabasePasswordSecretName - (Required) The name of the Key Vault Secret containing the value of the Client Secret of the Service Principal used to access the source database.

  • IntegrationRuntime - (Required) Integration Runtime to use for Copy Activity.