There can be situations when the main data object (source) cannot be represented by any single out-of-the box object.
In this case you may need to switch to the "Source Designer" mode to create your own Composite Source.
This is advanced functionality and requires deep understanding of data model.
Two most common reasons for creating your own source are:
- Need to bypass data caching due to very large amounts or volatility of data.
- Requirement to join multiple data objects by specific key and join type (other than inner join)
Switch to Source Designer mode by clicking on the "Source Designer" tab at the bottom of the screen:
You will get warning popup, click Yes to proceed:
The main data object chosen during interface creation will be shown on the left. The Vocabulary grid appears on the the right.
The The layout of the Source Designer tab is very similar to that of taxonomy mapping. It has the main Data Object and one or many mashups linked to it.The The main differences areinclude:
- The
When you use Source Designer mode, the destination grid is named
"Vocabulary
". The value mapped into it
will becomebecomes your Source when you switch back to Taxonomy mapping
. The mashups you add here
willallow you to specify a custom join key and join type
To use Source Designer mode:
After you select the main data object for your interface and click Create, you see the EDS Worksheet.
You can select the Source Designer mode by clicking the Source Designer tab at the bottom of the page.
You see the Source Designer Mode box with the following warning.
Vocabulary
...
Click Yes to proceed.
The main data object chosen during interface creation appears on the left. The Vocabulary grid appears on the right. By default, all main data object fields already mapped into taxonomy
...
are mapped into Vocabulary as well.
...
You can change this mapping according to your task requirements.
...
Vocabulary is the Composite Source of your interface.
...
All fields that have been mapped to Vocabulary automatically go to the Source in the Taxonomy Mapping worksheet as well.
To check that, click
...
the Taxonomy Mapping tab
...
.
...
Noteinfo |
---|
The fields you mapped into vocabulary will are not automatically be added to the extract. You have to map them from your Composite Source to the Taxonomy. |
...