Summary
The user is looking for an alternative sink connector that utilizes a JDBC driver for Oracle 19c database due to JSON column support limitations in Oracle 21c. They require simple one-time or daily data replication without the need for complex Airbyte schemas.
Question
Hello.
We are currently using an Oracle 19c DBMS and plan to use Airbyte to migrate data(like ETL) from a MySQL database (as the source) to an Oracle database (as the sink).
However, I understand that the sink connector relies on JSON columns, which are supported only from Oracle 21c.
Is there an alternative sink connector that utilizes a JDBC driver instead of the Oracle connector?
My case does not require incremental processing or complex features.
I simply need a one-time, or Daily, data replication.
Therefore, I do not need to generate complex Airbyte schemas. It seems a straightforward data insertion via JDBC would suffice for us.
Is there any connector that supports this functionality?
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.