Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Corrected links that should have been relative instead of absolute.

Database Source activity provides an ability to fetch data from a table of a database. 

Prerequisites

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 how to create a new Advanced Database Source Activity.

Prerequisites

Ensure that you have created Database Info activity and Database Schema must be created before creating Database Source activity.

Steps to To create a Database Source Activity activity:

  1. Go to DevelopServices > Source > DatabaseImage Removed

    Image Added

     


  2. Click Create New.
    Image Removed
    Type
    Image Added

  3. On the New Database Source window, type the name and the description of the new Database Source in the Name and Description text boxes respectively.
  4. Select the database info activity and database schema activity from the Database Info and Schema Name drop-down list boxes respectively.
  5. Expand Advanced PropertiesProperties to set the advanced properties related to the activity. For more information, refer to Changing Advance Advanced Properties.
  6. Click Save.