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. 

Optional feature not implemented.

Optional feature not implemented.
Error while trying to Preview data on Target
Optional feature not implemented.
Go to Source Analyzer, Menu Sources >> ‘Import From Database’
Optional feature not implemented.
Go to ODBC Data Source Administrator
Optional feature not implemented.
Select Oracle Data Source and ‘Configure’ it.
Optional feature not implemented.
‘Enable N-CHAR Support’ option might be disabled here, Just enable this feature and try again.
Optional feature not implemented.
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 Reply

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