BPM, Workflow, and Case

 View Only
  • 1.  How to use BAW's External Service to connect to the database

    IBM Champion
    Posted Wed November 03, 2021 02:15 AM
    I want the BPM process to directly read the business database. According to the official document https://www.ibm.com/docs/en/baw/20.x?topic=service-invoking-sql-integration-flows, it is possible. But I don't know how to do all the props? Do you have examples that you can provide for reference and study?
    Our environment is deployed on OpenShift. Can the configuration of "dataSourceName" in the official document tell me where to implement it?

    ------------------------------
    ding wei
    ------------------------------


  • 2.  RE: How to use BAW's External Service to connect to the database

    Posted Thu November 04, 2021 12:28 PM
    Hi,

    this documentation might help you: https://www.ibm.com/docs/en/baw/20.x?topic=service-invoking-sql-integration-flows

    ------------------------------
    Maximilian Tews
    ------------------------------



  • 3.  RE: How to use BAW's External Service to connect to the database

    IBM Champion
    Posted Mon November 08, 2021 09:57 PM
    thank you very much for your help!
    Because the environment is based on OpenShift, you need to complete the following operations before you can use it.
    Modify liberty_custom_xml in CR:
    liberty_custom_xml: |+
    <server>
    <library id="DB2JCC4Lib">
    <fileset dir="/shared/resources/jdbc/db2" includes="db2jcc4.jar db2jcc_license_cisuz.jar db2jcc_license_cu.jar"/>
    </library>
    <dataSource id="testDataSource" jndiName="TESTDS" type="javax.sql.DataSource">
    <jdbcDriver libraryRef="DB2JCC4Lib"/>
    <properties.db2.jcc
    databaseName="BAWDB"
    serverName="9.111.111.101"
    portNumber="50000"
    user="db2inst1"
    password="{xor}Eyo9PjE+OzJuMQ=="
    driverType="4"
    />
    <connectionManager maxIdleTime="1m" maxPoolSize="50" minPoolSize="0" reapTime="2m" enableSharingForDirectLookups="false"/>
    </dataSource>
    </server>

    ------------------------------
    ding wei
    ------------------------------