So far, you have learned to use KBC to
Connecting various systems together alone makes Keboola Connection a powerful and easy-to-use tool. However, the above steps must be done repeatedly to bring in the newest data available.
Use KBC Orchestrator
Go to the Orchestrations section of KBC, and
click on Get Started Now to create a new orchestration. Assign it a name:
To configure the orchestration, first add some tasks to it:
Continue with Add Task:
The automation tasks are displayed based on what steps of the tutorial you have taken. It is not possible to automate the manual upload. Gone through all parts of the tutorial? Then these are the available steps:
First, select GoogleDrive and then click on the User levels table.
Continue adding all the tasks you want. The following configuration will extract data from the database and Google Drive sheet. After being transformed for Tableau, the data will be written to Tableau Server.
Or, use the next configuration to extract data from the database and Google Drive sheet, transform it for GoodData, and write it to a GoodData project.
The order of certain tasks is important; some must run sequentially and others can run in parallel. That is what orchestration phases are for. Tasks in a single phase are executed in parallel, phases execute sequentially.
To order the phases, grab the triple bar icon on their left. To move a task to a different phase, tick the checkbox on the left. Then go to Actions, select Move selected tasks between phases and assign the desired phase.
In the above configuration, each task is in its own phase. Therefore, this is a very defensive configuration which executes all tasks sequentially.
It can be better arranged by using the Group tasks into phases by component type action:
This will group each of the extractors, transformations and writers into their own phase to follow the common ETL scheme. Then Save the orchestration. If you do not have all the tasks set up at the moment, it does not matter. You can safely continue with the next steps. When done configuring the tasks, go back to the orchestration setting.
In the orchestration detail, you can now see some tasks configured. Run the orchestration manually to test everything works smoothly; click on the Play button in the top right corner and select the tasks you want to run. This creates a background job which executes all the tasks specified in the orchestration. Continue setting up the orchestration in the meantime.
By clicking on Edit schedule, set the orchestration to run automatically at a given time.
It is recommended to also set up notifications. Click on Configure Notifications and then on Edit Notifications in the upper-right corner:
Notifications are sent to selected email addresses. Set at least the error notification: enter your email address and click on the plus sign next to it. Repeat if you want to add another email address. Then click Save.
When an orchestration is run manually, notifications will be sent only to the KBC user who runs the orchestration, not to those specified in Notifications.
Your orchestration job should be finished by now. From data extraction to data writing, you have set up the full pipeline. Any change in your GoogleDrive sheet will automatically propagate up to your Tableau or GoodData project. Or both, if you set it that way.
Having mastered the automation process, you may proceed to an example of doing ad-hoc data analysis part in KBC.