Connecting to Oracle RDBMS through Oracle SQL Proxy

From the native SQL client, create a new connection that connects using the Oracle Proxy.

Depending on the client being used, these steps may vary. However, the general guidance remains the same.

  • The Authentication used by the client will be the user’s personal credentials to XTAM. For example, if the user logs into XTAM with the account ‘john’, then they will use ‘john’ and its password to authenticate their client to the XTAM Oracle Proxy.
  • The Connection details used by the client will be for the XTAM Oracle Proxy, not the actual database as defined in the XTAM record. The Host defined in the client will be your XTAM instance (i.e. xtam.company.com), the Port defined in the client will be the XTAM Oracle Proxy Port (i.e. 1522 by default) and the Service Name or SID will be the ID-CAP value from the XTAM record that was created (i.e. L-1IZOAKKNTAYM0).

As an example, here is a screenshot of the configuration using the Oracle SQL Developer v20 client:

Oracle_SQL_Developer_v20.png

Using the Test option in this client, the status will return Success when the client connects successfully to the XTAM Oracle Proxy.

During Connection, the user’s client will connect to the XTAM Oracle Proxy that will use the XTAM record to create the proxy connection to the database.

The proxy identifies the XTAM record using the ID-CAP value as provided in the Service Name or SID value of the connection.