Run Pipeline Batch

Now you can run the pipeline batch MongoDB Contacts to xConnect Migration. The new contact facet LoyaltyProgram will be created on xConnect contacts if the required data is available in MongoDB.

After you run the pipeline batch, there are multiple ways you can check to confirm the contact facet was properly created.

xConnect Collection Database

You can check the xConnect collection database for records that represent the new facet.

  1. Connect to one of the collection database shards.
  2. Use the following query:
SELECT ContactId, FacetKey, FacetData
  FROM xdb_collection.ContactFacets
  WHERE FacetKey = 'LoyaltyProgram'

You should see a row for each MongoDB contact that has loyalty program data associated with it.

ContactId FacetKey FacetData
########-####-####-####-############ LoyaltyProgram {"@odata.type":"#MigrationTool.Examples.Loyalty ...

The following is the complete FacetData value:

{
    "@odata.type":"#MigrationTool.Examples.Loyalty.LoyaltyProgramInfo",
    "MembershipId":100011,
    "EnrollmentDate":"1919-12-12T12:34:56.0000000Z",
    "HomeStoreId":"GARRISON01"
}