Operator Guide

10.4.1
- 10.5
- 10.4.0

Back Next

Step 3. Select Publication Source

Select the publication source from which

Data Integration Hub

reads data in the

Source

page of the publication wizard.

Select a connection from the

Database Connection

list.

The

Define new joins by joining existing tables

section appears.

Optionally, create joins for the publication.

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.

To create joins, perform the following actions:

By default, the

Source

page shows the default schema only and the default schema is selected for both the left and right tables. To select non default schemas, clear the option

Show default schema only

and then select schemas for the left right tables.

When you select non default schemas, do not use two source tables with the same name from different schemas to define the join. The source table names that you use to create the join must be unique across the schemas.

Select the tables to join from the

Select Left Table

and

Select Right Table

lists.

Select the join type from the

Select Join Type

list and then enter the join name in the

Join Name

field. The name that you assign to the join shows in the

Field Mapping

page, where you can map the join to a topic table.

Select the column to join from the left table and then select the column to join from the right table. To add more columns to the join click the plus sign and then select the columns to join.

Click

Create Join

The new join appears on the

Source

page.

Repeat step 2 to create as many joins as required.

Click

The

Field Mapping

page appears.

Creating an Automatic Relational Database Publication

Download Guide