How to fix [Informatica][ODBC Oracle Wire Protocol Driver] Optional feature not implemented

[Informatica][ODBC Oracle Wire Protocol Driver] Optional feature not implemented

You may get this error while trying to Preview data on Target in a Mapping Designer. I have also seen the same error from Source Qualifier Transformation while applying SQ properties. Let’s see how to fix this error. This is a part of ODBC Data Source configuration, just follow the steps to fix the Issue. 

Error while trying to Preview data on Target
Go to Source Analyzer, Menu Sources >> ‘Import From Database’
Go to ODBC Data Source Administrator
Select Oracle Data Source and ‘Configure’ it.
‘Enable N-CHAR Support’ option might be disabled here, Just enable this feature and try again.
Go to Target and preview the data Again, Issue is fixed now, You can view the result from Mapping itself instead of going to Database and query the table.

 

 

Leave a comment

Your email address will not be published. Required fields are marked *