Skip to content
Back to Site

Configure Advanced Database Mapping

Map supported database fields or columns only after exact Source, Target, schema, and Value Type eligibility is confirmed.

Advanced Database Mapping routes supported database data to eligible Target Store fields or columns. Availability is determined in layers: the exact Source setup must support Advanced Database Mapping, the selected Target Platform must support it, and the requested schema destination must be supported and able to represent the value correctly.

Use Advanced Database Mapping Platform Eligibility for Source and Target role support, then use the Advanced Database Mapping Schema Registry to qualify the requested entity, table, field, column, and Value Type.

  1. Confirm Advanced Database Mapping support for the exact Source setup and Target Platform.
  2. Confirm that the requested source and target database locations are present in the supported schema scope and have compatible Value Types.
  3. Expand Advanced Database Mapping.
  4. Select an entity and click Add Mapping.
  5. Select the Source Field for the database value to route.
  6. Select the supported Target Field that should receive the value.
  7. When the active supported scope allows a new target database field, select New Column and complete Custom Target Field.
  8. Add another rule inside the same Entity Mapping when another supported database field requires routing.

Example: map a database field to the corresponding target field

Section titled “Example: map a database field to the corresponding target field”

When the active migration exposes the supported Manufacturers fields, configure:

SettingValue
EntityManufacturers
Source FieldColumn name
Target FieldColumn name

This routes the supported source database value to the corresponding target database field without changing the value.

Advanced Database Mapping rules run from top to bottom.

  • Click x to remove an individual mapping rule.
  • Use the remove control for the Entity Mapping to delete the entire mapping group.

If Custom follows Add-ons, continue to Custom. If Add-ons is the final Configuration screen, use Go to Migration, then continue to Start and Monitor a Migration.