Two new discoveries

posted Nov 7, 2010, 12:08 PM by Ezra Kenigsberg   [ updated Nov 9, 2010, 10:25 AM ]
What have I learned over the past week?
  1. Salesforce has a weird data-security backdoor: APIs 7 and earlier ignore Validation Rules.  This means API-enabled users can push bad records into Salesforce using, say, Excel Connector, and there isn't a thing administrators can do about it.  If you think this is a problem--and I do!--I encourage you to vote for this idea.  Let me know if you can think of some other way of preventing users from doing this.
  2. There's a funky tool out there called SuperCell that's like Apex Explorer or Explorer, but can also save queries, export query results to Excel, and browse object & field attributes.  (The paid version looks like an Excel Connector replacement.)  I prefer Synchronizer, but I'm biased!
Thanks to Symantec's Brian Driver for pointing out #1 to me!