SDI Real Time Flowgraph Oracle --> HANA "Virtual Table Data Source/Input Type is not found Error"

[sram246]

Hello SAP Community,

I am trying to load data from Oracle into HANA using SDI Flowgraph with Runtime Behavior Type as "Realtime Task". It is failing at Build step itself in WebIDE. If I use "Batch Task" mode it is running and loading data also.

Source: Oracle Table

Target: HANA Permanent table

Adapter: "OracleLogReaderAdapter"

Error Message:

could not process the flow graph XML content; ERROR: Virtual Table Data Source/Input Type is not found in Realtime Flowgraph [8257505]"

Is there any setting I am missing?

Thanks for your help.

Sree

[sram246]

We raised OSS message and SAP confirmed that WebIDE flowgraphs with Realtime replication is not supported if backend HANA DB is 1.0 SP12. We switched WebIDE Workbench flowgraphs to achieve Realtime Replication.

[former_member231709]

Try to change source table from a local table to a remote table. Also check: https://blogs.sap.com/2014/12/09/hana-sps09-smart-data-integration-realtime-table-replication/

[former_member550544]

Hey Sree,

Did you get answer/solution on this? I'm having similar issue. When I use Batch Task, the flow graph is executing and data is getting transferred but when I switch it to Real time or Transactional task behavior type I get error

ERROR: No DP realtime Data Source found in the DP realtime flow.

In the flow graph on source table (virtual table) the real-time check box is not getting enabled.

I'm using

adapter- Oracle (Generic ODBC)

Please let me know if anyone know the solution. Thanks.

[former_member231709]

SDA Oracle Adapter (ODBC) does not support realtime. You must use OracleLogReaderAdapter