I am attempting to use the Database-Inbound to read from a oracle DB and the connections to the DB are working great. I am able to get the schema.
The issue I have having is my understanding of how this protocol option works. I am receiving an ID from the up-steam system, in a file, and need to query the DB with this ID in order to receive a different set of data each time.
The question is how do I pass the ID in to the protocol?
ex. Select * from table where ID = ‘$IDFROMFILE’