Page 1 of 1
Teradata Connector error
Posted: Wed Mar 16, 2011 6:50 am
by vasubabu
Hi,
I am not able to connect the terdata through Teradata connector stage.
and not able to import the metadata for teradata from Plugin as well.
I am getting the fallowing errors as
1.When connecting through teradta connector stage "error loading connector library cctera.dll.The specified module could not be found".
2.when importing through the plug in "Unable to initialise the plg in"
But i am able to connect thriugh ODBC and able to imprt the metadata using DSN.
do i need to set any properties to import through plug in and to connect through teradata connector stage?
Please share your thaughts on this.
Posted: Wed Mar 16, 2011 3:58 pm
by ray.wurlod
Your jobs can't see the connector library cctera.dll (which is not used by the ODBC driver). You need to find this library and make sure that its parent directory is included in the shared library search path of the user that executes DataStage jobs.
Posted: Wed Mar 16, 2011 4:25 pm
by PaulVL
Did your Teradata DBA install the Teradata tools / drivers on your server?
Posted: Wed Mar 16, 2011 7:39 pm
by ray.wurlod
... sometimes referred to as the Teradata Utilities Foundation (TUF). Check your DataStage manuals (Connectivity Guide for Teradata) for current naming.
Posted: Thu Mar 17, 2011 11:00 pm
by vasubabu
Hi Ray,
Thanks for the reply.
I can see this cctera.dll file in two places under this paths
1. "C:\IBM\InformationServer\Server\DSComponents\bin"
2."C:\IBM\InformationServer\Server\StagingArea\Installed\TeradataConnector\Server\windows"
Are these the correct paths for this file or do i need to place this file in some other directory.
Please advice me.
Posted: Wed Nov 23, 2011 1:26 pm
by RajVenugopalan
We are also getting the same error message. Is there any resolution to this issue?
Posted: Fri May 13, 2016 5:06 am
by Pikty
Hi there,
I'm running under PX 8.7 and I'm facing the same error message:
"Error loading connector library cctera.dll.The specified module could not be found".
Could you help to fix this issue
I can see this cctera.dll file in two places under this paths
1. "C:\IBM\InformationServer\Server\DSComponents\bin"
2."C:\IBM\InformationServer\Server\StagingArea\Installed\TeradataConnector\Server\windows"
The stage Teradata exists in the palette
What do you suggest to do ?
Thanks in advance for your help guys
Posted: Fri May 13, 2016 6:22 am
by chulett
Ray noted the resolution in his very first reply.
Posted: Fri May 13, 2016 6:47 am
by Pikty
Hi I can not see Premium Messages unfortunately - Are you able to share please ?