Page 1 of 1

Classic Federation setup

Posted: Fri Jul 20, 2007 12:41 pm
by seanc217
Hi there I will be traveling to a vendor site in August for a POC on the classic federation server product.

Has anyone in the forum used this stage before?

Are there any requirements (libraries etc that need to be added to the dsenv file) to use this stage?

Thanks.

Posted: Fri Jul 20, 2007 12:49 pm
by phanee_k
Hi,
Classic Federation ( Assuming it is Information Integration Classic Federation ) drivers needs to be added to the LIBPATH in dsenv file.
branded odbc libraries should be defined after the classic federation libraries in dsenv file.

Otherwise it will not work.


Thanks

Posted: Fri Jul 20, 2007 2:34 pm
by seanc217
These drivers are installed by default correct?

So I would just need to put the path in the dsenv file.

Thanks for the help.

Posted: Fri Jul 20, 2007 8:44 pm
by phanee_k
Branded Odbc drivers gets installed by default at the time of DataStage installation.

Once you install the classic federation, you have to edit the dsenv file to include the lib directory location of the classic federation in the dsenv file.

This has to be before the branded odbc drivers.


Thanks

Posted: Mon Jul 23, 2007 9:07 am
by seanc217
Hi Thanks for the info, just so I get this straight. There's a client to connect to the classic fed product, like you install an Oracle client to connect to Oracle?

Posted: Mon Jul 23, 2007 10:47 am
by phanee_k
Yes ,
There is a client available from IBM.
But for what purpose are you using the Classic federations.

We tried to use it to extract data from VSAM / Datacom files/tables from mainframes. Performance wise it is very slow .

Thanks,

Posted: Mon Jul 23, 2007 10:54 am
by seanc217
OK thanks for the info.

We are doing a POC with IBM on this. We have data sources in a mainframe we need to access.

I appreciate the info.

Sean