Keboola Connection
Data Integration & Preparation Platform

Agile and open data integration framework.
Intuitive and user-friendly environment for working with your data.

Basic Framework of Keboola Connection:

Data extraction, preparation, cleaning, warehousing, integration, enrichment and loading.

3rd party components can be added at all stages of the process. This is best ilustrated by our Machine Learning or Data Augmentation components (Weather, Geo, Basket Analyses, etc.), seamlessly integrated within one environment.

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.

Sustainability
and Scalability

Keboola Connection grows with your business and adapts to your changing needs. No data is too small or big. You get to leverage the AWS cloud-based platform and only pay for what you really use.

Advanced Analytics
and Data Science

Keboola Connection is a marketplace for ready-to-deploy analytical applications. The open and agile environment fits companies of all sizes and shapes.
It enables both internal teams as well as experts to collaborate with partners and third parties.

Full Control and Automation

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

Watch a demonstration of enriching Salesforce data with Mailchimp.

Flexibility. Extend and Hack.

No matter what product you are using, one day it will not be enough and you will want to extend it. Bring in new sources and write you own custom specific features. Keboola Connection is designed for that!
Fully in Docker: extend any part you wish.

Augmentation

Data always comes unclean. Let us help you prepare it for analyses better and faster. For instance, our Geo Augmentation helps you clean addresses. Do you need a different app and we don't have it? The system is fully extensible. Bring your favourite apps in.

REST Extractors in 1 Hour

No need to write special extractors. Use our Generic Extractor and configure it. It connects to hundreds of thousands of APIs with just a simple JSON configuration.

Keboola Connection Architecture

Extractors

Get all required data from various sources into one place.

Typically, they connect to APIs of external services. But they can also connect directly to an arbitrary database, or process incoming e-mails.

No programming is necessary. More than 70 custom-built extractors, from marketing applications to finance, with own User Interface.

Clients with development resources can create their own Generic Extractor for implementing extractors for services with REST API.

Learn more

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

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

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 extensions 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

Scheduler/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.

Learn more

When You Need More Skills

Custom Science

Do you wish to work with external data scientist teams, but don't want to share full access to your platform?

Give them access to clean data in Keboola Connection out.bucket and let them create a data frame with one simple command. Create a model, write it to their private GitHub and then automatically connect it back to your project. Run it automatically on a daily basis, so your models stay accurate.

Data Science as a Service

You've cleaned your data, transfered it using SQL, applied basic Python predictions and your users are happy. Then come specific requests: "We need to do NLP on unstructured data," or "We want to personalize our website for each customer, build the model in KBC and then write it to the Elastic production server. But we don't know how to do AI".

For this purpose we've developed our market place with 3rd party applications. You can find and apply right away things like NLP from Geneea, personalize your website using your accounting, CRM and advertise with the help of Recombee, and much more.

Learn more

You want to dive in more? Check out these links:

https://help.keboola.com

https://developers.keboola.com

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