Reading Old Progress data via DataStage

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

Reading Old Progress data via DataStage

Post by admin »

Heres a challenge (literally!).

An old DOS-based system here at the office is known as Progress. Its quite old. We have to import this data into our warehouse via DataStage. Documentation is ancient and the Progress database is definitely not current.

Has anyone heard of this database or is anyone aware of any ODBC driver or other method of reading it into DataStage?

Thanks!

Brad Vincent
Data Warehousing with a "health"-y spin
Compuware
c/o The Detroit Medical Center
(313) 966-2176
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

What version of Progress are you having? I know one ODBC for this database, its called Merant ODBC, used to be called Intersolv ODBC.

----- Original Message -----
From: "Vincent, Brad"
To: "DataStage Mailing List"
Sent: Thursday, August 30, 2001 3:43 AM
Subject: Reading Old Progress data via DataStage


Heres a challenge (literally!).

An old DOS-based system here at the office is known as Progress. Its quite old. We have to import this data into our warehouse via DataStage. Documentation is ancient and the Progress database is definitely not current.

Has anyone heard of this database or is anyone aware of any ODBC driver or other method of reading it into DataStage?

Thanks!

Brad Vincent
Data Warehousing with a "health"-y spin
Compuware
c/o The Detroit Medical Center
(313) 966-2176
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

You can download trial version of the driver from www.merant.com. However, the driver is not free and whats worse, as far as i had tried it, it seemed to be extremely slow. Btw. ask Merant for manual if you decide to install it, the driver requires some system changes on client as well as on the server side. The current version oficially supports Progress 7.3 - 8.x

Regards

Jakub Holubec

Technical Consultant

Urbana technologies
Belehradska 79/10
120 00 Prague 2
Czech Republic

Tel.: +420-2-2199 4500
GSM: +420-603-249 438
http://www.urbanatech.cz
http://www.businessobjects.com


----- Original Message -----
From: "Vincent, Brad"
To: "DataStage Mailing List"
Sent: Wednesday, August 29, 2001 12:43 PM
Subject: Reading Old Progress data via DataStage


> Heres a challenge (literally!).
>
> An old DOS-based system here at the office is known as Progress. Its quite > old. We have to import this data into our warehouse via DataStage. > Documentation is ancient and the Progress database is definitely not > current. > > Has anyone heard of this database or is anyone aware of any ODBC driver or > other method of reading it into DataStage? > > Thanks! > > Brad Vincent > Data Warehousing with a "health"-y spin > Compuware > c/o The Detroit Medical Center > (313) 966-2176 > > >
Locked