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è
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!