When sourcing data from Oracle, DB2/UDB or other ODBC compliant databases, the object names of tables, indexes and columns must conform to the conventions of the host DBMS with the following additional restrictions:

This means the table, index or column name cannot be defined as a Delimited or Quoted Identifier. A Delimited or Quoted Identifier is surrounded by double quotes and contains characters which cannot be used with Regular Identifiers. The column name: Father’s Country of Birth in SQL is structured as "Father’s Country of Birth" and is regarded as a delimited or quoted identifier due to the use of an apostrophe and spaces in the name. Other characters used with delimited or quoted identifiers include commas, slashes, dashes etc.

To overcome these limitations create a view of the table using regular identifiers, which do not exceed 32 characters, and source from this view.