Database Source activity provides an ability to fetch fetches data from a table of a database.
Prerequisites
Ensure that you have created Database Info activity and Database Schema must be created before creating Database Source activity.
Steps to To create a Database Source Activity activity:
Go to Develop > Services > Source > Database.
- Click Create New.
Type - On the New Database Source window, type the name and the description of the new Database Source in the Name and Description text boxes respectively.
- Select the database info activity and database schema activity from the Database Info and Schema Name drop-down list boxes respectively.
- Expand Advanced PropertiesProperties to set the advanced properties related to the activity. For more information, refer to Changing Advance Advanced Properties.
- Click Save.