In this case, the VOLUME of the data and quantity of tables was not the deciding factor even though it accounted for terabytes of data. Rather, the VELOCITY and VARIETY of dynamically adding new data sources and the need for a higher level of security, drove the decision to leverage ODAG.
Sean developed an application using Online Demand App Generation over a subset of tables to prove out the solution. The result was a landing page where, based on the user’s security rights, they could select the data sources – existing and new – and data tables, then simply press a button to “Generate My App”. ODAG executed queries against those data sources and tables, built out the data model and generated the Qlik Sense application. Within seconds, the user had an application for the specific production data they requested, and the management team had the assurance the user could only see data they were allowed to see. The result? We had “humanized” their data in a way they never could before!
The final question for Sean, and the one most people want to ask, is: “How long did it take to build this first version?” His answer: only one week, because he had the in-depth skillset AND the tools/techniques provided with ODAG. Without either of those, this project could have easily taken the customer weeks or months. There’s a bit more work to include more data tables and deploy it out to all end users, but the work of Sean and ODAG has set the stage for the customer to realize the full potential of their data.