What is Sesam
Features
Documentation
Learn
Pricing
Community
Support
Sign up
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
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: Nested transformations
DTL: Nulls
DTL: Numbers
DTL: Paths
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
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
GDPR platform
Getting started
Platform configuration
Datatypes and purposes configuration
The GDPR data access portal
Developer documentation
Changelog
Service Configuration
General
Environment variables and secrets
Service metadata
Pipes
Sources
Dataset source
Merge source
Union datasets source
Merge datasets source
Embedded source
SQL source
Conditional source
CSV source
RDF source
SDShare source
LDAP source
JSON source
Empty source
HTTP endpoint source
SPARQL source
REST source
Transforms
DTL transform
JSON Schema validation transform
Conditional transform
HTTP transform
Emit children transform
XML transform
RDF transform
REST transform
Sinks
Conditional sink
Dataset sink
JSON push sink
SDShare push sink
SMS message sink
Solr sink
Elasticsearch sink
SPARQL sink
SQL sink
Email Message sink
Null sink
HTTP endpoint sink
CSV endpoint sink
XML endpoint sink
REST sink
Systems
SQL systems
Oracle system
Oracle TNS system
Legacy Microsoft SQL Server system
Microsoft SQL Server system
MySQL system
PostgreSQL system
LDAP system
SMTP system
Solr system
Elasticsearch system
Twilio system
URL system
REST system
Microservice system
Pumps
Service API
Deprecated features
Databrowser
Databrowser Guide
Authentication and authorization
Configuration file API
Changelog
Home
Documentation
Project kickstart
Project kickstart
ΒΆ
Planning a project
Identify master data
Identify master data sources
Identify globals
Connect data types to the globals
Setting up an environment
Subscriptions
Network connectivity
Development environment
Security
Creating a dataflow
Collect
Enrich
Connect
Transform
Share
previous
Quick Reference
next
Planning a project