Database Source activity fetches data from the table of a database. This section describes how to create a Database Source activity.
Prerequisites
Ensure that you have created Database Info activity and Database Schema.
To create a Database Source activity:
- Go to Account and click Manage Objects.
- Click SOURCES > Database Source.
- Click CREATE Database Source.
- On Create Database Source window, enter the name and description of the new Database Source in the Name and Description textboxes respectively.
- Select the database info activity and database schema activity from the Database Info and Schema Name.
- Expand Advanced Properties to set the advanced properties related to the activity.
- In the Query Definition, database query is displayed in the XML form. The database query is displayed only if you have edited the query. If you edit the query displayed in the Query Definition then database query defined using Edit Query is overwritten.
- Use Optimize Algorithm: This algorithm sorts the parent table with the Primary Key and all subsequent child tables with the joining key of their parent table. This algorithm applies only, if all the child tables of the parent table, at any level, are related to the parent table by the same key. Selecting this check box makes data fetching from the source database table faster. Select this check box if the database source is MS SQL.
Select With (NoLock) Option checkbox to fetch the records from the source database without any lock constraint. Select this check box if the database source is MS SQL.
- Select the project of the activity from the drop-down list of Project.
- Click Save.