Certify ACF2 Datasets and Resources

Hi,

We are looking to certify the ACF2 Dataset and Resources but the ACF2 OOTB connector in IIQ does not support aggregation for these entities so we have created a flat-file connector to aggregate data. We are exporting the Users, Resources, and Datasets from ACF2 but we are not getting the UserID in Resources and dataset export so we cannot create proper links for users. Looking for some idea how we can get the Userid in Resources or Dataset exports. or if we can use “acf2_UID_string” to enrich data between user, resource, and datasets.

Adding examples for all the three entities below:

User Export:
| LID|NAME|PHONE|CSWHO|DSPREFIX|CANCELFLG|SUSPENFLG|
| ISOSEP1 |PHILLIPS STEPHANIE |348246| |ISOSEP1 |N |N |

Dataset Export:
|KEY|PREFIX|DATASET_MASK|UID|READ|WRITE|EXEC|
|$ENDEV#A|$ENDEVOR|$ENDEVOR.ADMIN.-.-.SIGNOVR.-|0998*DEV|A||A|

Resource Export:
|KEY|LINE|UID|PRIVLVL|PRIV1|PRIV2|
|DCOLDBG*******************|DCOLDBG*******************|0998F00DBAJOBDBA********|A|CREATEIN|PACKADM|

Thanks in advance. Any help on this would be appreciated.