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

Community

Connector Improvement: Oracle Business Intelligence Publisher - sync tables without a primary key

Completed
Fabio Alves User
  • Edited

Currently, the connector does not allow us to sync data from tables without a primary key defined, as outlined in the documentation. 

Fivetran marks the source tables as Excluded By System in the connector dashboard, if:

  • The table doesn't have any columns.
  • The table doesn't have a primary key column.

Instead of not syncing this table at all, we'd prefer if there was some alternative mechanism for syncing this data, e.g. if the behaviour was similar to the Oracle databases, as described here:

For tables without a primary key, we designate our _fivetran_id column as the primary key.

 

Please sign in to leave a comment.

Comments

4 comments

Date Votes
  • Official comment
    Frank Fivetranner

    Hi everyone,

    This feature is now live and generally available. You can now sync tables without a primary key in the Oracle Business Intelligence Publisher connector, using the _fivetran_id column as an alternative identifier.

    Thank you to everyone who provided feedback and for your patience throughout this process.

    Thanks,
    Frank

  • Frank Fivetranner
    • Edited

    Hi Fabio, 

    Thanks for the feature request. Should the tables that you are trying to sync have a primary key and are just not assigned one or do they intentionally not have a primary key? 

    Thanks, 

    Frank

  • Arturo Chan Yu User

    We are also unable to sync data from tables that do not have primary keys. 

  • Bharath Natarajan User

    Please take a look at RCV_LOTS_SUPPLY table. It intentionally does not have a primary key in Oracle and Fivetran BIP connector cannot pull it. There is no alternate PVO in the BICC Connector to work with. We are stuck with a major business requirement that has not been met. This needs to be addressed ASAP.