Use Automap

The Automap process searches for tables in source models to map to tables in the target model. It creates only direct 1:1 mappings. It does not change existing manual mappings. After running it, you select the mappings you want to use.

For details on the automap process, see this video:

and this:

1. After you select a study, click the Study Configuration icon from the navigation bar to open the Clinical Data Model tab.
2. Click the Transformation tab to view the source and target tables.
3. Choose a target data model from the Data Model list in the left panel.
4. Do one of the following:
   • To map all the tables and columns in the data model, click Map > Automap from the Transformation tab title bar.
   • To map tables and columns you select, select one or more target tables and click Map > Automap Selected Tables from the option in Target Tables.

     Tip:

     For the best performance, select 10 tables or less.
5. Wait for the mapping process to complete on the data model. (If you need to work on other data models while the mapping runs on the selected model, you can.) During the mapping process, you see a red status message in the Transformation tab title bar (next to the Check In button). For example, you see an "Automapping in progress" or "Automapping is complete" message in red.
   You also see a notification message open from the notification bubble in the title bar. When done, you see this message: "Automapping suggestions require review and approval."
6. To review and accept the maps, see Accept or reject suggested mappings.

For more details on the Automap feature, see FAQ How does Automap work?

• Accept or reject suggested mappings