How to set up source connection for Data Downloader from Informix

Posted July 22nd, 2008 by bessie

I want to try to use this tool to migrate my Informix 7.2 database to Oracle 10g. I launched Pervasive DataDownloader from Informix. But I don't know how to setup Source Connection. My Informix database server is on AIX unix box.
The Data Downloader tool is on my Windows box. Which the base connector I should select? How do I connect to my Informix database?

‹ Newest Versions Missing Event Handlers ›

RE: How to set up source connection for Data Downloader from Inf

On July 22nd, 2008 jterrell said:

Hi bessie,

Per the product information page for the Data DownLoader from Informix, the Data DownLoader from Informix supports Informix-Online DS and Informix_SE.

Since your database resides on a UNIX box, in order to connect directly to the database tables, you must have the Informix client software installed and properly configured on the workstation where DataTools is installed.

The procedure for connecting to each version of Informix can be found in the documentation in the Data DownLoader from Informix. Simply click on the Help icon in the button bar to open Help. In the Contents tab, locate the "chapter" entitled "Source and Target Connectors". Expand the list and scroll down until you can see both of the Informix sections. Open and follow the instructions for the version of Informix to which you need to connect.

If you have Informix_SE and cannot connect to the database server for some reason, the alternative is to download the C-ISAM data and index files to your workstation or a Windows server. You can then use the Data Parser for C-ISAM to parse and convert your data to CSV text files. The CSV data can then be mapped to Oracle using the Data UpLoader to Oracle Database.

- Jo

How to setup souce connection to Informix on Unix

On July 23rd, 2008 bessie said:

Hi, Joe,

I installed Informix client ODBC drive on Windows box, and defined ODBC SYSTEM DNS for my informix database.
Now how do I define Database Directory field, Source Database field in Souce Connection tab? The help document doesn't instruct how to select database Directory.

Thanks,

Bessie

ODBC Configuration

On July 23rd, 2008 margie said:

Your database connectivity settings should have been configured when you saved the dns for your odbc driver.

What is informix C-ISAM data

On July 23rd, 2008 bessie said:

Hi, Jo,

What is the C-ISAM data file? In informix database folder, I see there are two type files, one is *.dat file, another is *.idx file. Are those two files used for Data Parser for C-ISAM?

Thanks,

Bessie

RE: What is informix C-ISAM data

On July 23rd, 2008 jterrell said:

Hi bessie,

The .DAT and .IDX files are the C-ISAM files. There should be "matched pairs" of .DAT and .IDX files, and they can be moved from the UNIX box to a Windows server for easier access. Of course, you will need to have access privileges to the server and folder where the ISAM files are moved to.

Also, the .DAT and .IDX files must reside in the same folder in order for the Data Parser for C-ISAM to connect. Information about connecting to the C-ISAM data can be found in the DataTools documentation. I will also send you a PDF document that describes the procedure for connecting to an external dictionary file, if available. The DataTools Data Parsers can apply the structure obtained from a copybook to "autoparse" a flat file, such as an ISAM file.

- Jo