Support for Salesforce Chatter with Salesforce ODBC driver

[mwalton@microstrategy.com]

The following came to me from an engineer on our side. Do you know of any plans to support Salesforce Chatter and if not can we log an enhancement? Salesforce Chatter uses the, ‘FeedTrackedChanges’ object to track history about any changes on particular Entities (accounts, opportunities, contacts, etc)). This is currently not something that you can ‘query’ directly (query method is not supported on this object). Thus the ODBC driver does not expose this object for querying. However we can query these objects indirectly through the use of parent-child relationship queries. This is a special concept Salesforce has introduced with Chatter to prevent processing large sets of data if these objects (FeedTrackedChanges, FeedComments, FeedLikes) were to be queried directly. I believe this would be some sort of an enhancement to the driver to allow these types of indirect queries in SQL (something to the effect of SQL - SELECT a11.CreatedDate, a12.FieldName, a12.NewValue, a12.OldValue from Opportunity a12 join FeedTrackedChanges a11 on (a12.ID = a11.ParentID) Order By CreatedDate DESC gets converted to SOQL - SELECT CreatedDate, (select FieldName, NewValue, OldValue from FeedTrackedChanges) FROM OpportunityFeed Order By CreatedDate DESC).

Continue reading...