Skip to Content
0
Sep 13, 2023 at 11:32 PM

JDBC; Unable to use same JDBC Data Source / Guidance on approach

70 Views

Hello Experts!!

I think I've found the "why" to my challenge. Looking for confirmation and guidance on what would be the best approach for my project.

I have data in a cloud HANA database and I need to run several reports against it. Then consolidate the report output and zip them up and send them via email.

What I'm finding is I can only use a JDBC Data Source once in my Integration flow. This seems to be confirmed in note: 3164734 - JDBC Receiver Adapter error: Failed to get the xml output for query (https://me.sap.com/notes/3164734/E)

My choices appear to be separate integration flows or define multiple JDBC Data Sources.

I need to aggregate a number of reports so this and either approach will get quite messy.

See my sample flow - the JDBC channels below are currently defined as different JDBC Data Sources pointing to the same database.

I appreciate any guidance on best approach to resolving this would be appreciated.

Thank you. /Greg

image.png

Attachments

image.png (43.7 kB)