Smart Data Warehouse

Traditional ETL processes are often slow and clunky requiring significant expertise.

We decided to change that and engineered a smart data warehouse solution that can be deployed faster.

Blazing Fast ETL

Instead of labouring over manual queries for everything, our proprietary import process analyses the data sets to understand the relationships and will auto-configure rules for you.

Once complete, you can then verify these rules yourself or hand-off the task to a subject-matter-expert who can adjust anything required.

This is designed to enable you to start using your data faster.

Schedule & Monitor

Some data sources need to be checked a lot. Others don't.

With Firefly you can set how often we should check each data source. And when a check is performed, we'll put the new data through our automated ETL process so the data is available much faster.

Report Your Way

Firefly has built-in reporting tools that make querying and analysing your data fast and simple.

By employing our K-Store, you can also use natural-language search to query your data. This enables non-technical users to simply type queries like they would in Google and get insights and reports instantly.

What about external tools?
Firefly uses an open data structure, so that you can plug-in tools like Tableau or Business Objects to build custom reports.

More about reporting

New Data Source?
No Problem.

Once Firefly is deployed you can add new data sources in minutes. We'll use our automated ETL process to find common data values and you can decide whether to join them to the relevant rules for the related Data Recipes, so you can get insights in a consolidated fashion from your new data source faster.

Frequently Asked Questions

Is this a data warehouse or a data lake?

Actually Firefly can be both.  Using smart data solutions and data recipes Firefly can store data and documents, structured or non-structured to create a Data Lake.  For those who require a more prescribed traditional Data Warehouse Firefly can easily and quickly build and maintain it.

Is my data secure?

Yes, your data is secure and may be encrypted if you require. Firefly can also integrate with your own internal security systems and techniques such as Single Sign On.

What does Firefly do that's different to a traditional ETL?

Firefly is an end to end solution – Firefly manages the extraction of data, transformation and loading to optimise processing – ensuring data is made available to users quickly. By managing all aspects of the ETL (Extract Transform and Load) processing it can optimise it to prevent duplicated data processing, only processing data changes when they occur and allowing frequent updates to be completed. This provides near-time reporting options and also reducing processing loads as each process handles a smaller amount of change.

Interested?
Let's schedule a demo