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
Uh oh!
There was an error while loading. Please reload this page.
-
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