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?

  • 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 Jun 15 '16 at 15:07
  • @AdrianLarson If it is not free, I would need a convincing argument for my company to pay for it... – Math1000 Jun 15 '16 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 Jun 15 '16 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 Jun 15 '16 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 Jun 15 '16 at 22:21
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.

| improve this answer | |
  • 2
    Thanks, this looks good as well. I will have to try it out. – Math1000 Jun 15 '16 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)

| improve this answer | |
  • Looks pretty nice! – Adrian Larson Jul 10 '16 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 Jul 10 '16 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. – belford Jul 10 '16 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 Jul 10 '16 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

| improve this answer | |
  • 1
    Huh, looks like Force.com Explorer wasn't abandoned after all... – Math1000 Jul 2 '16 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. – Daniel Ballinger Nov 28 '16 at 19:48
  • @DanielBallinger it still works and I am still using it – Vladyslav K Nov 29 '16 at 7:23
  • @VladyslavKushney Great. Has it been updated recently? Newer API versions give you access to more functionality. – Daniel Ballinger Nov 29 '16 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. – Vladyslav K Nov 29 '16 at 12:04

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.