I have a question concerning the limitations of the database size of a Triggre application. We want to build an application with which we can GET information from different other applications (multiple ERP/administrative applications).
This information needs to land in Triggre so we can do calculations or other mutations with it. With the data in Triggre we want to create rapports of the data (our own merged tables - with data from different apps) or we want to provide different BI opportunities (or send it to Power BI).
You could imagine that we need quite a lot of tables for this application, especially when the amount of applications that we want to fetch data from are increasing.
We currently started with one application, and we already notice that our DB structure is becoming quite big. I am wondering how others perceive this, and maybe if we can do something about this to maintain a certain level of overview.