Identity Portal export users data on CSV

[Daniele Panichi]

Hi guys,

do you know the best way to export users data on CSV file from Identity Portal ? 
Some end users needs to export user data stored in IDM user store to an CSV file.

Thanks

[Iyes Dendeni]

You can create a small Kettle PDI script with an LDIF input step, filter out data and write the output to csv. Pentaho Data Integration ships with our CA Identity Suite solution (it is optional during the installation of the provisioning components and tools).

Alternatively, you can use an LDAP browser to export the entire sub-tree of users to an LDIF file; then use an offline utility like ldif2csv to convert the LDIF data to csv.

[Daniele Panichi]

Thanks for your quickly reply. We already have PDI on Provisioning Server (separate server) and it's very easy create a report with Kettle but this process must be invoked on Identity Portal interface. 
I'm tring with a "fake" create user form with just a checkbox field that invoke a java plugin that start a script on IDP server (it's a linux machine) but should handle the task error message.