Assigning a Database Column to a Constant Value

Many Horizon database columns, such as btype and bstat, do not map to standard LDAP attributes. In this case, you need to assign a constant value for these columns. Horizon stores the constant value you assign in the database column. You cannot map this column to a standard LDAP attribute.

For each profile, you can only assign one constant value to each database column. (For example, you can only assign one constant value to the btype column, such as “student.”) As a result, all borrowers imported for a specific profile are assigned a “student” btype. If you want to specify a different constant value for a column, you must create a new profile.

In addition, some Horizon database columns require you to add constant values to data as it is imported. For example, the Horizon database stores borrower name data in the borrower_name column as last name, first name. In the LDAP schema, surname and common name are separate attributes and do not contain a comma. As you map the borrower_name column to the LDAP attributes, you need to add the comma as a constant value.

Follow these steps as you map a database column to a constant value:

You may have several LDAP servers that contain borrower data that you want to import into the Horizon database. If these servers have similar schemas and contexts to which you want to bind, you can create one mapping, set it as the default, and use it as the mapping for other profiles. To set a default, choose File > Apply Default Map in the Borrower-LDAP Column Maps window.

 


© 1998-2017 Sirsi Corporation