Insert into databse
Description
This activity inserts data in specified database table using user-specified values. if user does not specify the column then the matching columns are uploaded into data base.
Input
Data
Output
Updated data in the database
Configuration Fields
- Connection Configuration options to establish a connection to a database
- Table Table in the selected datasource where you want to upload the data
- Create table if not exists Creates table if not exists
- ColumnMap Name of the column to transform and the transformation to apply to the column(note: the target names must match the original column name in the database)
Sample Input
| Country | Gender | Company |
|---|---|---|
| Japan | Male | Hirthe and Sons |
| Japan | Female | Sipes Group |
| France | Male | K Mart |
| Brazil | Male | Miller Inc |
| Brazil | Male | Roob and Sons |
Sample Configuration
Sample Output
Data inserted into the database
| India |
|---|
| Japan |
| Japan |
| France |
| Brazil |
| Brazil |