You've tried this?

select * from [MAS_CER]...[CI_UDT_FAMILY]

Well that's embarrassing, I guess I confused myself because I am able to see [vCI_UDT_FAMILY] in the MSSMS object explorer and access it through crystal reports and didn't realize there are two tables. I appreciate the reply.

Not that it matters, but just for my own understanding, is there a reason there are two versions of the table?

I think the view is for Business Insights Explorer (and not exposed to 64-bit ODBC for some reason).

Along the lines of what Kevin said all the tables starting with "v" or "view" are for Business Insights Reporter but exposed thru the ODBC connection if a certain property is set.

If your Linked Server is pointed to a DSN then in the DSN on the Options tab the Path to Views DLL should point to the Home directory (eg. E:\Sage\Mas90\Home)

But if your Linked Server uses connection string then include this (use your own actual path)
 ViewDLL=E:\Sage\MAS90;

Alnoor - I have a similar requirement, and want to establish a connection from CRM Server to the ODBC Sage 100, can you please share the sample Linked Server values which we can use in our MSSMS SQL.

Right here in the forum you can just search on "Linked Server" and several results will appear. Here is one that references a nice article on SageCRM.com posted by Jeff Richards on how to use Linked Server to connect Sage CRM to Sage 100. It's based on SQL 2008 but still looks very relevant and probably answers your question - https://bit.ly/2Rey1gg

Note in current versions of SQL Server you can also use the OPENQUERY technique. It's valuable if you need to do more than simple SELECTs from your Linked Server. Search on OPENQUERY either here in the forum or google it.

Thank you Alnoor, I was able to create a Linked Server in MSSMS and query the tables. Very helpful documentation. 

Best,

Asjit

Hi Alnoor 

Can you please share a sample sql script for a Stored Proc to update the data in CRM, I am familiar with scripting the Packages and Procedures in Oracle, but the SQL Syntax are lil different. 

Thanks in advance.

AJ 

Sorry Asjit but I'm not a CRM guy and therefore not comfortable advising on how to update any CRM tables. If there's a Sage CRM forum on SageCity, that would be a good place to ask the question.

Thank you Alnoor, Appreciate all the guidance.

Best/AJ