Content Comparison

The Database Source activity provides the ability to fetch fetches data from a the table of a database. Consider that the details of all the employees are stored in a single database. Now, you will be required to fetch the details from a single table of a database. Therefore, while creating the process flow for the same, you will be required to create a Database Source Activity. However, to create a Database Source Activity, you will be required to consider the mentioned prerequisites.
This feature is available in:

Anchor_Toc344890154_Toc344890154 Anchor_Toc385441462_Toc385441462 Anchor_Toc387747298_Toc387747298 Anchor_Toc387748569_Toc387748569 Anchor_Toc401308893_Toc401308893Prerequisites 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

...

.

This section describes how to To create a Database Source activity using the following details as an example:

Steps to create a Database Source Activity 

...

Go to Services > Source and then click Database. The Manage Database Source screen is displayed (see Figure 192).

Image Removed

Figure 192: Manage Database Source

...

:

1. Go to Develop > Services > Source > Database. 

   Image Added
   
   

2. Click Create New.
   
   Image Added
   
   
3. On the New Database Source window, type the name and description of the new Database Source in the textboxes Name and Description respectively.
4. Select the database info activity and database schema activity from the dropdown lists the Database Info and the Schema Name respectively (see Figure 193).
   

   Image Removed
   Figure 193: Create Database Source

   Info
5. To learn how to create Database Info activity, refer to the Creating Database Info section. To learn how to create the Schema activity, refer to the Creating Database Schema section.
To learn about Advanced Properties .
6. Expand Advanced Properties to set the advanced properties related to the activity. For more information, refer to Changing Advanced Properties section.
7. Click the Click Save button.

...