Database Connector

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.

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

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

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:

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.

The database connector requires the following by way of configuration.

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?