Hi,
if you need to only read the data from the CRM you can use the filtered views, the structure is always Filtered+EntityName, so for account will be
SELECT firstname, lastname FROM FilteredAccount
for the columns name you can use the logical name, in addition they provide fields for lookups, for example you have parentcustomerid, you will have also parentcustomeridname field that contains the primary field value of the parentcustomerid.
If you need to write also data to CRM, you can't update directly the CRM DB but you need to use the CRM WebServices.
My blog: www.crmanswers.net -
Rockstar 365 Profile