PostgreSQL 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 a PostgreSQL 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 host name. |
| Port |
Enter the port number to use. |
| Database name |
Optional: Enter the database name. |
| Enable SSL and Validate server certificate |
Select the Enable SSL check box if you want SSL-based authentication. Then select the Validate server certificate 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. |
| Password or Vault Secret OCID for database password |
Select Use password or Use vault secret OCID, depending on whether you use a secret in Oracle Cloud Infrastructure Vault to store the password for the user. Then enter the password, or copy and paste the OCID of the secret for the database password associated with the user. |
| (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. |