Bringing systems for data loading, manipulation and writing together is what makes Keboola Connection so powerful and easy to use. With extractors, you can fetch data from data sources into Storage. With transformations and applications, you can modify them. With writers, you can send them to destination systems.

The Orchestrator component has two important features:

  • organizing the configured components into logical building blocks or full data pipelines,
  • scheduling automated and repeated execution of those blocks or pipelines.

The former feature of the Orchestrator allows you to define dependencies between different configured components. For example it allows you to specify that a transformation must be run after an extraction which provides the source data for it. You can also specify that two extractions may run in parallel because they are independent on each other. With this, it is possible to ensure that you always work with the latest data available and organize large and complex projects.

The latter feature of the Orchestrator allows you to fully automate the entire data pipeline. That ensures that the destination systems (e.g. Tableau Business Analytics) always contain the latest available data, without any user intervention. Every change to your entry data will automatically propagate up to your dashboard or visualisation project.

See the corresponding part of our tutorial to quickly setup an example Orchestration.