Edit Rules

About this Task

Options available on the edit pane depend on the type of mapping rule you are editing. For an overview of each mapping rule option, see:

• New Documents

• Embedded Array

• Embedded Documents

Steps

1. From the Mapping screen, click a table or collection name on the Schema model pane or Diagram view.

2. From the Mappings pane, click the icon.

3. Define the options for the mapping rule. When defining the mapping rule, you can:

   • Change the collection name.

   • Change field names.

   • Include or exclude a field from your sync job by clicking the icon next to the field name.

4. Optionally, if you want to select a BSON type or set null handling rules for your mapping rule:

   1. Click the icon next to the field you want to customize.

   2. Select a BSON type.

   3. Select a Null handling option.

   • Insert as null: preserves null values, and nulls are inserted into your destination collection.

   • Omit: skips any null values, and nulls are not inserted into the destination collection.

   You can view a field's Original name and Original type in the expanded customized field menu.

   Note

   For additional details on field customization and data type conversions, see field customizations.

5. Click Save and close to save your edits.

Learn More

To learn more about managing mapping rules, see:

• Create Rules From Relational

• Create Rules To MongoDB

• Delete mapping rules

• View mapping rules