Oracle

To add Oracle as a Resource in the Admin UI, set the following configuration properties. For more information, see our main guide, Add a Resource. Oracle Database versions 11g, 12c, and 19c have been tested and are supported for use with strongDM.

Configuration Properties

Add Oracle Resource Dialog
Add Oracle Resource Dialog
  • Display Name (Required): Enter a meaningful name for this resource, such as “Oracle.” This name displays throughout strongDM. Do not include special characters like quotes (") or angle brackets (< or >).
  • Datasource Type (Required): Select Oracle.
  • Hostname (Required): Enter the hostname. Note that it must be accessible to a Gateway or Relay.
  • Port (Required): Enter the port to connect to the resource (default: 1521).
  • Port Override: After this Resource has been created, this field will be automatically filled with a port between 1024-59999 that is not in use by another Resource. You can optionally overwrite it with your own preferred port later in the Port Overrides settings.
  • Database (Required): Enter the name of the database you will be connecting to with this Resource.
  • Secret Store: This field lets you specify where the credentials for this Resource are stored (i.e., strongDM, AWS Secrets Manager, Azure Key Vault, GCP Secret Manager, HashiCorp Vault, etc.). This field is only displayed if Secret Store integration is configured in the Admin UI. The default Secret Store type is strongDM. Selecting any other Secret Store type causes properties unique to that Secret Store to appear, such as Username (path), Password (path), and so forth. For more detailed information about path to the secrets you’ve stored in a particular Secret Store, see the Secret Store integration configuration guide for the one you are using.
  • Username (Required): This field is shown when Secret Store integration is not configured for your organization, or when it is and strongDM is the selected Secret Store type. Enter the username of the user that will be used for this Resource.
  • Username (path) (Required): If Secret Store integration is configured for your organization and you selected a Secret Store type that is not strongDM, enter the path to the secret in your Secret Store (e.g., path/to/credential?key=optionalKeyName). The key argument is optional.
  • Password (Required): This field is shown when Secret Store integration is not configured for your organization, or when it is and strongDM is the selected Secret Store type. Enter the password of the user that will be used for this Resource.
  • Password (path) (Required): If Secret Store integration is configured for your organization and you selected a Secret Store type that is not strongDM, enter the path to the secret in your Secret Store (e.g., path/to/credential?key=optionalKeyName). The key argument is optional.
  • TLS Required (Optional): Check this box if you wish to require strongDM to use TLS to connect to the Resource.
  • Resource Tags (Optional): Assign tags to the Resource by entering key-value pairs in the format <KEY>=<VALUE> (e.g., env=dev).

If any errors occur, please copy them into an email and send it to support@strongdm.com.

Top