This content has been marked as final. Show 1 reply
When you do not see a dedicated column using the gateway, then the root cause is very often an unsupported data type. All data types of a foreign database are mapped by the ODBC driver to ODBC equivalents and DG4ODBC/HSODBC maps them to Oracle data types. In each manual there's a list of supported ODBC data types and to which Oracle data types they will be mapped.
For HSODBC please have a look at:
Heterogeneous Connectivity Administrator's Guide
10g Release 2 (10.2)
Chapter: B.1 Mapping ANSI Data Types to Oracle Data Types Through an ODBC Interface
When the column data type is now mapped to an unsupported ODBC data type the column is dropped from the select list. To check this behavior, please provide an ODBC trace when selecting from the table and also the source table definition (as your table is defined in the MySQL database).