Has anyone been able to connect to locally hosted postgres DB that Matillion creates during install? I'd like to make that operational data more visible and use dashboarding tools over this operation data store.
Is the only solution to configure Matillion to use an external DB provider instead of using a locally hosted DB? https://documentation.matillion.com/docs/1211666
Hi @MichaelBlack,
I would definitely steer away from connecting directly to the Matillion database especially when trying to do dashboarding over it. There are several reasons for this. If you have dashboards pounding the Matillion database, there is a very good chance that it will affect the performance of Matillion itself. Another very good reason not to hit the database directly is that when you go to upgrade your Matillion version the next time, there is a high possibility that your dashboards will stop working and you will have to rework them to make them functional again after each upgrade. This is because the database schema that Matillion is using could change with each version depending on re-engineer work, features, or bug fixes.
You're best bet is to use the Matillion APIs to offload the data you want to report on to a table or set of tables and then do your dashboarding from there. Matillion's API's don't change even when the Matillion database changes with upgrades.
Hopefully this helps shed some light. Please let me know if I missed something to your question. Thanks for posting!