Database Source activity provides an ability to fetch data from a table of a database.
Prerequisites
Database Source activity fetches data from the table of a database. It is recommended that you use Advanced Database Source Activity. With this, you can fetch data from multiple tables of a database. Click here to know how to create a new Advanced Database Source Activity.
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.