1

I am looking to find the a tool that lets end users with no database knowledge and SQL experience the capability to create reports that provide both raw data and aggregate information.

Requirements are: Oracle database - this is graph like with events(unique table structures), people and locations linked via a single central table. Each event can have multiple child tables.

We need to be able to create a range of logic models on top of this covering specific events and roles that people play, as well as models running between different events.

We need to fully support out joins in the logic models - we have a lot of gaps in child objects and a lot of occasions when we need to see these gaps alongside the data that is present.

Query parameters need to support and/or at multiple levels via an easy to use interface.

~80% of reports will need to contain record level data as this is the most common use of a reporting tool for the organization. Further work is carried out in Excel most of the time, however this is slowly changing but culture is like on oil tanker on this.

This should really be fully web based - both for the creation of the models and running of reports. The database and application are hosted off site and we have a large number of report creators who would need to access via browsers.

It should also support SQL for a small number of power users.

We do already have MS SSRS running against an MI warehouse and OLAP cubes (via SSAS), however these are very poorly designed (I suspect by someone who had never delivered OLAP before) and do not allow the record level reporting. I am inclined towards the SQL Server Report Models but as they are de-supported I am not totally convinced on sticking down this path.

As ever an open source/low cost solution would be a good consideration....

  • Are you looking for something like Tableau? If so, we have recommendations for free alternatives, if you search this site – Mawg Sep 20 '18 at 10:41
1

You should probably leave your MS-SSQS Datawarehouse to your database admin and link it with an ODBC connection to something more user friendly to handle your datamarts like airtable. Zapier integration to sql-server is an option found here.

I don't know what your data looks though its entirely possible you could do everything from airtable though

  • Really I think as @Kagerjay says, Airtable can be the best solution. – Josem Mar 22 '18 at 8:12
  • But, don't forget to check the pricing – Mawg Sep 20 '18 at 10:42
0

Metabase with Oracle Driver might be an option here. It allows you to both write SQL and create a chart through a step by step wizard.

It's open source and you can have it up and run, probably in less than 5 minutes. Further configuration, of course, is required and I highly suggest to configure it to use MySQL as it's backend database.

https://metabase.com/docs/v0.21.1/administration-guide/databases/oracle.html

enter image description here

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.