how to use materialized view log in BODS job

[Former Member]

I have a scenario where source table has millions of rows.

I have created a materialized view log on my source table.

I need to load data from materialized view log into a target table using BODS.

How can I make a materialized view log as a Source in my BODS job?

[Former Member · Accepted solution]

I haven't gone thru CDC yet but I figured that I can import the respective log table in BODS as MLOG$_table_name

[former_member187605 · Accepted solution]

Sure. If you want to reinvent the wheel .

[former_member187605]

Oracle db?

Define an Oracle CDC datastore in DS.

And read section "19 Changed Data Capture" in the SAP Designer Guide. Especially sub-section "19.4 Use CDC  with Oracle sources" will contain valuable info for you.