BPM, Workflow, and Case

BPM, Workflow, and Case

Come for answers. Stay for best practices. All we’re missing is you.

 View Only

  • 1.  Postgress Support

    Posted Tue August 08, 2023 10:16 AM
      |   view attached

    Please find the attached version at our end, and confirm if it supports Postgres DB as product DB.

    What we can do to migrate it in On Premises DC; We not using process designer or process centre as no .twx or zip  files.

    Only long running SCA modules deployed as .ear files.

    Please try to elaborate what is BPEL and BPMN difference.



    ------------------------------
    Sagar Naik
    ------------------------------



  • 2.  RE: Postgress Support

    Posted Wed August 09, 2023 04:05 AM

    Hi Sagar,

    it seems you are running BAW 20.0.0.1 and this version of BAW doesn't support PostgreSQL.

    You can check the dependencies of any version of BAW by visiting 

    https://www.ibm.com/support/pages/ibm-business-automation-workflow-detailed-system-requirements

    and selecting the exact version you are interested in. For 20.0.0.1 you'll end up here: Link to compatibility report

    If you want to use PostgreSQL, you'd have to update your version of BAW to a level which supports this RDBMS (V22.0.1 or above). As there is no database conversion tooling in BAW, you could "phase out" older SCA flows on your current installation and create new flows on a new environment which uses PostgreSQL.

    I'm not sure what you are referring to regarding your question on BPEL vs BPMN. It seems that you are currently not using BPMN but you are only using Integration Designer to author your SCA artifacts (is that assumption correct)? If this is the case, you do not have to consider PostgreSQL support for the authoring environment (Workflow Center) but only for the Process Server runtime. Even though we started supporting PostgreSQL for the workflow runtime in V21.0.3 it was limited to the container runtime only and the container runtime only provides the BPMN workflow engine.
    For that reason a traditional deployment would need to be on V22.0.1 to have support for PostgreSQL. Due to the remaining support timespan, V23.0.1 would be recommended over 22.0.1.
    Does that answer your question?

    Best regards,

    Michael

    That said, 23.0.1 would be recommended as it has a longer support span. 

     



    ------------------------------
    Michael Kirchner
    Sr. Business Automation Partner Technical Specialist
    IBM Technology
    Germany
    ------------------------------

    Original Message


  • 3.  RE: Postgress Support

    Posted Wed August 09, 2023 10:01 AM

    Hello,

    You will find plenty of discussion on the BPMN/BPEL question if you search for "BPMN vs BPEL"

    Stuart Jones



    ------------------------------
    Stuart Jones
    Business Automation Technical Specialist
    IBM
    Cedar Rapids IA
    630 390 4436
    ------------------------------

    Original Message