EN

NL
EN
Introduction Definitions Login User profile Chatbot Menu
Home Dashboard Newsletters & Lists Leads 360° customer view Clicks Web Recognition Campaigns Overview Create Manage Search Selections Overview Create Manage Search Open Lock Template Runs Overview Search Schedules Overview Search Monitor Overview
Operation Campaign Working with blocks Connecting blocks Grouping blocks Add Memo Signal Context menus Settings Coding information
Select & Segment Select Split Sample Switch Deduplication Communication pressure Combine & Exclude Combine Exclude Enrich & Edit Upload file Import file Snapshot Web service Enrichment Datamart Aggregations
Channels
Email Create Edit Personalization AI Assistant User content Hyperlinks Mapping RSS Settings Contacts Validation A/B testing Test Additional
Preview Export SMS App messages Webpush Landing page Website personalization Content Newsletter wizard Dynamic content HTML editor Data capture RSS Funnel
Key path
Execute Schedule Webhook Time zones
Email reports
General settings TID info Email info Templates Management dashboard Admin settings
Access & entitlement Repository Authorization Email Trackers Tags Statistics Inline CSS Web Embedded forms Integration AI Assistant Webhooks Web service Datamarts Datastores Datalayers System datamarts System E-mail servers Domains Authorization Themes Output blocks Tokens TP Leads Group definitions Leadtype definitions Property definitions Ezines Business Units Ezines Property
Entities XML Preference Center Processes Housekeeping Bot click filtering Mail processing and email address status Feedback loop Number of records in Ternair CDP datastores

Datamart

A datamart can be used to edit or select information.

Please note: that in order to use a datamart block, a configuration in the general settings is required.

Drag a datamart block to the worksheet and connect it to one input block.
You can connect a datamart block to the following blocks:

  • Webservice

  • Upload

  • Webhook

  • Snapshot



You can use the datamart block only if the selection is saved.

Double-click the datamart block to open the settings.

On the left side, choose the datamart you want to use. On the right hand side, map the fields.


Edit data

Edit can be done by selecting the desired datamart from the dropdown.

Based on the options of the datalayer , the items in the fields list can be selected (mapped). Use the 'Automap fields' button or drag the field from the right column to the corresponding field in the left column.

Additional options
Depending on the options chosen in datalayers, you can apply the following actions:

  • Upsert:

    This option updates records in the underlying datastore, if the key is present. If it is not, a new record is created.

  • Delete:

    With this option, records in the underlying store are deleted, if the key is present

  • Merge:

    With this option, the underlying datastore is compared with the supplied data. Records that do not exist in the datastore are created, records that exist are updated, and records that are missing from the supplied data are removed from the datastore.



Advanced Options
Standardly, a datamart retains the existing value of a field if you leave it blank during data merging. The function 'Demonstrate advanced options' allows you to choose to empty the existing value if you supply an empty field.

Please note: The key should never be emptied, therefore the option is not given here.


Execute

Select the datamart block and right-click and then click "Execute."

Please note: when you delete the datamart in a flow, you never delete the data.


Select

All datamarts can be selected under source and can be used as a regular data source.


Video


In this article

Datamart Edit data Execute Select Video

Copyright © 2025 Ternair.