BPM, Workflow, and Case

 View Only
  • 1.  How to use Invoking SQL Integration service flows

    Posted Sat November 13, 2021 06:41 AM
    Official document https://www.ibm.com/docs/en/baw/20.x?topic=service-invoking-sql-integration-flows
    Explain that you can directly use the database through SQL Integration service. Are there any examples to learn from? For example, as mentioned in the article:
    Read existing data from a database.
    Insert new data to a database.
    Call stored procedures in your database.

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


  • 2.  RE: How to use Invoking SQL Integration service flows

    Posted Fri November 26, 2021 06:16 PM
    Good evening,

    To solve your need you have three steps to follow the first step is to create JAAS data authentication on websphere the second step is to create a source data on websphere third is to create a service at the level of your process where you use sql query to execute


    ------------------------------
    El Mehdi ES-SAFI
    ------------------------------



  • 3.  RE: How to use Invoking SQL Integration service flows

    Posted Wed December 15, 2021 04:12 AM
    As you know in the Java world in a managed environment. If we want to use a database connection. The normal way is create a datasource in server configuration. Then invoke with that data source.

    So the first step will be create a data source and all the connection needed configurations for that data source.
    Here is the document on how about the data source in WebSphere: https://www.ibm.com/docs/en/was-nd/8.5.5?topic=console-data-source-settings
    So login in WebSphere Admin Console. Create data source accordingly. Filling all the information need. Usually there should be:
    1. JDBC liberary
    2. DB type, connection
    3. Username, password you want to use with auth data or in the data source section directly.
    Remember the JNDI name. And you can input the JNDI name in SQL connector dataSourceName field.
    For others. As that different from what you want to query and what the structure your table is. You can have a try with most common SQL
    select * from xxxx
    To begin with. Then analyze the result set to find out how to use that.

    Best regards.

    ------------------------------
    DA GUANG SUN
    ------------------------------