Skip to main content

SQL Connector

Introduction

Description

The SQL connector allows an easy way to configure and manage relational databases.

Managed System

There a lot of relational databases, currently these are the supported databases, but it's possible to include easily more systems

  • MySQL
  • MariaDB
  • PostgreSQL
  • Oracle
  • Microsoft SQL Server
  • Informix
  • IBM DB2/400

For more information: List of relational databases

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

Prerequisites

Download and Install

 

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

Agent Configuration

Basic

Generic parameters

 

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

Custom parameters

Attribute mapping

Properties

Attributes

 

For more information about how you may configure attribute mapping, see the following link: Soffid Attribute Mapping Reference

 

 

Triggers

&&TODO&&Pending to be documented.

Load triggers

&&TODO&&Pending to be documented.

Account metada

&&TODO&&Pending to be documented.

Monitoring

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 > Administration > Monitoring and reporting > Syscserver monitoring

Tasks

Authoritative

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 &&TODO&& ¿Qué opcion?

And you will something like "Import authoritative data from <AGENT_NAME>".

Reconcile

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 &&TODO&&¿Qué opcion?

And you will something like "Reconcile all accounts from <AGENT_NAME>".

Synchronization

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

  • If you are checked the generic attribute "Read Only" in the "Basics" tab, only the changes in the managed systems will be updated in Soffid. We recommend this options until the global configuration of Soffid will be tested.
  • If you are not checked the generic attribute "Read Only" in the "Basics" tab, all the changes in Soffid or the managed system will be updated in the other. Note that this synchronization must be configured in the "Attribute mapping" tab correctly.

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

 

Back to top