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.
|Polling||Yes (when configured)|
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:
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.
|Database Agent||Agents describe connected systems and their respective connection information. This connector requires a database agent (OLE, Oracle, SQL etc) to connect to.|
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.|
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'
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
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.|
Customer support service by UserEcho