SDMSDM Documentation
Advanced Mode

Multi-Source Flows

Combine data from multiple sources

Multi-Source Flows

Advanced Mode allows you to combine data from multiple sources into a single flow.

Use Cases

Combining SIS and HR Data

  • Student data from the SIS
  • Staff data from HR system
  • Merged into unified output for ASM

Multiple School Locations

  • Each school exports separately
  • Merge into single organization hierarchy
  • Publish as one dataset

Using the Merge Node

Adding a Merge Node

  1. Drag the Merge node from the palette
  2. Connect multiple source outputs to merge inputs
  3. Connect merge output to next step

Conflict Resolution

When the same entity exists in multiple sources:

StrategyDescription
First winsKeep data from first source
Last winsKeep data from last source
ManualReview and choose per conflict
Merge fieldsCombine non-conflicting fields

Best Practices

  1. Match sourcedIds - Use consistent IDs across sources
  2. Test incrementally - Preview after each source
  3. Document sources - Name nodes clearly
  4. Validate merged data - Check for duplicates

Multi-source flows are more complex to debug. Start with Standard Mode and migrate to Advanced only when needed.

On this page