Strange characters imported from Oracle table using ODBC

Document ID:KM00430479
Creation Date:16-May-2013
Modified Date:16-May-2013
- Micro Focus Products:
  connect it

Summary

Using ODBC to connect to an Oracle table may produce strange and illegible characters

Question

A Connect-It scenario has as source an Oracle table using an ODBC connection. The logs are showing strange characters in fields where there is no data present from the source. These strange characters are causing the scenario to fail.
Source Connection: Oracle 11g using ODBC
Connect-It: Version 9.40
Connect-It Environment: Windows Server 2008 R2

Answer

Reconfigure the database connector in the scenario to use the Oracle native drivers.