Configuration Parameters

Following are the list of configuration parameters of SailPoint IdentityIQ Oracle Connector:

Note
The parameters marked with the an asterisk (*) are mandatory parameters.

The name of the administrative account that has all the privileges to perform the CRUD (Create, Read, Update, and Delete) operations. The default administrator of an Oracle Server is system.

The password of the administrative account.

The name of the type4 driver to use when making a connection with the oracle server. By default, this connector uses oracle.jdbc.driver.OracleDriver

The url to connect to the database. The format is jdbc:oracle:thin:@<HOST>:<PORT>:<SID>

For example jdbc:oracle:thin:@xxx.xx.xx.xx:1521:ORCL. The URL consists of the following:

  • jdbc:oracle:thin:@: This is a common part that states that the connection is made using thin driver.

  • xxx.xx.xx.xx: Server name or IP of the oracle server.

  • 1521: The port number of the oracle server. This port number should be known by the Oracle server administrator.

  • ORCL: The SID of the oracle server.

To connect to PDB of Oracle Database 12c, use the service name instead of SID in the URL as follows:

jdbc:oracle:thin:@<HOST>:<PORT>/<SERVICE_NAME>

For example:

jdbc:oracle:thin:@xxx.xx.xx.xxx:1522/orcl.16.23.200

This text box can be used to specify the additional configuration parameters. These additional parameters must be passed in key value pairs. If multiple parameters must be specified, then they need to be passed in new line.

For example:

oracle.net.encryption_client=ACCEPTED

oracle.net.encryption_types_client=AES256