Datastage Connectivity to Microsoft Directory.

vibwipro · Post by **vibwipro** » Thu May 07, 2015 11:07 am

Hi,

I am having a requirement, where i need to connect to a FoxPro database hosted on a Microsoft directory.

User "infoadm" already given access over MS Dir.

Please suggest me steps to connect and access FoxPro DB through Datastage.

Regards.

chulett · Post by **chulett** » Thu May 07, 2015 12:10 pm

So... by "hosted on a Microsoft directory" you mean it is on a Windows machine, correct? Is that directory mounted (NFS/Samba/whatever) on the ETL server? As far as I know you would need to do that and then you would be able to use ODBC (provided you had the proper driver on the ETL server) to access it. I'm thinking you may be able to use dBase drivers for that... unless you mean Visual FoxPro. You may need different drivers for that. [shrug]

vibwipro · Post by **vibwipro** » Thu May 07, 2015 12:29 pm

Thx Chulett.

Yes It is a Window machine over which FoxPro DB is hosted.

You said "Is that directory mounted (NFS/Samba/whatever) on the ETL server?" What is 'NFS/Samba' is this a freeware ?

Which all drivers i Will be required from ETL perspective ?

We are able to read data .dbf file through ODBC stage. '.dbf" file uploaded to AIX box over which Datastage is hosted. Reading ".dbf" file is fine to me. Only concerns is that :-

How is to connect Window machine over which this Foxpro DB installed.

qt_ky · Post by **qt_ky** » Thu May 07, 2015 1:00 pm

Take Craig's suggestion to your server administrator. They need to help you make the Windows files show up locally on your DataStage server. How? By using NFS or Samba or whatever they normally use for such requests. Then you can use the dBase ODBC driver to read the *.dbf files.