Configuring an ADF Linked Service Connection for SAP HANA
For information on how to enable a connection for use with linked services, see Configuring a Linked Service Connection.
Field labels in this walkthrough follow the underlying Azure Data Factory property names, with the connection column that carries each value named alongside. The exact labels shown in the BimlFlex Connection Editor may differ.
After selecting SAP HANA from the Linked Service Type dropdown, the form required for creating an SAP HANA Linked Service will appear.
Source Only Connector
An SAP HANA connection is used as a source. It is not available as a target.
Choosing an Authentication Method
| Method | Credentials | Additional Settings |
|---|---|---|
| Basic | Username and Password | None |
| Windows | Username and Password | None |
Recommendation: Store the Password in Azure Key Vault rather than entering it as plaintext.
Complete Example: Basic Authentication with Azure Key Vault
| Field | Example Value |
|---|---|
| Connect via Integration Runtime | bfx-selfhosted-ir |
| Server | saphana.contoso.com:30015 |
| Authentication Type | Basic |
| Username | BFX_READER |
| Azure Key Vault Linked Service | bfx-kv |
| Secret Name (for Password) | BFX-SRC-SapHanaPassword |
Required Fields
Common Required Fields
Both Authentication Types of an SAP HANA Linked Service connection use a Username and Password, so the same fields are required on every connection.
These common required fields are:
- Connect via Integration Runtime
- Server
- Authentication Type
- Username
- Password (or Azure Key Vault)
Connect via Integration Runtime
Connect via Integration Runtime names the integration runtime for an SAP HANA Linked Service connection.
The default value is AutoResolveIntegrationRuntime.
To use another runtime, select it from the dropdown or choose + New to add one.
When a custom value is saved in the linked service form, it will be added to the custom integration runtimes.
The custom values that appear in this dropdown can be maintained in Settings under Azure - AzureIntegrationRuntime.
The runtime is stored in the connection's LS_ConnectVia_IntegrationRuntime column. Any value other than AutoResolveIntegrationRuntime is written to the linked service as the runtime it connects through.
A self-hosted integration runtime is required for an SAP HANA connection, so set this field to the name of a self-hosted integration runtime.
Server
The Server identifies the SAP HANA server, with the port optional (for example, saphana.contoso.com:30015). The default port is 30015.
It is stored in the connection's LS_Server column and maps to the ADF server property.
Connection String
When the connection holds a Connection String, it is written to the linked service as the ADF connectionString property, as text from the LS_ConnectionString column or as an Azure Key Vault reference held in the LS_ConnectionStringKVS_ fields that resolves to the connection string at runtime.
The Server, Authentication Type, Username and Password fields are written to their own linked service properties beside it.
Authentication Type
The SAP HANA Linked Service connection can use Basic or Windows authentication.
The selected value is stored in the connection's LS_AuthenticationType column and maps to the ADF authenticationType property.
For Basic and for Windows, a Username and Password are required.
Basic
Basic authentication signs in to the SAP HANA database with a Username and Password.
The Username is stored in the connection's LS_Username column and maps to the ADF userName property.
The Password field accepts the password as plaintext in the LS_Password column, or an Azure Key Vault reference held in the LS_PasswordKVS_ fields that resolves to the password at runtime.
When the connection's LS_EncryptedCredential column holds an Encrypted Credential value, it is also written to the linked service.
It is suggested that Azure Key Vault be used in place of manually entering the Password.
Windows
Windows authentication signs in with a Username and Password (for example, the Username [email protected]).
The Username and Password are stored in the same LS_Username column and LS_Password column or LS_PasswordKVS_ fields as for Basic authentication, and map to the ADF userName and password properties.
It is suggested that Azure Key Vault be used in place of manually entering the Password.
Azure Data Factory Linked Service Additional Information
For additional information on ADF SAP HANA Linked Service and its connection requirements see the Azure Data Factory SAP HANA Connector documentation.