Table of Contents

Search

  1. Preface
  2. Introduction to ODBC Connector
  3. ODBC connections
  4. Synchronization tasks with ODBC Connector
  5. Mappings and mapping tasks with ODBC Connector
  6. SQL ELT optimization
  7. Data type reference

ODBC Connector

ODBC Connector

Rules and guidelines for data filters

Rules and guidelines for data filters

Use the following rules and guidelines for data filters:
  • Do not use data filter variables with ODBC source connections.
  • When you run a task that contains a simple data filter on a date field from a Microsoft Access, MySQL, or Oracle database and the connection type is an ODBC connection, the task fails with an error similar to one of the following errors:
    RR_4035 SQL Error [ FnName: Execute -- [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.]. RR_4035 SQL Error [ FnName: Execute -- [Oracle][ODBC][Ora]ORA-01843: not a valid month ].
    By default, a simple data filter applies a double quotation mark to escape the column name in an ODBC connection, which causes the error. To resolve the error, create an advanced data filter and apply the correct escape character to the column names.
  • If you change the data type of a Microsoft Access or ODBC source column to binary, varbinary, longvarbinary, or ntext in a
    synchronization
    task, you cannot create a simple data filter on the column. You can create an advanced data filter.

0 COMMENTS

We’d like to hear from you!