Creating Database Source Activity

The Database Source activity provides the 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:

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 Services > Source and then click Database. The Manage Database Source screen is displayed (see Figure 192).

   

   Figure 192: Manage Database Source

3. Click the CreateNew link. The Create Database Source screen is displayed.
4. Enter the name and the description of the new Database Source in the textboxes Name and Description respectively.
5. Select the database info activity and database schema activity from the dropdown lists Database Info and the Schema Name respectively (see Figure 193).
   

   
   Figure 193: Create Database Source

   • 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.
6. Click the Save button.