Data Merging Support

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

For the usage of the REST APIs for the following attributes and keys, refer to:

• API to get source details:

  https://developer.sailpoint.com/docs/api/v2024/list-sources

• API to get specific source’s current schema details:

  https://developer.sailpoint.com/docs/api/v2024/get-source-schemas/

• API to add new schema attribute to source:

  https://developer.sailpoint.com/docs/api/patch-requests/#add

For example, if you want to merge data of the attributes such as email and phone, you can use the REST API to set the mergeRows attribute and use the value as true.

If you want to merge the columns, set form-data values as follows:

• key: use the indexColumns attribute key

  value: the value of this key must be the name of the column or list of columns that you want as index column for merging. For example, you can you use value in a format such as:

  [<IndexKey1>, <IndexKey2>,...<IndexKeyn>]

• key: use the mergeColumns attribute key

  value: the value of this key must be the name of the column or list of columns that you want to merge with the index column. For example, you can you use

  value in a format such as:

  [<MergeKey1>, <MergeKey2>,...<MergeKeyn>]