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-settingsSo 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
------------------------------
Original Message:
Sent: Sat November 13, 2021 06:41 AM
From: ding wei
Subject: How to use Invoking SQL Integration service flows
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
------------------------------