I’m getting a little frustrated in order to get access to my data that is stored in Manager. I know that I can copy it in Excel, export It through batch create, etc etc but since my business, fortunately, is growing I would like to get rid of Excel for reporting and use a BI tool.
I tried the hypothesis to dump data through restful api but I cannot have access to the big transaction table which is fundamental for any kind of analisys. It would be like rewriting Manager from scratch.
Custom reports cannot be used since they are not accessible by adding .JSON to the url. And also, custom reports don’t show UUIDs of the various tables so they cannot be used for additional querying outside manager.
Adding .json to customer list show only fields that are viewable by screen and not other custom fields and, on the other side, custom reports show only customers involved in a transaction again without UUID.
This new API by url don’t support basic authentication.
Report transformation doesn’t have access to all the data viewable in custom reports and don’t support new API, ie adding .json.
The promised access to data through JDBC is in the air since 2017 like a dump in mysql or sqlite (not in glorified version like it is today which is useless).
We have tenths of instruments and no one fully works from beginning to the end and it is clear that any kind of report developed inside Manager will not have one tenth of the functionalities that a specific BI platform like Metabase can provide including the possibility to combine data of different databases, charts etc etc.
All that said, I am asking for a complete solution to this endless issue with an organic tool that:
- provides a standard authentication system
- provides data in a standardized and tabular format accessible by common BI software (SQL, YAML, CSV)
- provides all useful data, ie the big transaction table with all the UUIDs (of the transaction but also of the connects tables like of the clients, suppliers, Inventory items) and all the ancillary tables with UUIDs (clients lost, suppliers list etc etc)