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

Community

Connector Improvement: Oracle source ANYDATA, CLOB, BLOB, NCLOB etc data ingestion into BQ

Planned
Henry Sigalos User

Need to ingest data from Oracle source with column ANYDATA, CLOB, BLOB, NCLOB datatype into BigQuery...not allowing to pick specific column in Fivetran tool. Any help would be appreciated.

Please sign in to leave a comment.

Comments

6 comments

Date Votes
  • Official comment
    Kevin Kim Fivetranner

    Hi Henry,

    Thanks for your post in our feature request portal!

    We are currently working on a new Oracle database connector that leverages the capabilities of both Fivetran and HVR which will support CLOB, BLOB, and NCLOB data types!

    Currently, we support only Snowflake as a destination (in private preview) and BigQuery is on our roadmap, although I don't have an exact date to share at this time.

    I am not quite familiar with the ANYDATA type, would you have more information on your use case for this?

  • Henry Sigalos User

  • Henry Sigalos User

    attached screenshot from source itself as a Oracle datatype option...

  • Henry Sigalos User

    Oracle's definition...

    "ANYDATA

    This type contains an instance of a given type, with data, plus a description of the type. ANYDATA can be used as a table column data type and lets you store heterogeneous values in a single column. The values can be of SQL built-in types as well as user-defined types."

  • Remy Sanlaville User

    when can we expect the Oracle connector to a Snowflake destination to support CLOBs?

  • Nathan Fuzi User

    Hi Remy,

    LOBs, including CLOB, BLOB, and NCLOB are supported by the High Volume Adapter or "HVA" for Oracle connector. Please see our documentation for supported data types: https://fivetran.com/docs/connectors/databases/oracle/hva-oracle

    The HVA for Oracle connector does not support ANYDATA. We plan to support custom data types in an upcoming connector next year. Please stay tuned!