Accessing the DB from a compute node in a message flow in WMB
1. Add the datasource name in the oracle ini files
2. Run the mqsetdbparms command
>>-mqsisetdbparms--BrokerName-- -n --ResourceName---------------> >-- -u --UserId-------------------------------------------------> >--+- -p --Password------------------------------+--+-----+---->< '- -i --SSHIdentityFile--+------------------+-' '- -f-' '- -r --Passphrase-'
1. Add the datasource name in the oracle ini files
2. Run the mqsetdbparms command
>>-mqsisetdbparms--BrokerName-- -n --ResourceName---------------> >-- -u --UserId-------------------------------------------------> >--+- -p --Password------------------------------+--+-----+---->< '- -i --SSHIdentityFile--+------------------+-' '- -f-' '- -r --Passphrase-'
3. Configure the DSN name in the compute node and run the sql query through the compute node
Comments
Post a Comment