Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Support for Oracle tables with PK of type CHAR

Christian Simon User

Requesting enhancements to the Oracle Connector that would support tables with a PK field of type CHAR

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Nathan Fuzi User
    • Edited

    Hi Christian Simon, 

    Thank you for submitting your request via our feature portal. Can you please clarify if you are asking about support for CHAR primary keys in Fivetran Teleport for Oracle? While Teleport does not support tables with CHAR primary keys today [1], we are working on a feature to support using ROWID as a surrogate PK for tables that have an unsupported PK data type. We expect to have this available by request in the next few months. 

     

    [1] https://fivetran.com/docs/connectors/databases/oracle/oracle-connector#fivetranteleportsyncbeta

  • Christian Simon User

    Yes Nathan. I confirm I am asking support for CHAR primary keys but having ROWID as an alternative would be something worth trying out for our use case. At the moment we are not able to bring the source data in because of the limitation.