ROSIE

Streamlined Integration Engine

ROSIE enables any organisation moving to the cloud to move data more quickly and reliably than using the cloud providers’ tools.

Move data to the cloud, faster

Speed up your move to the cloud, build a data lake or create a data warehouse faster with ROSIE

Tech-agnostic

Lightweight data transformation engine written in Python for transforming and processing existing on-premise databases for a cloud platform - Google, Azure and AWS.

Python module

Run as a standalone from the command line, or load as a Python module into another Python wrapper.

Use SQL

No need to use any platform-specific coding languages (only SQL).

Lower costs

No additional run costs of a cloud ETL - only platform compute costs.

Get a demo

Please fill your details in below and we will be in touch to arrange a demo of our solutions.

Benefits of ROSIE

Quick, reliable, effective cloud migrations using only SQL

Only SQL needed

Only SQL skills are required to create the YAML files, reducing the need for expensive extra programming knowledge.

Cloud processing

All data processing is implemented in the cloud so data is not pulled from the database and into the container’s memory.

Full logging features

Logging is automatic.

Python stack

Easy to integrate into a Python based stack.

Ensure data quality

Easy to build data quality tests.

Create CI/CD rules

Easy to build CI/CD rules.

How it works

Label

Step one

ROSIE is triggered to fetch a YAML file by, for example, Airflow.

Label

Step two

The YAML file contains sequential tasks written using SQL or shell-based commands.

Label

Step three

The tasks are implemented dynamically which can include conditional logic and CI/CD rules.

Data is moved and transformed from the source to the target location and is not routed via ROSIE. All data processing happens in the database.

Label

Step four

Summary logging information is returned to ROSIE, such as row counts.

2019-01-01

Step five

Test outcomes and run time information is logged automatically.

"All in all, ROSIE has been a great addition to the program and something I am glad we have. It is a huge asset and allows us to evolve rapidly."

Tech lead at a major online gaming company

Get a demo

Please fill your details in below and we will be in touch to arrange a demo of our solutions.