Execute SQL Statement on Oracle DB Server(JDBC ACTIVITY)

[Sravani36]

Hi i have configured test jdbc connections to execute the sql statement on the oracle db server and to capture the output 

1) In the jdbc connection for the fields *Host:- given the IP of the db server and credentials are validated.

2)coming to custom jdbc activity from the workflow the below sql statement should execute on the input (Ip of the different db servers) we give. But it's executing on the Host name we give on point 1 in credentials

So my requirement is it should execute on the whatever input (IP OF ORACLE DB SERVER) we give for the activityinput.input1.

How to fix this or any other suggestions please share.

Thanks in advance

Sravani C

[Vamshi_ch123]

Hi Rahul we have installed a SQLPLUS Client on our mid server, before passing this input parameter from where we can configure this credentials to connect with this batch tool or any custom activity we need to use in flow or workflow ?

can you just brief it bit more clearer what you mentioned.

[Rahul Priyadars]

Now from This SQLPLUS are you able to connect to any Oracle DB?

You may need to take help from Oracle DBas. Now make a script for silently connecting SQLPLUS with fixed IP.

Next step is to - Make script to conect with Dynamic IP.

Once ur are done here then try to put ur dynamic IP details from SR in some text file on mid server. 

Now ur dynamic script will read this text-file for Dynamic IP

its all step by step towards dynamism.

Regards

RP