Microsoft Azure Synapse SQL Connector

Back Next

Adding multiple source objects

Perform the following steps to add multiple source objects in a mapping:

Click

New

Mappings

Select

Mapping

and click

Create

In the Source Properties page, specify the name and provide a description in the

General

tab.

Click the

Source

tab.

Select the source connection and source type as

Multiple Objects

to be used for the task.

The image shows the source connection and source type for the task

In the

Objects and Relationships

section, click the arrow to open the

Action

menu and then select

Add Source Object

The image shows the Action menu from where you can add the source object

Select a source object from the list and click

The image shows the list of available source objects.

In the

Objects and Relationships

section, click the arrow next to the source object and then click

Advanced Relationship

to add related objects.

In the Advanced Relationship page, click

Add Object

In the Select Source Object page, select an object from the list and click

The image shows the list of available objects

In the Advanced Relationship page, select the required fields for the objects and create a join condition to define the relationship for all objects.

The image shows the the join condition for the objects.

You can join only two source tables. You must create an inner join to define the relationship. You must define only a join condition, not the complete join query. If the table name or column name is a reserved keyword or the table name contains special characters, enclose the name in square brackets. For example,

[AUTHORIZATION].[BROWSE]=[int].[BROWSE]

Click

Microsoft Azure Synapse SQL sources in mappings

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal