Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database?
I need to access data in an Intersystems Cachè Database from an SQL Server database. Can I do a select in SQL Server from a table in another DBMS system? How can I do it? Data is in a Cachè Database.
I was thinking about creating a view in my SQL Server database that retrieves data from a Caché database but I don´t know how to do it.
Can somebody help me?
Thanks in advance.
Software/Hardware used: SQL Server 2008 R2 and Intersystems Cachè