Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  t-sql and intersystems cache

Author  Topic  obiron Starting Member 23 Posts Posted - 2009-06-04 : 11:44:48 Hi guys, Has anyone had any experience of querying data held in Cache, from Intersystems? - Cache has an accent on the e so it is pronounced 'cashay' I am trying to build a data warehouse in MSSQL2005 and one of the datasources is a 3rd party application in Cache. googling for the word cache with anything to do with sequel returns loads of links for results chaching which is obvously not what I want. We can get at the tables using the ODBC driver and Access, but I want to be able to get a the tables directly in t-SQL. I think I will need to get the Cache server added to sys.servers - does anyone know what settings are required. Once I have done that, does anyone know how to structure the SQL to query the tables, I am only extracting data with SELECT, there is no requirement to write data back to the Cache system. Obiron