Exercise: Data Integration Deep-Dive
Take some time to more deeply understand the “mechanics” in Apliqo FPM when integrating and adjusting data. The goal in this exercise is to build a custom app in the same fashion as we recommend implementing it for the client / end users.
Prerequisites
Create the following entities in the FIN Company dimension:
Download this Excel Workbook, which contains multiple tabs with data to be loaded as part of the exercise.
Connectors
If a pre-built connector exists for the customer’s source system it should be leveraged. Currently the following connectors are available and documented separately.
Custom data integration
If a pre-built connector is not available or is not used because of special requirements, custom TI processes can be used to import data from a source system. For this process to work seamlessly with the Apliqo FPM data integration framework you should understand the concept of the “roundtrip” that moves data through the system a bit more deeply and follow some guidelines. Learn more about this in the following chapters: