Re: InterSystems Cache database connect
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Mon, 01 Jun 2015 14:33:13 -0400
Message-ID: <556CA569.7070902_at_yahoo.com>
On 06/01/2015 12:15 PM, Jeff Chirco wrote:
> Does anyone happen to have any experience with connecting and getting
> data from a InterSystems Cache database. We need to pull data from
> our Avaya phone system into our Oracle database and it runs this Cache
> database. If you have any experiences or suggestions that would be
> very helpful. It looks like it supports ODBC so that is where I will
> start.
>
> Thanks,
> Jeff
Date: Mon, 01 Jun 2015 14:33:13 -0400
Message-ID: <556CA569.7070902_at_yahoo.com>
On 06/01/2015 12:15 PM, Jeff Chirco wrote:
> Does anyone happen to have any experience with connecting and getting
> data from a InterSystems Cache database. We need to pull data from
> our Avaya phone system into our Oracle database and it runs this Cache
> database. If you have any experiences or suggestions that would be
> very helpful. It looks like it supports ODBC so that is where I will
> start.
>
> Thanks,
> Jeff
The method I usually used in cases like this is unload to a CSV file and SQL*Loader to Oracle. Almost any database supports something like:
SELECT * FROM PHONES INTO OUTFILE '/tmp/phones.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';
This is MySQL syntax. I have never worked with the Cache database, so I don't know which kind of syntax it uses, but even if it's a Perl script, there shouldn't be a problem. The only thing to be careful about is the sequence of the table loads, to observe the referential integrity and load the parent tables before the child tables. ODBC implies some kind of connection between the database, which can be a pain to set up.
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 01 2015 - 20:33:13 CEST