Operator Guide

Back Next

Publication Source Properties for Relational Database

When you use an automatic mapping with a relational database source, the

Source

page of the publication wizard can include the following properties:

Database Connection: Data access connection from where the publication workflow reads the data to be published.
Use pushdown optimization: Fine tune the performance of data retrieval from the source database.
Define new joins by joining existing tables: Combine data from multiple source tables into a single table by creating a join or multiple joins.
A join combines columns from two or more tables in the database. You can create multiple joins, and you can combine data from joins into new joins. Joins are virtual entities, and are not created in the source database or in the topic.