Microsoft Azure Synapse Analytics Data Asset Properties
You can use a secret for the password.
See OCI Vault Secrets and Oracle Wallets.
To create a data asset that connects to an Azure Synapse Analytics source, complete the following properties and connection details.
Field | Description |
---|---|
Properties | |
Name |
Enter a name for the data asset. |
Identifier |
The identifier is a system-generated value based on the name you specify. You can change the identifier value, but after you create and save the data asset, you cannot update the identifier. |
Description |
Add a description. This field is optional. |
Type | Displays the data asset type based on the icon you select in the Select data asset type panel. For more information, see Creating a Data Asset. |
Host |
Enter the IP address of the host. |
Port |
Enter the port number to use. |
Database name |
Optional: Enter the database name. |
Host name in certificate |
Optional: Enter the host name in the certificate. |
Validate server certificate |
Select the check box if you want to validate the server certificate. |
Default connection information | |
Name |
Enter a name for the default connection. |
Identifier |
The identifier is a system-generated value based on the name you specify. You can change the identifier value, but after you create and save the connection, you cannot update the identifier. |
Description |
Add a description. This field is optional. |
Username |
Enter the user name. |
Use password |
If you select this option, enter the password in the Password field. |
Use vault secret OCID | If you use a secret in Oracle Cloud Infrastructure Vault to store the password, select this option. The following field appears:
|
(Optional) Test connection | |
Test connection |
After you complete all the required fields, you can click Test connection to ensure you have entered the data asset details correctly. A success or failure message displays, indicating whether the test was successful or not. If the test fails, review your connection settings and try again. |