Problem in trying to import source from Paradox DB thru Informatica

[rohan77]

Hi ,
I am having problems in trying to import the source tables from the Paradox DB. I have made the required entry in the powermart.ini file.
PARADOX=EXTODBC.DLL
and I have created the DSN using Microsoft Paradox Driver (*.db). by specifying the Directory where the Paradox files exists.
Then I go to import source table specified there and I do import. I get the source tables without any columns.
Can anyone please let me know how we can connect to paradox database, import the table definition and use it to populate data in the warehouse.

Your help is appreciated.

Thanks and Regards
Rohan

 

[blom0344]

Did you check with INFA if Paradox is a supported database? AFAIK these type of desktop databases (as MS Access) are not supported sources (not with version 5 anyway........)

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