In one sentence: I am looking for a solution to structurally present loads of data from different sources to different customers.

Structurally present means: I don't need a one-page-report containing some graphs and tables. I need to provide a website-structure with different areas, that are connected.

Loads of data means: We produce around 1 GByte of data per day, compressed it is around 0,25 GByte (mainly working with MongoDB here). Data will be refreshed every hour and needs to be transformed in different ways. So I also need ETL-functionality to implement calculations or structural changes.

Different sources means: The same as above. I need to set up an ETL-process and I need an interim dataware-house / data-lake that holds transformed data.

Different customers means: I need a decent tennant-management. At least I want to define different roles. it would be perfect if I have groups and hierarchies, too.

There are two no-gos: Although I am willing to pay for it, 10k per month or similar is definitly to much. The software needs to run in my own servers. Windows-based Software is a no go.

What I already tried:

  • KnowageBI does not have an ETL module, and it is not clear, what ETL module I could use, but this is the first tool that actually allows me to build a website-like structure, so it's the best candidate for now

  • ReportServer/BIRT does not come with an own data warehouse and it's more a one-page-reporting solution

  • JasperSoft does not come with an own data warehouse, it does not properly run on Windows 10 (makes it hard to test) and it does not support RESTful services, adding it as a plugin is not possible, neither to the Studio nor the Tomcat-Package, also pushing anything from the studio to the reporting server is not possible, this tool already cost hours of work and the only outcome is blank nerves

  • Looker/Redash looks awesome but definitly comes without a data warehouse and it looks like it is not the correct way to build a website-like structure, same for Redash, so even using Fivetran or any other 3rd-party-tool maybe wouldn't help

  • DundasBI comes for Windows only, it's a no-go, though it looks great

  • Qlik - no offense, but the webpage offers a couple of tools and dozens of buzzwords, it's almost impossible to get hard facts or even figure out, what tool would be the one I need cheers, and apparently it does not run on my own premise

  • Tableau/Sisense - too expensive

If I have to summarize it, I would say I need an interface Google Analytics offers. But for my own.

Your Answer

By clicking "Post Your Answer", you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.