Connection to Cache

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Connection to Cache

Post by admin »

Has anyone used datastage to export to Intersystems Cache. Was there
any issues.

Regards

David Jordan
Managing Consultant
david@dacono.com.au

Dacono Holdings Pty Ltd
Business & Technology Consulting
PO Box 909
Lane Cove
NSW 2066
Australia
Ph 61 2 9418 8329
Fax 61 2 9427 2371
www.dacono.com.au
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Connection to Cache

Post by admin »

DataStage does get along nicely with Cache (at least it did a couple years
ago).

InterSystem has there own ODBC drivers for Cache (at the time, for SUN and
NT).

The NT ODBC drivers worked fine with an NT installation of DataStage.
The SUN drivers were written to the DataDirect "standards", so they also
worked nicely with DataStage since that is the driver manager that DataStage
uses on UNIX.

IWAY also has a connector to Cache and Ascential could sell it to you if you
go that direction.

The ODBC drivers from InterSystems worked fine for us. And ODBC is their
"native" access method from the "outside".

It's a cool database, and pretty fast.

-Craig Rouse
Griffin Resources, Inc
griffin.resources@att.net

-----Original Message-----
From: djordan [mailto:djordan@ozemail.com.au]
Sent: Tuesday, December 09, 2003 5:00 PM
To: datastage-users@oliver.com
Subject: Connection to Cache



Has anyone used datastage to export to Intersystems Cache. Was there any
issues.

Regards

David Jordan
Managing Consultant
david@dacono.com.au

Dacono Holdings Pty Ltd
Business & Technology Consulting
PO Box 909
Lane Cove
NSW 2066
Australia
Ph 61 2 9418 8329
Fax 61 2 9427 2371
www.dacono.com.au
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Connection to Cache

Post by admin »

DataStage does get along nicely with Cache (at least it did a couple years
ago).

InterSystem has there own ODBC drivers for Cache (at the time, for SUN and
NT).

The NT ODBC drivers worked fine with an NT installation of DataStage.
The SUN drivers were written to the DataDirect "standards", so they also
worked nicely with DataStage since that is the driver manager that DataStage
uses on UNIX.

IWAY also has a connector to Cache and Ascential could sell it to you if you
go that direction.

The ODBC drivers from InterSystems worked fine for us. And ODBC is their
"native" access method from the "outside".

It's a cool database, and pretty fast.

-Craig Rouse
Griffin Resources, Inc
griffin.resources@att.net

-----Original Message-----
From: djordan [mailto:djordan@ozemail.com.au]
Sent: Tuesday, December 09, 2003 5:00 PM
To: datastage-users@oliver.com
Subject: Connection to Cache



Has anyone used datastage to export to Intersystems Cache. Was there any
issues.

Regards

David Jordan
Managing Consultant
david@dacono.com.au

Dacono Holdings Pty Ltd
Business & Technology Consulting
PO Box 909
Lane Cove
NSW 2066
Australia
Ph 61 2 9418 8329
Fax 61 2 9427 2371
www.dacono.com.au
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Locked