Setting Up Borrower Data Synchronization

The first step in setting up synchronization is to set up views in Horizon.

Before You Begin

You must work with other members of your library consortium to decide which institution is responsible for running Synchro.

This will avoid duplication of effort while making sure each interested library has the updated records it needs.

Each server must use unique borrower numbers.

The newkey setting for borrower on one of the databases should be much larger than the value of the other database. (For more information, contact your Horizon implementation team.)

Note: If you want to synchronize servers that do not have unique numbers, contact your Horizon salesperson regarding a customized partial data migration.

If you have not already done so, set up a computer that has network access to any consortium member libraries that want to synchronize their borrower information.

Use the computer that has network access for all steps in this task. (You may want to use the same computer you use to run Day End processes.)

To set up borrower data synchronization

1 Open the sync_server_db view in the Table Editor.
2 Set up the sync_server_db view for the remote server/database. (For instructions, contact your Horizon implementation team.)
3 Set up the appropriate views in the sync_table view in the Table Editor with the remote server/database code. (For instructions, contact your Horizon implementation team.)
4 Configure the Synchro program for automatic startup whenever you boot the computer it runs on. (For instructions, see Setting Synchro to Start Automatically.)
5 Repeat steps 1 through 4 for each pair of consortium member libraries that want to synchronize their borrower databases.

Important: When you set up a pair of databases, make sure you remember which database of the pair is designated as the remote database in the Table Editor.

 


© 1998-2017 Sirsi Corporation