0

I have migrated an oracle database to AWS Aurora PostgreSQL. My application is connecting to another upstream application on Oracle database on AWS RDS.

I'm generating inventory reports from the upstream application. earlier it was both Oracle databases, so they were using dblink to connect the upstream/downstream databases.

dblink and postgresql_fdw installed and both are connecting to the different postgres databases not to oracle db.

My question is how to I connect to Oracle db from postgres.

Improve this question
1
  • Maybe have a look at Configuring Oracle Database Gateway for ODBC. When you install the Postgres ODBC drivers on your Oracle DB server, then connection from Oracle to Postgres (the opposite direction than you asked) should be possible. Commented Apr 22, 2020 at 9:39

1 Answer 1

Reset to default
1

You cannot. You limited yourself by choosing a hosted database.

If you had control over the operating system, you could install oracle_fdw, and it would be simple.

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

I've the control on the OS. I've a postgres db is running on my local machine. is it possible to connect to oracle ?
Oh, yes, absolutely. The software and instructions are here.
Cool :) Thanks Laurenz

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.