Procedure
- Double-click the first tFixedFlowInput component to open its Basic settings view.
-
Click the [...] button next to Edit
schema and in the pop-up dialog box, define the schema by adding
four columns: id of Integer type as the primary key,
name and role of String type,
and salary of Double type.
- Click OK to save the schema changes. In the pop-up dialog box, click Yes to propagate the schema to the next component.
-
Select Use Inline Content in the
Mode area. Then in the Content
field displayed, enter the following employee data to be inserted.
1;Mark Smith;tester;11000.00 2;Thomas Johnson;developer;12000.00 3;Teddy Brown;tester;13000.00
- Double-click the first tPostgreSQLOutput component to open its Basic settings view.
- Select the Use an existing connection check box and from the Component List drop-down list displayed, and then select the connection component to reuse the connection created by it, tPostgreSQLConnection_1 in this example.
- In the Table field, enter the name of the table into which the employee data will be written, employee in this example.
- In the Action on table drop-down list, select Default.
- In the Action on data drop-down list, select Insert to insert the employee data transferred from the first tFixedFlowInput component.
-
Click the [...] button next to Edit
schema to check whether the schema of tPostgreSQLOutput is the
same as the schema of tFixedFlowInput.