Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Session Properties Reference
  17. Workflow Properties Reference

Working with Relational Sources

Working with Relational Sources

When you configure a session to read data from a relational source, you can configure the following properties for sources:
  • Source database connection.
    Select the database connection for each relational source.
  • Treat source rows as.
    Define how the Integration Service treats each source row as it reads it from the source table.
  • Override SQL query
    . You can override the default SQL query to extract source data.
  • Table owner name.
    Define the table owner name for each relational source.
  • Source table name.
    You can override the source table name for each relational source.