Tuesday, July 19, 2011

Salesforce Sales Objects Schema in SQL Server

I've been working towards exporting the Salesforce Schema via the Partner API to SQL Server. The current export is starting to look a lot like the Salesforce supplied ERD.

Exported Salesforce Core Sales objects schema in SQL

Note that most of the Status/Stage objects are disconnected when using the Partner API as the data has been denormalized. Also, the Partner object isn't exposed via the Partner API.