Reading Foxpro & dBase 4

Post by **admin** » Tue Jun 19, 2001 2:56 pm

Brad - You can use the ODBC Stage and setup a DSN. That should do the trick.

-----Original Message-----
From: Vincent, Brad [mailto:BVincent@dmc.org]
Sent: Tuesday, June 19, 2001 10:57 AM
To: DataStage Mailing List
Subject: Reading Foxpro & dBase 4

Heres a quiz question. Weve been approached to read files from systems with data in Foxpro as well as dBase 4 format. Does DataStage have plug-ins available to do so?

If not, how have others read in this type of data?

Thanks!

Brad Vincent
Data Warehousing with a "health"-y spin
Compuware
c/o The Detroit Medical Center
(313) 966-2176

Post by **admin** » Tue Jun 19, 2001 2:57 pm

Heres a quiz question. Weve been approached to read files from systems with data in Foxpro as well as dBase 4 format. Does DataStage have plug-ins available to do so?

If not, how have others read in this type of data?

Thanks!

Brad Vincent
Data Warehousing with a "health"-y spin
Compuware
c/o The Detroit Medical Center
(313) 966-2176

Post by **admin** » Tue Jun 19, 2001 3:00 pm

Setup an ODBC connection to each data source and use ODBC to reference the data. Since Microsoft owns Foxpro it provides drivers for this format.

Ray Daignault
----- Original Message -----
From: "Vincent, Brad"
To: "DataStage Mailing List"
Sent: Wednesday, June 20, 2001 12:57 AM
Subject: Reading Foxpro & dBase 4

: Heres a quiz question. Weve been approached to read files from systems
: with data in Foxpro as well as dBase 4 format. Does DataStage have plug-ins
: available to do so?
:
: If not, how have others read in this type of data?
:
: Thanks!
:
: Brad Vincent
: Data Warehousing with a "health"-y spin
: Compuware
: c/o The Detroit Medical Center
: (313) 966-2176
:
:
:

Post by **admin** » Tue Jun 19, 2001 3:03 pm

Yes, I read this type of data. You need to use ODBC. Get the latest version that you can find of the Microsoft Visual FoxPro ODBC driver. I know that at least version 6 exists, perhaps later. It is bundled as part of MDAC.

Im hoping your DataStage server runs on NT or Windows 2000. I dont know if there are ODBC drivers for this for Unix.

Good luck,

David Barham
Information Technology Consultant
CoalMIS Project
Anglo Coal Australia Pty Ltd
Brisbane, Australia
e-mail: David.Barham@anglocoal.com.au

This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender by return e-mail, and delete this e-mail from your in-box. Do not copy it to anybody else.

-----Original Message-----
From: Vincent, Brad [SMTP:BVincent@dmc.org]
Sent: Wednesday, June 20, 2001 12:57 AM
To: DataStage Mailing List
Subject: Reading Foxpro & dBase 4

Heres a quiz question. Weve been approached to read files from systems with data in Foxpro as well as dBase 4 format. Does DataStage have plug-ins available to do so?

If not, how have others read in this type of data?

Thanks!

Brad Vincent
Data Warehousing with a "health"-y spin
Compuware
c/o The Detroit Medical Center
(313) 966-2176

Post by **admin** » Tue Jun 19, 2001 3:23 pm

Its possible that there are available industry ODBC drivers for these, in
which case you could use the standard ODBC stage. Unix DS sites may have
a tough time finding drivers, but chances are increased in the NT DS world.

Ernie

-----Original Message-----
From: Vincent, Brad [mailto:BVincent@dmc.org]
Sent: Tuesday, June 19, 2001 10:57 AM
To: DataStage Mailing List
Subject: Reading Foxpro & dBase 4

Heres a quiz question. Weve been approached to read files from systems with data in Foxpro as well as dBase 4 format. Does DataStage have plug-ins available to do so?

If not, how have others read in this type of data?

Thanks!

Brad Vincent
Data Warehousing with a "health"-y spin
Compuware
c/o The Detroit Medical Center
(313) 966-2176