Link SuiteCRM to MSSQL tables for Data Views

I am looking for a way to link SUITE CRM to existing data from MSSQL to create/import views and data for objects such as customer lists, company product SKUs, Contacts, …ect.

Also I want this to be a Cached Live Link, not a store and copy into the installed MySQL database on the CRM Server.

Has anyone worked with anything like that before?

we are in that situation.
we use iframe to do the work:
we do this for sales history report,
new RMA creation linked to a case

the way we do this:
we build url field within the module to link with module id
we also added custom buttons to opportunity which open another browser tab for a ERP quote module having much information already filed in.

we do not duplicate data, everything is linked…

almost easy to do…