Tutorial - Create a Populator

The populator is the tool you need to transfer data from external sources to your Local DB.

There are two ways to create a Populator:

  • Directly from a specified Source (under Linked elements tab)

source_linkedelements

  • Directly from the table

local_db_populator

When ready to create the populator, click on Create.

You will be redirected to the populator creation page.

populator_creation_page

You can notice that you have to select the Local DB table or the Source. One of the selection will already be chosen based on where you created the populators (Source or Local DB)

In the case above, the populator has been created from a Local DB, hence the selection already is done.

From this point, fill in all the missing information

  • Name (the name can be modified)
  • Local DB table (choose the local DB you want the data to go to)
  • Source (select the data where the data comes from)
  • Dataset (is the dataset Unique or Multiple): Usual case is Multiple

At the very bottom, you can see that you have a summary of the fields inside the Local DB table. You will have the same when you select a source.

Once done, you can create the populator.

It will redirect you to the populator page where you can match data from the source to the populator’s data.

populator_main_page

At the very top of the page, you can find

  • Populator’s name
  • Local db table linked to it
  • Source linked to it
  • Dataset (you can modify it here if you need to )

At the bottom section you’ll notice that you have:

  • Left: Data source preview
  • Right: Fields from the Local DB table
  • Middle: the field to fill in to create the matches between the data from the data source to a specific field from the local DB

The next step will be to create the relationship between the data source and the local DB by filling in the middle section.

When you click on Save, the link is created and the relationship is shown at the bottom of the middle section “Matches”

populator_matches

Match every data source’s fields to the Local DB.

Once everything is done, we go to the next step: Resolver!