Connector Improvement: Oracle Business Intelligence Publisher - sync tables without a primary key
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.
-
Official comment
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
-
We are also unable to sync data from tables that do not have primary keys.
Please sign in to leave a comment.
Comments
2 comments