Junior Member
Hi everyone. I am new here and, as well, I am new to SalesForce DC I am building a user friendly reporting tool for Salesforce with a datamart so you can pull down your SFDC data locally and report off of it alone or in conjunction with data from one or more other in house database systems. I have searched high and low on the SFDC site and for the life of me I can not find a simple list of the tables with their fields, lengths, and datatypes. Figuring them out one at a time will get old fast. I don't suppose anyone here could point me in the correct direction? Thanks in advance! Daniel
Administrator
Daniel that was my hardest thing to learn too when I started working with Salesforce and the API.
What type of database are you using? If it is Oracle or MySQL, I have a tool that will create a complete schema of our salesforce instance right here on this site that you can download and run, in php, on your localhost or web server.
Hope that helps
~Mike
Junior Member
Hi Daniel,
The Standard Objects page is a good starting point: Standard Objects
You may also find the Entity Relationship Diagrams useful:
Data Model
Regards,
toivo
Posting Permissions
Template by Bluepearl Design
LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks