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
Webhooks
Connectors
Operations
VPN
Durable Data
Notifications
Metrics and monitoring
Bring your own key
Network Policy
Status Page
Software Channels
Multitenancy
Documentation
Building blocks
Streams of entities
Datasets
Systems
Pipes
Flows
Environment Variables
Secrets
Service Metadata
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
Open to extension closed for modification
Rewriting identity pattern
Data management
Time-based masterdata management
Entity Data Model
Data platforms
Sesam in Microsoft Azure
Sesam in Google Cloud Platform
Data synchronization
API Best Practices
Bi-directional synchronization
Connectors
The Connector Contract
Connector configurations
The manifest
The templates
The config.json file
Available connectors
Asana
Bamboo HR
Business Central
Chargebee
CRMOffice
DBpedia
Difi
Exact Online
Freshteam
HubSpot
Invoiced
Keap
Membercare
Monday.com
PowerOffice GO
Sage
Shopify
SSB
Squarespace
SuperOffice
Tidsbanken
Trello
Tripletex
Twelve Data
Uni Economy
Wave
webCRM
Wikidata
Wix
WooCommerce
Xledger
YouTrack
Zendesk
Zoho CRM
Using connectors
Cron Expressions
Developer Extension Points
Custom Data Sources
Custom Data Transforms
Custom Data Sinks
Microservices in Sesam
JSON Pull Protocol
JSON Push Protocol
Non-idempotency
Patterns
Collect Patterns
Authentication schemes pattern
Avoid unnecessary load on source systems pattern
Claims pattern
Combine -all and -event pattern
Continuation pattern
Datatype naming pattern
Datatypes follow the api pattern
Datatypes with list of linked-objects pattern
Establish origin pattern
Handling asymmetry pattern
Keep data in original structure pattern
Make periodic entities from a versioned history pattern
Pagination pattern
Parameterized datatypes pattern
Receive webhook events pattern
Recreate best effort history from a source pattern
Register webhook pattern
Source that only provides delta streams pattern
Source with since support but no deletions pattern
Source with parameterized input pattern
Sporadic empty response pattern
Synthetic properties pattern
Two step collect pattern
Use templates pattern
Verify deletes pattern
Webhook deletion tracking pattern
Transform Patterns
Namespace split pattern
Share Patterns
Capture response with transform pattern
Delete pattern
Duplicate hops block
Exposing data pattern
External reference pattern
Handling asymmetry
Insert pattern
Optimistic locking pattern
Single share pattern
Share template extension points pattern
Update pattern
Use datatype specific operations pattern
RDF Support
Source Datatype Mapping
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
Deprecated features
Databrowser
Databrowser Guide
Authentication and authorization
Configuration file API
Discontinued services
Sesam Talk
Supported systems
Business Central
Hubspot
Poweroffice
SuperOffice
Tidsbanken
Tripletex
Wave
Wix
Concepts
Selective data sync
Merging
Co-existing with other integration services
Counting updates
Re-authorisation
Enhanced Data Security
Becoming a partner
Service Level Objective
Help
Open Sesam
Enhanced data security
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
Project kickstart
Planning a project
Setting up an environment
Creating a dataflow
Quick Reference
Service API
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
Tools
Management Studio
Sesam Client
Management Console
Authentication
Configuration
GDPR platform
Getting started
Platform configuration
Datatypes and purposes configuration
The GDPR data access portal
Developer documentation
Changelog
Connector Tools
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
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
Troubleshooting
next
Planning a project