DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message

Joined: 26 Aug 2008
Posts: 294

Points: 5436

Post Posted: Mon Dec 03, 2018 5:31 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi everybody.

DataStage here is located in a cluster where Oracle can´t be installed, so alternatively we are using ODBC Connector to read Exadata Database.

We always have to inform the "conductor name" at the ODBC Connector: "Stage/Advanced/Node Map Constraint", otherwise it can´t find the "odbc.ini".

The thing is, when we choose the "Sparse" Lookup type, the option "Node Map Constraint" is disabled at ODBC Connector.

We are having the following warning:
"Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed"
(Yes, the column names are correct, according to input - It might be a problem with the reading of "odbc.ini ")

And then, the following error:
"The connector could not establish a connection to data source ORACLE2 using user hadoopetl."

Does anybody have any tip?
Is there any environment variable for this purpose?

Thanks in advance.

Best regards,

Joyce A. Recacho
Săo Paulo/SP
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours