Keboola Data Connection.

ETL in cloud

Use our user-friendly UI or talk directly to our APIs.

Don’t worry about the data structure, cleanness. Don’t wait months and years for your colleagues to fix it in primary systems. Connect to it, bring it into your environment and work around it. Be in control!

Blend data and increase its value.

Collaborate with others in an open and safe environment.

SQL, Python, R for normalisation, cleaning & modeling.

Keboola Connection Architecture

Check out our full code in Github. Fork it. Play with it.

Extractors

Over 100 extractors ready out of the box.

No programming is necessary. Extractors from marketing applications to finance, with own User Interface.

Database, APIs, ftp, CSV, spreadsheets.You name it, we've got it.

Use Generic Extractor and connect to thousands of REST APIs with just a simple JSON configuration.

Full list of extractor

Transformations

Modify your data. Clean it, blend it and put it back to Storage.

Data is picked from Storage, manipulated and then stored back again. Transformations can be created by writing a free-form script in SQL, R and Python.

We provide you with a sandbox to experiment in without worrying of losing critical data. SQLDep.com is integrated for large SQL visual debugging.

Learn more

Data is never clean. Prepare it for your analyses better and faster. For instance, our Geo Augmentation helps you clean addresses. If you need an app we don't have, bring it in. The system is fully extensible.

Writers

Deliver output data into systems and applications where it gets consumed.

Writers take the enriched and processed data, help
to identify and describe it, and load it into its final destination.

Some of the most popular writers currently supported are GoodData, Tableau, YellowFin, Redshift, Oracle database, Dropbox, Amazon S3, MySQL, ElasticSearch or Google Drive.

Learn more

Extensions

Extend Keboola Connection with arbitrary code to extract, manipulate or write data. Or, go to our App Store and choose ready-to-deploy analytical applications written by others.

Creating your own simple Custom Science application is easy and takes only a few minutes. Or, use Docker for maximum flexibility, and we will run it for you. We take care of the billing, too.

Learn more

Storage

Manage everything related to storing and accessing data.

As the core of Keboola’s architecture, Storage is a layer on top of database engines that we use as our backends: Snowflake, MySQL and Redshift.

Storage API provides Keboola Connection components and 3rd party applications with easy access to all required functionality while shielding them from the complexities that are irrelevant to the task at hand.

Enjoy the comfort of using Keboola’s Storage, or connect your own remote storage.

Learn more

Orchestrator

Make your large and complex projects fully automated.

Run a data extractor or any other component when and how often you want. Don’t like our scheduling? Write your own.

Think of ETL as a managed service. Your team will focus only on value creation and real business problems, instead of menial and routine tasks of data mapping and hygiene.

Learn more

All Your Business Data in One Place

Integrate new data sources with unexpected ease and keep only the data that really matters. Clean it effortlessly, analyse it, share it without limitations, and finally, visualise it in the BI tool of your choice.

Watch a demonstration of enriching Salesforce data with Mailchimp.

Do you want to dive in more? Check out these links:

https://help.keboola.com

https://developers.keboola.com

Geek blog: https://500.keboola.com