Hi,
For a request from a client, I have built a data transfer tool to transfer data out of NocoDB into postgres for use with an external reporting tool.
If you’re looking to solve the same issue, please get in touch.
Hey, was that from cloud? To give more insight - each base of nocodb is just postgres behind the scenes. So if you want to achieve reporting with this - how are you keeping external posgres in sync ?
Hi,
Yeah it’s all cloud based, the client does not need live data and there is no need to replicate all the data into a reporting database. It’s essentially a data pipeline that reads a NocoDB table and strips out the columns not needed for reporting and loads the data you need into a table ran at a scheduled time