Table of Contents



Oracle Connector could manage an Oracle database.

Managed Systems

This connector is specific for integration with an Oracle database, if you want to connect a generic SQL database, please visit the following page: SQL Connector.

If your system is not in the previously list, it's possible to include it easily!

For more information to check if your system may be synchronized with this connector you do not hesitate to contact us through our Contact form


It is needed a user with sysdba access and permissions.

User management



Download and install

This addon is located in the Connectors section and its name is Oracle Connector.

For download and install the addon you could review our generic documentation about this process: Addons installation

Agent configuration

This connector could manage only Users objects.


Generic parameters

After the installation of the addon, you may create and configure agent instances.

To configure this Oracle Connector you must select "OracleAgent" in the attribute "Type" of the generic parameters section in the agents page configuration.

For more information about how you may configure the generic parameters of the agent, see the following link: Agents configuration

Custom parameters

Below there are the specific parameters for this agent implementation:

Sysdba user name to authenticate
Oracle passwordPassword of the user to authenticate
Connection string to databaseDatabase URL. Use something like jdbc:oracle:thin:@host:port:sid

Password to protect roles

Optional password to use on password protected roles
Default user profileOptional profile to set limits on the database resources and the user password
Default tablespaceOptional tablespace for user creation
Temporary tablespace

Optional temporary tablespace for user creation

Load Triggers

Pending to be documented.

Access Control

Oracle connector has the ability to establish an access control for Oracle Users.

If the access control checkbox is enabled, only the users and application that are listed at access control page will be allowed to login. So, you can restrict the IP address and application a user can connect from.

This restriction does not apply to DBA users.



After the agent configuration you could check in the monitoring page if the service is running in the Synchronization Server, please go to "Start Menu > Monitoring and reporting > System monitoring".



If you are checked "Authorized identity source", an automatic task to load identities from the managed system to Soffid is available, please go to "Start Menu > Processes and Tasks > Manage automatic tasks", and you will something like "Import authoritative data from <AGENT_NAME>".


If your are configured the "Attribute Mapping" tab with some of our objects: "user, account, role, group or grant", an automatic task to synchronize these objects from the managed system to Soffid is available, please go to "Start Menu > Processes and Tasks > Manage automatic tasks", and you will something like "Reconcile all accounts from <AGENT_NAME>".


About the synchronization of the objects, there are two possible options: