BPM, Workflow, and Case

  • 1.  SQL connectors wit 8.6.0.0_TC system data toolkit

    Posted 11 days ago
    Hi everyone,

    In the BAW we have a option to choose the runtime environment (traditional / traditional or container).
    If traditional or container selected we have to make changes and one of them is to use the 8.6.0.0_TC toolkit.
    Unfortunately this toolkit don't have the sql connectors (sql execute statement, sql call stored procedure, etc).

    The question is, how I can convert my app to be traditional or container suitable?

    Thanks in advance.

    ------------------------------
    Filipe Ventura
    ------------------------------


  • 2.  RE: SQL connectors wit 8.6.0.0_TC system data toolkit

    Posted 10 days ago
    Hi Filipe,

    I can see the SQL functionality in the integration.jar I have from the System Toolkit 8.6.0.0_TC on BAW 20.0.0.2. (Verified in a "Traditional or Container" app).
    What BAW version are you on?


    ------------------------------
    Bjorn Ganslandt
    IBM
    ------------------------------



  • 3.  RE: SQL connectors wit 8.6.0.0_TC system data toolkit

    Posted 10 days ago
    Hi Bjorn,

    Based on what you said the solution is to use the integration.jar directly instead of use the services contained in the system data toolkit?

    Regards.

    ------------------------------
    Filipe Ventura
    ------------------------------



  • 4.  RE: SQL connectors wit 8.6.0.0_TC system data toolkit

    Posted 10 days ago
    Hi Filipe,

    no I just wanted to say that the SQLConnector capability is available.

    If the ready-made services in the System Data toolkit suits you, please use them.
    In fact, if you look at how they have been implemented, they bind to the SQLConnector external service that in turn calls the functions available in the integration.jar.
    But if you have some other needs, you could also create your own External Service using the "Java service from Server File" method, and pick the integration.jar that way.




    ------------------------------
    Bjorn Ganslandt
    IBM
    ------------------------------



  • 5.  RE: SQL connectors wit 8.6.0.0_TC system data toolkit

    Posted 6 days ago
    Hi Bjorn,
    It is okay to maintain both toolkits?system data and system data _TC?
    I do not need to remove the toolkit so I can use "traditional or container" runtime environment?

    Regards


    ------------------------------
    Filipe Ventura
    ------------------------------



  • 6.  RE: SQL connectors wit 8.6.0.0_TC system data toolkit

    Posted 6 days ago
    Hi Filipe,

    I'm not sure why you would want to keep both?

    In my BAW version 20.0.0.2, if I create a new ProcessApp and select target environment mode "Traditional and Container", I get only one System Data toolkit snapshot, i.e. 8.6.0.0_TC to choose from.

    I would assume you may run into issues - now or later on - if you try to deploy a "Traditional" mode app using the System Data snapshot 8.6.0.0 in a container environment.

    PS. The SQL Connector and associated services are available in both snapshots.



    ------------------------------
    Bjorn Ganslandt
    IBM
    ------------------------------