Database Target
The Database Target service provides the ability to specify a database as target. This section describes how to create a Database target service.
As this Database Target service has now been deprecated in Connect, it is recommended that you use Advanced Database Target to specify multiple tables of a database as the target. Click here to know how to create an Advanced Database Target service.
Prerequisites
Ensure that you have created Database Info and Advanced Database Layout services.
Follow the steps below to create a Database Target:
Click Configure > TARGETS > Database Target.
Click Create Database Target.
Enter the name and description of the new Database Target in the Name and Description text boxes respectively.
Select the database info service and database schema service from the drop-down list of Database Info and Schema Name respectively.
Database Operation specifies how data records are inserted into database tables. Select one of the following database operations:
Insert
Update
Insert/Update
Update/Insert
Expand Advanced Properties and select the project from the drop-down list of Project.
Click Save.