Create Rules From Relational

About this Task

Options available on the Add mapping pane depend on the type of mapping rule you are adding. For a full overview of each mapping rule option see:

• New Documents

• Embedded Array

• Embedded documents

You can also create mapping rules based on a destination MongoDB model. For more information, see Create Rules to MongoDB.

Steps

1. Open a project.

2. In the left Schema model pane, click on a collection under the Relational header.

   This prompts the Mappings pane to open on the right of the screen.

3. On the Mappings pane, click + Add to create a new mapping rule.

4. Define the name of the target MongoDB collection.

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

   • Change the collection name.

   • Change field names.

   • To include or exclude a field from your migration job, click the icon next to the field name.

6. 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.

7. Click Save and close.

Learn More

To learn more about managing mapping rules, see:

• Edit mapping rules

• Delete mapping rules

• View mapping rules