Content Comparison

The Database Source activity provides the an ability to fetch data from a 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_Toc401308893 

Prerequisites

Database Info activity and Database Schema must be created before creating Database Source activity.

...

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

Steps to create a Database Source Activity 

1. On the Adeptia Suite homepage, click the Develop tab.
2. Go to

   Go to Develop > Services > Source

   and then click

   > Database.

    The Manage Database Source screen is displayed (see Figure 192).

    
   
   Image Modified

   Figure 192: Manage Database Source

3. Click the CreateNew link. The Create Database Source screen is displayed.
4. Enter

    

5. Click Create New.
   
   Image Added
   
   
6. Type the name and the description of the new Database Source in the textboxes Name and Description respectively text boxes respectively.
7. 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
   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 refer to Changing Advanced Properties section.

8. Click the Save button.

...

1. drop-down list boxes respectively.
2. Expand Advanced Properties. For more information, refer to Changing Advance Properties.
3. Click Save.