I'm working with Salesforce data for the first time. The organisation has had it implemented and the data integrated into it using Scribe. We had boatloads of problems getting the daily integration to work properly which it now does only because we ended up having to heavily restrict the period of data that is synced from the company's existing customer/order management system (A hateful system called Access Supply Chain that runs on SQL Server) to Salesforce each night through Scribe.
Because of all the problems we had and the need to restrict how far back the integration would go with data we believe that there will be records missing from Salesforce. To check this I was looking at the raw Salesforce data by using an ODBC connector on the server. I'm able to query the Salesforce tables directly over a linked server.
What I can't see in the Salesforce data are any of the reference numbers that came from the previous (and still active) customer/order management system. It's all Salesforce unique ID strings. Yet those reference numbers are visible on the Salesforce front end so surely they must be in the data somewhere? Can anyone tell me if it's possible to see all the data that sits behind an Opportunity record and an Invoice record from querying the tables directly?