About Importing Loyalty Members and Transactions Using Siebel EIM
You can use Siebel Enterprise Integration Manager (EIM) to perform bulk imports of loyalty members and transactions into the Siebel database from other data sources. Detailed information on using Siebel EIM to import data into the Siebel database is provided in Siebel Enterprise Integration Manager Administration Guide. This topic outlines information that is specific to importing loyalty member data into the Siebel database.
About Assigning Loyalty Server Keys
The recommended method of bulk importing loyalty members and transactions into the Siebel database is to import the data into the EIM tables EIM_LOY_MEMBER and EIM_LOY_TXN, then process transaction data with the Loyalty Batch Engine to make sure that members’ balances and point blocks are updated appropriately.
To enable the imported loyalty member transactions to be processed by the Loyalty Batch Engine, each imported member must be allocated a valid server key number. You can specify a server key number for each member to be imported in the MEMBER_MEM_KEY_NUM field in the EIM table EIM_LOY_MEMBER. For performance reasons, it is important that the server keys are distributed evenly across the imported members, so do not assign the same key to all members. For detailed information on how to assign server keys, see Setting Up Server Keys for Siebel Loyalty.