Oracle Raw datatype to Postgres String #49986
Unanswered
henryosorioii
asked this question in
Connector Questions
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi All,
I want to understand how Airbyte manages mapping from Oracle to Postgres. I am currently exploring a standard ETL tool for migrating data from different sources from 2016 to the present. I came across Airbyte and tried the replication for millions of records. It was able to do so. I was able to set up and sync data from the two databases.
However, it is different when I check the Raw datatype data from the Oracle source table to the Postgres replicated table, which converts it to Varchar. I assume it has encoded the data (Base64?). Why is it not the same, or am I missing something here? Or is there any standard process that I need to do?
Example
Oracle (RAW datatype)
C693DF46F93B9338E0501FACE2103975
Postgres (varchar)
xpPfRvk7kzjgUB+s4hA5dQ==
I appreciate the enlightenment you can provide.
Beta Was this translation helpful? Give feedback.
All reactions