How to Migrate Data from an Oracle Database to a Postgres Database Using Airflow!

Facing challenges migrating data from Oracle to Postgres? This tutorial breaks down the step-by-step process of using Airflow to seamlessly transfer your data between these databases. We'll delve into setup, best practices, and common pitfalls to avoid, ensuring a smooth migration. Suitable for database administrators, data engineers, and anyone looking to switch from Oracle to Postgres with ease. Tune in to streamline your database migration tasks with the power of Airflow. Remember to like, share, and subscribe for more tech tutorials! #OracleToPostgres #DataMigration #airflowtutorial

[김재엽-vr]

Thank you so much. They really help me out a lot. I need a video for data migration from Oracle Database to snowflake using airflow with example please

[snehithjshiju]

Hi @thedataguy explained well. Need a video for data migration from MongoDB to mysql using airflow with example please

[candyskullxoxo]

I love all your videos. They realy help me out a lot. I am noob in airflow.
Would you mind to make a video about oracel client lib integration in your local airflow instance? The connection to the oracle db only works in thick mode. I run the instance with astro cli in vs-studio with docker desktop on a windows. I am a little bit lost what to do now. Do i need to create a new dockerfile? Is there a workaround to skip the thick mode ?

[JeannetteSchuelingkamp]

Can you show how to do the thick mode in a local airflow instanz. How to mount the oracle lib in my astro project. :)

[ayocs]

insert_rows is too slow for large dataset
is there alternative way to load data faster

[apinansornkaewdara]

sume column is datetime format TypeError: Object of type Timestamp is not JSON serializable

[-Saishankar-zptg]

what if select query returns a result set of some billion records .
How to over come the problem

[eunheechoi]

Do you know how to switch from http to https in docker compose for airflow webserver ?
I have updated the compose like environment and volume related to SSL. The webserver container keeps restarting …. Any idea?
And create a video for this?

[RAYENAKKARI-oh]

What version of Airflow is being used, please?

[lookatskykyyy]

Hi! do you still see my comment now,

I have problem with oracle to connect it's show i can't use a thin mode in log error, So i try to install cx_Oracle in dockerfile it's have problem to install too.