Using a database as a source

Edit online

About this task

After you have used the Database Interface Designer to define a query for a database, you can use that query as an input source.

Note: You can use either a standard SQL SELECT query or a query using a stored procedure. For specific information about using stored procedures, refer to Using stored procedures.

To use a database query as a source:

Procedure

  1. Define the database using the Database Interface Designer.
  2. Define a query to extract data from the database.
  3. Generate a type tree for the query.
  4. Use the Map Designer to create a map with an input card referencing the query.