Import database objects easily

The initial copy of the data from Oracle can be completed using Oracle SQL developer which provides a wizard for exporting data and metadata from the database.  That data is then ingesting into Druid via SQL.  Subsequent changes to the Oracle analytical data can then be replicated in Druid using LAST_UPDATED date time field to determine the updated or new records along with code to facilitate the migration, using various ELT tools or the Debezium Oracle connector to automate the CDC (Change Data Capture process).

The initial copy of data from Snowflake to Apache Druid can be completed using the Snowflake bulk unloader and ingesting that data into Druid via SQL. After the initial ingest data updates can be handled by a simple change data capture process using the LAST_UPDATED date time field to determine the updated or new records along with code to facilitate the migration or using various ELT tools.

Data in PostgreSQL can be exported using the pg_dumpall command line utility.  The .sql export can then be imported into Druid using SQL ingestion. After the initial ingest data updates can be handled by a simple change data capture process using the LAST_UPDATED date time field to determine the updated or new records along with code to facilitate the migration, using various ELT tools or the Debezium Postgres connector which automates the CDC (Change Data Capture) process.