Database Source activity provides an ability to fetch data from a table of a database.
Prerequisites
Database Info activity and Database Schema must be created before creating Database Source activity.
Steps to create a Database Source Activity
Go to Develop > Services > Source > Database.
- Click Create New.
- 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 Properties. For more information, refer to Changing Advance Properties.
- Click Save.