Connectors allow mapping one or more External Data Descriptors with an Application Data Interface.
You can configure the Insert Connectors for data exchange.
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:
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. |
|
This is displayed on the connector window when the connector is published and is opened in view mode. The connector is not editable. |
|
This is displayed on the connector window when the connector is not published. The connector is editable. |