Connectors

Connectors allow mapping one or more External Data Descriptors with an Application Data Interface.

You can configure the Insert Connectors for data exchange.

Icons and Description

To create a connector, you must understand each of the icons at the beginning. While creating a Connector, the icons that are displayed are explained as follows:

Icons and Description

Icon

Description

Click this icon to view the list of all External Data Descriptors created in the setup. You can drag the desired EDD on the canvas.

Click this icon to view the list of all ADIs created in the setup. You can drag the desired ADI on the canvas.

Click this icon to open the Mapping window. You can map the source column to the target column in the window.

This component is used for defining a join between two entities. Click this icon to open the window where you can define the join condition between two entities.

This component is used for defining the filter of a given entity. Click this icon to open the window where you can define the filter condition.

This component is used for defining the lookup condition. Click this icon to open the window where you can define the join condition between two entities.

This component is used for defining the Derived column. Click this icon to open the window where you can define an expression, which can be mapped to the target column.

This component is used for transforming flattened hierarchy entities into parent-child hierarchy entities.

This component is used for Transpose (Rows to Columns) for a given entity. Click this icon to open the window where you can define the pivot data element and the new columns, which are transposed from multiple rows of source entity.

 

This component is used for Transpose (Columns to rows) for a given entity. Click this icon to open the window where you can define the unpivot data element and new rows which are transposed from columns of the source entity. 

This component is used for defining a group by and having a clause for Aggregation. Click this icon to open the window where you can define a group by and having a clause for aggregation.

Click this button to remove all the nodes added to the canvas.