Advanced Database Source

Advanced Database Source service fetches the data from the table of a database. This section describes how to create an Advanced Database Source service.

Prerequisites

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

To create an advanced database source:

1. Click Configure > SOURCES > Advanced Database Source.
   
2. Click Create Advanced Database Source.
   
3. Enter the name and description of the new Advanced Database Source in the Name and Description textboxes respectively.
   
   
   
   
4. Select the database info activity and database schema activity from the Database Info and Schema Name.
5. Expand Advanced Properties to set the advanced properties related to the activity.
   
   
   
   
6. 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.
7. 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.

8. Select With (NoLock) Option check box to fetch the records from the source database without any lock constraint. Select this check box if the database source is MS SQL.

9. If required you can override the default fetch size value in Fetch Size field by setting the size you need. If you leave this field blank, Adeptia Connect will set its value to default.
   Fetch Size refers to the number of records being fetched from the database. Higher fetch size retrieves a higher number of records at a time, improving the performance by reducing the number of hits to the database. For example, if you have 1000 records in the Database, and you set the Fetch Size value as 200, it fetches 200 records every time it hits the Database – five times in this case. Once all the data has been fetched, the Process Flow moves to the next step.
   You can set your own fetch size to override the default size and improve the performance. If you leave it blank or enter 0 (Zero), it considers the default fetch size defined in the database.
   
10. Select the project of the activity from the drop-down list of Project.
11. Click Save.