Skip to content

How-to guide

Entity linking

Link one or more data sources to one or more ontology entities. Synced data appears in source-linked spreadsheets with one tab per source.

2 min

At a glance

Link one or more data sources to one or more ontology entities. Synced data appears in source-linked spreadsheets with one tab per source.

Before you start

From the configuration wizard

At step 4 of the connector configuration wizard, select the target entity from the dropdown list.

Wizard step 4 -- entity selection

The link is created automatically when the wizard completes.

From the entity Sources tab

You can also link a source from the ontology:

  1. Open an entity in the ontology.
  2. Click the Sources tab.

Entity Sources tab

  1. Click Link a source to open the selection modal.

Source selection modal

  1. Select the source to link and confirm.

Result: source-linked spreadsheet

Once the link is established, synced data is accessible in a dedicated spreadsheet:

  • Each linked source generates a tab in the spreadsheet.
  • Data updates continuously with each sync.

Source-linked spreadsheet with tabs per source

Possible relationships

SchemaDescription
1 source -> 1 entitySimple case: one API feeds one entity.
N sources -> 1 entityMultiple sources converge into the same entity (e.g. CRM + ERP -> Clients).
1 source -> N entitiesA single source feeds multiple entities (e.g. Airtable -> Contacts + Deals).

Common errors

ErrorSolution
Source not visible in the selectorCheck that the connector is active in Data Sources.
Missing data in the spreadsheetCheck the streams selected in the connector configuration.
Entity not visibleCheck that the entity exists in the active ontology space.

Expected outcome

Source linked to entity
Data flows into the source-linked spreadsheet and updates automatically with each sync.

See also

Need help?

Write to us: Support and contact.

Multiple sources: mapping and provenance

Linking CRM and ERP to Client does not automatically merge rows. Define identifier correspondence and retain source references. Without a reliable match, report ambiguity rather than matching names.

Choose a sample record in each source. After a successful sync, check the stream, target type, populated properties and provenance. A visible link with an empty list may mean no data, an unselected stream or a failed sync.

Correct external data in its source. Changing a type definition does not correct source columns. Use Model two sources to prepare mappings and Diagnosis to locate differences.

Did this page help you achieve your goal?