Fetch Data from Datamart

This example shows how to fetch data from a Datamart with the name 1669.DMDS. You can define a filter if needed.

XML

<route>
    <from uri="timer://fetchDataFromDatamartByQuery?repeatCount=1"/>
    <to uri="pfx-api:fetch?objectType=DM&amp;dsUniqueName=1669.DMDS&amp;batchedMode=true&amp;batchSize=5000"/>
    <split>
        <simple>${body}</simple>
        <to uri="pfx-api:fetchIterator"/>
        <log message="${body}"/>
    </split>
</route>

DsUniqueName can be used to get data from Datamart, Datamart Data Source or Data Feed.

Type of Data Source	Pattern
Datamart	id.DM
Data Source	id.DMDS
Data Feed	id.DMF