ODBC DRIVER

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)

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_12.0/Integration/Web_Services/REST_API/Endpoints/

or SugarQuery:

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_12.0/Data_Framework/Database/SugarQuery/

I find you get in a lot less trouble if you stick to those constructs :)

FrancescaS

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)

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_12.0/Integration/Web_Services/REST_API/Endpoints/

or SugarQuery:

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_12.0/Data_Framework/Database/SugarQuery/

I find you get in a lot less trouble if you stick to those constructs :)

FrancescaS