Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database?

45 pts.
Tags:
Cache
Database
InterSystems
SQL Server
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. Fernanda.

Software/Hardware used:
SQL Server 2008 R2 and Intersystems Cachè

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you can get an ODBC driver from Intersystems Cache then you can setup a linked server to the remote systems then yes.  If you can’t get an ODBC driver for it then no.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Can I do a select in SQL Server from a table in another DBMS system?  You can certainly do that, by means of Linked Servers.  However, I have never heard of 'Intersystems Cachè', so I don't know if it will work well as a linked server (probably yes if an ODBC driver exists).
    68,495 pointsBadges:
    report
  • FernandaAraujo
    Thank you Denny. I´m trying to get an ODBC driver. So, cant you tell me the syntax to select a table in another database engine? Like select * from <servername>.<instancename>.<databasename>.<tablename>Thanks in advance.
    45 pointsBadges:
    report
  • FernandaAraujo
    Thank you Carlosdl. Do you know the syntax of the select statement?
    45 pointsBadges:
    report
  • farmer8n

    THis is an example from ORACLE linked server named  MYDATA


    CREATE VIEW [dbo].[mytable] AS
    SELECT * FROM  OPENQUERY(MYDATA, 'select  * from SCOTT.mytable') AS mytable

    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following