Good afternoon Friends.
A question: Does Sugar have an native ODBC driver that can be used? For example, for DBeaver or Power BI to access the Sugar database?
As a DBA for an on-site implementation you can use whatever tools you like/have for your specific database, I don't believe SugarCRM has any particular recommendations.
As a cloud customer you do not have direct access to the database, but I think you can download a backup (I'm not a cloud customer so I'm not familiar with that area)
Having said that, whether you are on-site or cloud, to Interact with the data you should try to limit yourself to Sugar Endpoints (you can create custom ones if needed)
I find you get in a lot less trouble if you stick to those constructs :)