I'm having problems writing SOQL statements to include a number of different objects and creating temporary fields for adhoc querying.

I'm able to do this with a Standard SQL Server database. I'm wondering if it's possible to get READ access to the schema such that I can write a query to create conditionally calculated fields sum((if x=='something',1,0) , perhaps outer-joins, and other complexities.


I think the differences between SQL and SOQL would limit the usefulness of SQL Server Management Studio. You would probably be better off with a tool that directly builds SOQL.

Some options include:

enter image description here

enter image description here

If you really want to use SQL Server management studio, you could use the third party like DBAmp that will make the Salesforce schema appear as a database that you can query. It doesn't use direct SQL. Instead it translates SQL to SOQL. There is also the CData ADO.NET Provider.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.