App Connect

App Connect

Join this online user group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#Applicationintegration
#App Connect
#AppConnect
#Integration
#Automation
 View Only

  • 1.  Can we connect to Oracle and SQL Server database using single compute node ?

    Posted 01/27/17 07:10 AM

    Hi Guys,

    Can someone confirm about connecting two different databases by using Compute node.

    I have two databases Oracle and SQL server

    I have two dsn's created one for each O12CDSN and SQLDSN.

     

    Now i have a very basic flow MQInput----> Compute----> MQOutPut

     

    Can i access two different tables from compute node here ?

     

    Thank you

     

    Mohanavamsi Ch

    www.Integrationseries.com



  • 2.  RE: Can we connect to Oracle and SQL Server database using single compute node ?

    Posted 01/31/17 06:56 AM

    Yes, you can but not in a single ESQL statement.  You can, for example, use PASSTHRU twice, once for each database, then use ESQL to manipulate the data between the two.  You can use SELECT to reference multiple tables within the same database, but not two different databases.  Here is a link to the IIB 10 doc stating these limitations.

     

    https://www.ibm.com/support/knowledgecenter/SSMKHH_10.0.0/com.ibm.etools.mft.doc/ac07000_.htm

     



  • 3.  RE: Can we connect to Oracle and SQL Server database using single compute node ?

    Posted 01/31/17 08:24 AM

    Thank you for the doc link. 

    In Reply to Tony Hays:

    Yes, you can but not in a single ESQL statement.  You can, for example, use PASSTHRU twice, once for each database, then use ESQL to manipulate the data between the two.  You can use SELECT to reference multiple tables within the same database, but not two different databases.  Here is a link to the IIB 10 doc stating these limitations.

     

    https://www.ibm.com/support/knowledgecenter/SSMKHH_10.0.0/com.ibm.etools.mft.doc/ac07000_.htm

     



    Mohanavamsi Ch

    www.Integrationseries.com



Related Content