How to connect to Paradox or MS Access.(Urgent)

[rohan77]

Hi ,
I would like some info on how to connect to Paradox.
We will need to create a DSN. Which Driver to use to create a DSN? Is it that we need BDE installed on the PC which will have the Driver for Paradox?
IS there any document of how to connect to paradox database through Informatica. I have tried all sort of DSN creation and it has not worked. I have not been able to import a table from Paradox. If any one has been able to connect it properly can you please mail me the procedure.

Thanks and Regards
Rohan

 

[blom0344]

AFAIK these desktop databases are NOT supported. It may be a better idea to use scripting to export table-contents to flat-files and use that as sources. You wouldn't need an DSN in that case ......

T. Blom
Information analyst
tbl@shimano-eu.com