Loome Integrate Online supports loading data into Kepion Planning from any source connection, allowing for the population of Kepion Fact and Dimension tables.
When creating a Kepion Planning connection, the connection details are that of the Kepion Planning Application Database you wish to connect to.
It is recommended that when connecting to Kepion Planning that you use the Kepion Server Identity account to connect or a login with the same permissions.
Unlike the standard Data Migration format of duplicating the source schema into the target schema, Kepion Migrations require the user to map a source table to the target Kepion Dimension or Fact.
When Kepion is selected as a target in a Data Migration, you will be prompted with a custom view for configuring the migration.
The Custom view will allow you to map the source columns to the Target Kepion Column Mapping.
Kepion has 3 different Load types that are supported by Loome Integrate Online.
A Dimension Hierarchy Load Type requires a Source Table, Dimension, Load Into Hierarchy and Parent Column
The Source Column of the Source Table can then be mapped to the Kepion Dimension Member
A Dimension Member List Load Type requires a Source Table, Dimension, Load Into Hierarchy
The Source Column of the Source Table can then be mapped to the Kepion Dimension Member
A Static Partition Table Load Type requires a Source Table, Partition Table, Partition Load Type
The available Partition Load type options are:
The Source Column of the Source Table can then be mapped to the Kepion Partition Table along with a Dimension Mapping.