ETL use between Oracle and PostgreSQL

Edward
Topic Author
Offline
New Member

More

7 years 8 months ago #14283 by Edward

ETL use between Oracle and PostgreSQL was created by Edward

Hello,

We have an Oracle server and 1 dedicated server for PostgreSQL database. How can we apply ETL between the two?

Please Log in or Create an account to join the conversation.

KevinJohn
Offline
Premium Member

More

7 years 8 months ago #14284 by KevinJohn

Replied by KevinJohn on topic ETL use between Oracle and PostgreSQL

ETL-Tools can be used to load between 2 databases.

If you do complex SQL queries from several databases during report execution, performance will be affected in the end. It is highly recommended to transform data to a simpler form.

Data Source: Oracle

Target Type: PostgreSQL

The following user(s) said Thank You: Edward

Please Log in or Create an account to join the conversation.

ETL-Forum