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.

 View Only

  • 1.  Set up ODBC datasource in ACE

    Posted Mon January 28, 2019 03:07 PM

    If not using Integration Node, how do I define ODBC data source for the integration servers?  And how do I verify the ODBC connection using mqsicvp against integration server?  

    thanks,



    ------------------------------
    Andy Mao
    ------------------------------


  • 2.  RE: Set up ODBC datasource in ACE

    Posted Tue January 29, 2019 02:13 AM
    Edited by Muhammad Haider Raza Tue January 29, 2019 12:02 PM

    Invocation where ODBC data source names have not been associated with the integration node:
    On windows define the DSN as previously for IIBv9 or IIBv10. No need to run mqsicvp command in this scenario. You can run the command to check connectivity:
    >>-mqsicvp-- -n--primaryDatasource------------------------------>

    >-- -u--primaryDatasourceUserId--------------------------------->

    >-- -p--primaryDatasourcePassword------------------------------->


    Now use the DSN name on compute node and you can connect successfully to your database.

    https://www.ibm.com/support/knowledgecenter/SSTTDS_11.0.0/com.ibm.etools.mft.doc/bn07236_.htm

    ------------------------------
    Muhammad Haider Raza, Integration Lead
    Royal Cyber Inc.
    ------------------------------

    Original Message


Related Content