Configuring Insert Values Services
Insert Values service inserts new information into a stream or table. You configure
Adapter for Apache Kafka services using
Designer. For more information about adapter services, see
Using Adapter Services.
Be sure to review the section
Before Configuring or Managing Adapter Services before you configure adapter services.
To configure an Insert Values service
1. In Designer, right-click the package in which the service should be contained and select New > Adapter Service.
2. Select the parent namespace, type a name for the adapter service, and click Next.
3. Select Adapter for Apache Kafka as the adapter type and click Next.
4. Select the appropriate KSQL connection as Adapter Connection Name and click Next.
5. From the list of available templates, select the Insert Values template and click Finish.
The adapter service editor for the adapter service appears. You can select the Adapter Settings tab at any time to confirm adapter service properties such as the Adapter Name, Adapter Connection Name, and Adapter Service Template, as necessary.
6. Select the Insert Values tab to configure stream or table and set the fields as follows:
Field | Description/Action |
Type | Defines the source type that you select, that is, table or stream. |
Name | Name of the source is selected based on theType you select. |
7. Use the Column, Column Type, Input Field Type and Expression fields on the top row of the tab to define the columns and fields to be inserted as described in the following table.
a. Use the 
icon to create new rows as needed. You can use the 
icon to fill in all rows to the table. Field | Description/Action |
Column | The name of the column for a stream or table. |
Column Type | The column data type in a stream or table. |
Input Field Type | The corresponding Java type for the input field. |
Expression | The default value is ?, which acts as a placeholder for the variable so that you can set the input variable for that column at run time, or get input external to this adapter service. It adds one row with the same column name to the stream or the table. You can also type a fixed value in this field now or at run time. If you type a fixed value, be sure that it is valid, or an exception will be generated at run time. |
Note:
MAP, ARRAY, STRUCT data types are not supported in this service.
8. From the File menu, select Save.