Data sources supported for user provisioning

Data Sources supported in version 5

• Text File – works with virtually any HR/ERP or SIS system

• Microsoft SQL Server Tables and Views – works with most any Microsoft SQL based HR/ERP/SIS system

• For details on how to connect to Administrator to Microsoft SQL Server see Connecting to Microsoft SQL Server data source.

• Oracle Database Server Tables and Views – works with most any Oracle based HR/ERP/SIS system

Cayosoft Default Data Source field names

The Cayosoft Administrator rules use a default set of field names, but alternative names from the data source can be used by selecting a data source column name during rule configuration.

In some cases, the names of the columns in the data source are not yet defined and may be able to be match to Cayosoft by matching the standard Cayosoft Field Names are listed below.

Standard Field Names for Data Sources

• FirstName

• LastName

• Initials

• DisplayName

• Description

• EmailAddress

• Password

• Title

• Department

• EmployeeNumber

• EmployeeID

• StreetAddress

• Location

• State

• PostalCode

• Country

• Company

• Division

• Office

• OfficePhone

• MobilePhone

• Fax