Workflow Basics Guide

Back Next

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.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.