content_image/985543.jpg content_image/985544.jpg
<img src='content_image/985543.jpg'>

7. You can now insert a new row into the table using the following SQL command and again selecting the Run SQL command as previous. 

INSERT INTO PRODUCTS ( last_updated, part_number, product_name, quantity, description) VALUES ('2019-08-01T09:57:34.265Z', 12, 'duck', 100, 'a waterbird with a broad blunt bill, short legs, webbed feet, and a waddling gait'); 

8. We can check that the entry has been successfully inserted by using the SELECT SQL command. 

SELECT * FROM PRODUCTS 

Figure 6-15 shows the SELECT SQL query result. 

<img src='content_image/985544.jpg'>

## 6.2.3 Swagger definitions 

In this section, we package the project files into a BAR file for each application as shown in the following web pages: 

GLYPH<SM590000> https://github.com/IBMRedbooks/SG248452-Accelerating-Modernization-with-Agile-Int egration/blob/master/chapter6/6.1/database_operations.bar 

GLYPH<SM590000> https://github.com/IBMRedbooks/SG248452-Accelerating-Modernization-with-Agile-Int egration/blob/master/chapter6/6.1/database_query.bar 

Then we create a new server for each. In this chapter we want to use the user interface to achieve this. Later, we see how this can be automated by using pipeline deployment in section 7.5, “Continuous Integration and Continuous Delivery Pipeline using IBM App Connect V11 architecture” on page 465. 

1. Log in to the IBM Cloud Pak for Integration instance and the IBM App Connect dashboard. In this view we click Add server  as shown in Figure 6-16. 

