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.  Connecting Database in APPConnect

    Posted 12/05/21 08:33 PM
    Hi,

    1. Which is the best method to connect the Database, either through JDBC or ODBC?
    2. If we connect SQL Database(Microsoft SQL Server) through ODBC, we are able to connect only MASTER Database(dafault). we are not able to connect our custom Database (ex: Sales DATABASE)

       is there anyway to connect our custom database while using ODBC?

    Regards,
    Jothi

    ------------------------------
    Jothiboss Murugan
    ------------------------------


  • 2.  RE: Connecting Database in APPConnect
    Best Answer

    Posted 12/06/21 09:04 AM
    Check your ODBC setup. I believe you need to specify the database name in the ODBC entry. Master is just the default database if no name was specified...

    ------------------------------
    Francois Brandelik
    ------------------------------



  • 3.  RE: Connecting Database in APPConnect

    Posted 12/06/21 10:07 AM
    Hi Francois

      Thank you!!. yes there is option to select the database in odbc setup. I would like to know that, which one you will prefer to connect the database in APPConnect, odbc or jdbc ?


    Jothi

    ------------------------------
    Jothiboss Murugan
    ------------------------------