Table of Contents

Search

  1. Preface
  2. Introduction to Oracle Connector
  3. Oracle connections
  4. Synchronization tasks with Oracle Connector
  5. Mappings and mapping tasks with Oracle Connector
  6. Replication tasks
  7. Troubleshooting
  8. Appendix A: Data type reference

Oracle Connector

Oracle Connector

Rules and guidelines for data filters

Rules and guidelines for data filters

Use the following rules and guidelines when you configure data filters:
  • If you include UTF-8 characters in a data filter on an Oracle source, the data filter does not work.
  • If you create a simple data filter on a date field in an Oracle source, the date field must use the default Oracle format
    DD-MON-YY
    . To create a filter on a date field with a non-default date format, use an advanced data filter.
    For example, to read an Oracle date field that has the date format
    'yyyy/mm/dd:hh:mi:ssam'
    , use the following advanced filter:
    “DATE_FIELD” > to_date('1998/05/31:12:00:00AM', 'yyyy/mm/dd:hh:mi:ssam')

0 COMMENTS

We’d like to hear from you!