Oracle Cloud Infrastructure Documentation

Skip to main content

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 can change the identifier value, but after you create and save, you cannot update the identifier.
Description	Add a description. This field is optional.
Type	The field shows the data source type that you selected in the Select data asset type panel (as described in Creating a Data Asset). Data Integration displays the data asset property fields and default connection fields based on this type.
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 can change the identifier value, but after you create and save, 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: Vault Secret OCID for database password: Copy and paste the OCID of the secret for the database password associated with the user from OCI Vault.
(Optional) Test connection
Test connection	After you complete all the required fields, click Test connection to ensure that the data asset details have been entered correctly and the connection can be established. A success message appears if the test is successful. If the test fails with an error message, review your connection settings and try again.