Using DMS CDC for Oracle to Postgres


Hello All,

I am trying to see the feasibility of using DMS CDC for Oracle to Postgres on going data updates. Created the task for CDC. It is reading changes from the Oracle 19c Source table. For some unknown reason(for myself), it is not applying the changes to Postgres 13 RDS database.

Is there a specific setup i am missing? Please advice.

Thanks in Advance

3개 답변

Can you confirm you have followed these steps to set-up the source Oracle database -

profile pictureAWS
답변함 2년 전

Thank you for your response.

Yes. I did all the settings as in the document. It was working fine for Oracle to Oracle RDS data replication.

Now trying to do the same for Oracle to Postgres RDS.

I am sure it is some privilege missing on the target instance. Not sure, what it is.

답변함 2년 전


As DMS task worked fine with Oracle to Oracle RDS data replication, the difference between Postgres would come for tables names. Oracle treat all table name in CAPITAL letter but postgres is the opposite, all in LOWERCASE. Most likely you would need to add transformation rule to convert all table and schema name to lower case.

Hope that helps, if not, then pls. share the dms log for understanding it more.


답변함 일 년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠