Merging

For the JDBC connector, if the data for a single account spans multiple rows of database table, you can merge the data for successful aggregation.

To configure the merging settings, complete the following:

To discover the schema, go to Configuration > Schema and then select Discover Schema Attributes.

Note
You must discover the schema attributes before moving to the next step.
Go to Configuration > Merging and select the Data needs to be merged checkbox if the data for a single object spans multiple rows of a database table.
Select an Index Column that is used when finding like objects in the dataset.
Select Which columns should be merged from the file from which values must be merged.
Select Save.

Note

The SQL Statement should have order by clause when merging is enabled. The query should be ordered by the index columns defined in the application.

eg: select * from <Table> order by IndexKey1, IndexKey2

Feedback is provided as an informational resource only and does not form part of SailPoint's official product documentation. SailPoint does not warrant or make any guarantees about the feedback (including without limitation as to its accuracy, relevance, or reliability). All feedback is subject to the terms set forth at https://developer.sailpoint.com/discuss/tos.


	You are here:

Merging

Documentation Feedback