10

I am new to Salesforce and so far I have found three ways to run queries:

  • Developer Console
  • Workbench
  • Force.com IDE (Eclipse)

These work for quick ad-hoc queries but for writing more complex queries e.g. to assess data quality the functionality is lacking. I'd like to have syntax highlighting, line numbering, auto-completion, auto-formatting, etc. I've used Oracle SQL Developer extensively and it would be perfect, but as far as I can tell it can't connect to SFDC without ODBC drivers which are very expensive.

The official Force.com Explorer appears to have been abandoned (Has Force.com Explorer been abandoned?) so that isn't an option. What about the FuseIT SFDC Explorer (http://www.fuseit.com/Solutions/SFDC-Explorer.aspx)? Any other suggestions?

5
  • 3
    If your linked post weren't 3 years old this might almost be a duplicate. My how time flies! How about this one? Does it have to be a free option?
    – Adrian Larson
    Commented Jun 15, 2016 at 15:07
  • @AdrianLarson If it is not free, I would need a convincing argument for my company to pay for it...
    – Math1000
    Commented Jun 15, 2016 at 15:13
  • 2
    It seems that Cloudingo Studio is still using TLS 1.0, which SFDC recently removed support for (help.salesforce.com/apex/HTViewSolution?id=000221207). I contacted Cloudingo support about this issue; currently it will not connect to Salesforce.
    – Math1000
    Commented Jun 15, 2016 at 20:08
  • Wow that's crazy they didn't see that coming and update their product. I bet they have a lot of angry customers...
    – Adrian Larson
    Commented Jun 15, 2016 at 20:09
  • It is a free product so it is not their highest priority...still I have to imagine this was announced a lot time ago.
    – Math1000
    Commented Jun 15, 2016 at 22:21

3 Answers 3

8

There is also a new IDE The Welkin Suite where you can run queries. Not sure about all what you've asked but there is line numbering :) They also have a forum where you can request a new feature here there is chance they implement it in future releases as they release pretty often with new features.

1
  • 2
    Thanks, this looks good as well. I will have to try it out.
    – Math1000
    Commented Jun 15, 2016 at 15:35
2

Other available options:

1 Real Force Explorer.

Real Force Explorer is now branded as Datasert Realforce

Pros:

  • DML operations available within context menu
  • syntax highlighting
  • data export

Cons:

  • lack of auto-completion
  • annoying limits, even for paid versions (pricing page)

2 Illuminated Cloud

Pros:

  • auto-completion
  • line numbering
  • very useful shortcuts
  • syntax highlighting

Cons:

  • No DML operations within context menu
  • no data export

3 JetForcer

Pros and Cons are pretty similar to the Illuminated Cloud (this is also a plugin for IntelliJ IDEA)

4
  • Looks pretty nice!
    – Adrian Larson
    Commented Jul 10, 2016 at 17:48
  • Do you have any affiliation to this product? I believe there is a forum policy about disclosure of such affiliations, though I'm not sure.
    – Adrian Larson
    Commented Jul 10, 2016 at 17:49
  • @AdrianLarson, not really. I've just pasted some of the information from their wiki. I am using this tool instead of force.com explorer. Commented Jul 10, 2016 at 18:24
  • Gotcha. Even if it's disclosing you don't have such affiliation it's probably a good idea when recommending tools/products.
    – Adrian Larson
    Commented Jul 10, 2016 at 18:37
1

There is lightweight application Force.com Explorer, built with Adobe Air, so it is cross-platform. It's main purpose is running queries. https://developer.salesforce.com/page/ForceExplorer

5
  • 1
    Huh, looks like Force.com Explorer wasn't abandoned after all...
    – Math1000
    Commented Jul 2, 2016 at 19:36
  • @Math1000 The linked product page says it was last updated to 0.58A in October 2011. I'd say the Adobe Air version has also been abandoned. Commented Nov 28, 2016 at 19:48
  • @DanielBallinger it still works and I am still using it Commented Nov 29, 2016 at 7:23
  • @VladyslavKushney Great. Has it been updated recently? Newer API versions give you access to more functionality. Commented Nov 29, 2016 at 7:38
  • @DanielBallinger it has not been updated, but I am satisfied with current version. I agree that it is more easy to execute queries from IDE, but Force.com explorer has advantage when you want to access your org's data quickly. You login and it retrieves metadata dynamically. Commented Nov 29, 2016 at 12:04

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .