Sesam Talk
Sesam Hub
Community
Support
Sign up
What is Sesam Hub
Key benefits
Core principles
Concepts
Data architecture
Demo
Roadmap
Features
Data Management
Automatic Reprocessing
Namespaces
Merging
Global datasets
Dependency Tracking
Schema Inference
Schema Models
Integrated Search
Property Lineage
Completeness
Compaction
Config Groups
Data Synchronization
Scheduling and Signalling
Change Tracking
Extensions
Continuation Support
Deletion Tracking
Circuit breakers
Transit Encoding
Operations
VPN
Durable Data
Notifications
Metrics and monitoring
Bring your own key
Network Policy
Status Page
Software Channels
Documentation
Quick Reference
Project kickstart
Planning a project
Setting up an environment
Creating a dataflow
Building blocks
Streams of entities
Datasets
Systems
Pipes
Flows
Environment Variables
Secrets
Service Metadata
Data Transformation Language (DTL)
Introduction
Annotated Example
Built-in Variables
Path Expressions and Hops
How joins work
Namespace aware functions
Caveats
DTL: Transforms
DTL: Boolean logic
DTL: Booleans
DTL: Bytes
DTL: Comparisons
DTL: Conditionals
DTL: Date and time
DTL: Dictionaries
DTL: Encryption
DTL: Hops
DTL: JSON
DTL: Lists
DTL: Math
DTL: Misc
DTL: Namespaced identifiers
DTL: Nulls
DTL: Numbers
DTL: Phonenumbers
DTL: Sets
DTL: Strings
DTL: URIs
DTL: UUIDs
Argument types
Supported Timezones
Data management
Patterns
Enrich patterns
Extract foreign references as extracted datatypes pattern
Adding type information pattern
Splitting out lists of sub-objects pattern
Normalising data pattern
Extract reference properties as reference/classification entities
Connect patterns
Cleaning data pattern
External merge pattern
Golden property based on priority pattern
Golden property based on last updated pattern
Golden property based on quality
Feedback loop pattern
Hungarian notation references pattern
Transform patterns
Late schema binding
Defining hierarchies for recursion
Re-mapping references to target identifiers
Generic patterns
Rewriting identity pattern
Data management
Entity Data Model
Data synchronization
Patterns
Collect Patterns
Source with since support but no deletions pattern
Source that only provides delta streams pattern
Source with parameterized input pattern
Recreate best effort history from a source pattern
Make periodic entities from a versioned history pattern
Sporadic empty response pattern
Keep data in original structure pattern
Avoid unnecessary load on source systems pattern
Share Patterns
Optimistic locking pattern
Insert pattern
Update pattern
Delete pattern
Exposing data pattern
Capture response with transform pattern
External reference pattern
Non-idempotency
Cron Expressions
RDF Support
JSON Pull Protocol
JSON Push Protocol
Developer Extension Points
Custom Data Sources
Custom Data Transforms
Custom Data Sinks
Microservices in Sesam
Source Datatype Mapping
API Best Practices
Connectors
The Connector Contract
Connector Configuration
Operations
Security
Metrics and monitoring
Pump Execution Dataset
Configuration Management
Using Sesam with a version control system
Testing a Sesam configuration locally
Continuous integration
Automatic deployment
Self-hosted service
Self-hosted on Kubernetes
Debugging
Behind the scenes
Troubleshooting
Data platforms
Sesam in Microsoft Azure
Sesam in Google Cloud Platform
Tools
Management Studio
Sesam Client
Consumer Portal
Authentication
GDPR platform
Getting started
Platform configuration
Datatypes and purposes configuration
The GDPR data access portal
Developer documentation
Changelog
Connector Tools
Service Configuration
General
Environment variables
Service metadata
Pipes
Sources
Binary source
Conditional source
CSV source
Dataset source
Embedded source
Empty source
HTTP endpoint source
JSON source
LDAP source
Merge source
Merge datasets source
RDF source
REST source
SDShare source
SPARQL source
SQL source
Union datasets source
Transforms
Conditional transform
DTL transform
Emit children transform
HTTP transform
JSON Schema validation transform
RDF transform
REST transform
Template transform
XML transform
Sinks
Conditional sink
CSV endpoint sink
Dataset sink
Elasticsearch sink
Email Message sink
HTTP endpoint sink
JSON push sink
Null sink
REST sink
SDShare push sink
SMS message sink
Solr sink
SPARQL sink
SQL sink
XML endpoint sink
Pumps
Systems
Elasticsearch system
LDAP system
Legacy Microsoft SQL Server system
Microservice system
Microsoft SQL Server system
MySQL system
Oracle system
Oracle TNS system
PostgreSQL system
REST system
SMTP system
SQL systems
Solr system
Twilio system
URL system
Service API
Deprecated features
Databrowser
Databrowser Guide
Authentication and authorization
Configuration file API
Learn
Sesam Training Course
Working in Sesam Projects
Getting started
Sign up
Create your first synchronization
Data Synchronization
Collect
Share
Data Management
Enrich
Connect
Transform
Data synchronization
Customize Extension Points
How to Customize Data Sources
The Microservice system
Microservices & Continuation support
Pricing
Service Level Agreement
Changelog
Home
Sesam Hub
Documentation
Data Management
Data Management patterns
Connect Patterns
Golden property based on priority
Golden property based on priority
ΒΆ
Use
coalesce
.
previous
External merge
next
Golden property based on last updated