Topic
  • 1 reply
  • Latest Post - ‏2013-01-23T16:59:54Z by SystemAdmin
SystemAdmin
SystemAdmin
4179 Posts

Pinned topic MB: Message Flow Between MQInput and Database

‏2013-01-21T14:26:27Z |
Hello Everyone;

I'm trying to create a Message Flow between a MQInput and a Database in Oracle, but i got a set of doubts about the building of this flow:

1. Which type of message i send across the MQInput to get a functionality and write or read data in my database?
2. It's mandatory to estabish a JDBC connection to get my flow running?
3. How i can configure my Oracle instance?
4. Where i can get documentation about this?

Thanks for your help.

Regards from Colombia;
Cristian.
Updated on 2013-01-23T16:59:54Z at 2013-01-23T16:59:54Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    4179 Posts

    Re: MB: Message Flow Between MQInput and Database

    ‏2013-01-23T16:59:54Z  
    Hello, Cristian

    Please, check this book:
    http://www.redbooks.ibm.com/abstracts/sg247137.html

    Here you'll find the a lot of the answers you are looking for.

    P.S. If you are going to use ESQL you have to configure ODBC data source on your machine and then register it within the message broker with command looking like this: ...IBM\MQSI\8.0.0.1\bin\mqsisetdbparms TestBroker -n OracleDS -u userName -p Passw0rd