Page Comparison

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  This section describes how to create a new Advanced Database Source Activitya Database Source activity.

Prerequisites

Ensure that you have created Database Info activity and Database SchemaLayout.

To create a Database Source activity:

1. Go to Account and click Manage Objects.
   
   Image Added
   
   
2. Click SOURCES > Database Source.
   
   Image Added
   
   
3. Click CREATE Database Source.
   
   Image Added
   
   
4. On Create Database Source window, enter the name and description of the new Database Source in the Name and Description textboxes respectively.
   
   Image Added
   
   
5. Select the database info activity and database schema activity from the Database Info and Schema Name.
6. Expand Advanced Properties to set the advanced properties related to the activity.
   
   Image Added
   
   
7. 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.
8. 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.

9. 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.

10. Select the project of the activity from the drop-down list of Project.
11. Click Save.