Comment by daemonologist
Comment by daemonologist 2 days ago
As clejack said, "Org silos, security, and permissions" - this is usually the largest single time sink on any project that needs production data.
Related to this is obtaining data in bulk - teams (understandably) are usually not willing to hand out direct read access to their databases and would prefer you use their API, and they've usually built APIs intended for accessing single records at a relatively slow rate. It often takes some convincing (DoSing their API) to get a more appropriate bulk solution.
my experiences are pretty much this. having db access would make my life so much easier.