Database Connector

Overview

The Database connector is a system provided connector that is used to encapsulate data in a single database table.

This connector can read and write from a target database table.

Technical Requirements

A functioning target SQL, Oracle or OLE database installed with any of their respective prerequisites met.

Usage

A Database connector encapsulates the data in a single database table.

Reading Yes
Writing Yes
Deleting No
Polling Yes (when configured)

Schema

Fields in a Database connector schema refer to individual columns in the target table of the same name.

Taking the following database table as an example:

Image 3889

TIP: The available schema fields would be id, name, phonenum, and dob

The schema provider for this connector will retrieve the available headings with the best-fit UNIFYBroker value types.

Image 3779

Configuration

The database connector requires the following by way of configuration.

Image 3778

Name Description
Database Agent Agents describe connected systems and their respective connection information. This connector requires a database agent (OLE, Oracle, SQL etc) to connect to.
Schema

The schema of the target database object. The value must be provided if the database object is contained withing a schema container other than DBO. Prior to SQL Server 2005 this was known as the owner.

See https://technet.microsoft.com/en-us/library/ms190387.aspx for details.

Table The name of the requested table on the target database.
Filter

The filters to be applied on request.

These filters are in the form of a SQL WHERE query. e.g. firstName = 'James' OR surname = 'Harris'

Orders

The orders to be applied on request.

These orders are in the form of a SQL ORDER BY query. e.g. firstName ASC, surname DESC

Owner

The owner of the target database object. The value must be provided if the database object owner is something other than DBO.

See http://msdn.microsoft.com/en-us/library/aa905163.aspx for details.

Read Threshold The threshold at which some operations favor retrieving all items over retrieving specific items. It is also used for the number of items that are saved at a time for identity management platforms supporting batched saves.
Modified Column The name of a datetime based column in the table. Allows the connector to perform import changes (polling) operations. The field must be included in the schema.

This article was helpful for 1 person. Is this article helpful for you?