AWS DMS - Data from Oracle EBS database - from View

0

AWS DMS only pulls Table from Database (In my case Oracle EBS Database) is there any possibility to pull View data from Database using AWS DMS.

已提問 2 年前檢視次數 247 次
1 個回答
0

You can pull data once from a view using attribute exposeViews=true on DMS. You can't use it for ongoing replication. Please see details : https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.Oracle.html [Extra connection attributes when using Oracle as a source for AWS DMS] https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Troubleshooting.html [Troubleshooting issues with Oracle] - [Pulling data from views]

AWS
已回答 2 年前
  • exposeViews=true, this attribute is only required, if it has mix of tables and views. If your full load only has views, this attribute is not required.

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南