-
1. Re: Export the details of Active Directory Users
Srikanth Vishnuvajhala Aug 9, 2013 7:33 AM (in response to Arun.Shukla)Arun,
What is the PowerCenter version you are trying to export the users from? If you are working on version 9.x then you can use the attached script. This script will export the LDAP users into a csv file. Make sure to run the script from $INFA_HOME directory.
This script runs a bit slow as it relies heavily on infacmd statements. Let me know if you have any questions.
Thanks,
Srikanth
-
GetUserGroupPrivileges.sh 6.2 KB
-
-
2. Export the details of Active Directory Users
Arun.Shukla Aug 9, 2013 7:29 AM (in response to Srikanth Vishnuvajhala)Hi Srikanth,
Currently I am using Powercenter 8.6.1.
Would this script works for me.?.
thanks
Arun
-
3. Export the details of Active Directory Users
Srikanth Vishnuvajhala Aug 9, 2013 7:36 AM (in response to Arun.Shukla)No. It won't work for 8.x. Check the below link for 8.x.
https://communities.informatica.com/docs/DOC-7332
Thanks,
Srikanth
-
4. Export the details of Active Directory Users
Arun.Shukla Aug 9, 2013 8:28 AM (in response to Srikanth Vishnuvajhala)Hi Srikant,
I checked the link but it is not staisfying my requirements.
Thanks
Arun
-
5. Export the details of Active Directory Users
Srikanth Vishnuvajhala Aug 9, 2013 8:41 AM (in response to Arun.Shukla)If your requirement is only to export PowerCenter LDAP users, then the shared link should be able to resolve your problem. If not, then you will have to figure out other options.
Srikanth
-
6. Export the details of Active Directory Users
yagrawal Aug 11, 2013 1:32 AM (in response to Srikanth Vishnuvajhala)Hi Srikanth -
THe document that you shared have the following known limitation:
Known Limitations
- Only Native users can be fetched using this tool. LDAP users cannot be fetched.
So, I suppose the tool will not satisfy the requirment of Arun..
-
7. Export the details of Active Directory Users
yagrawal Aug 11, 2013 1:33 AM (in response to Arun.Shukla)1 of 1 people found this helpfulCheck this KB:
FAQ: Can LDAP Users and Groups be exported or imported? Answer
LDAP Users and Groups cannot be exported or imported.
A feature request (FR 183397) has been submitted for a new command for exporting LDAP Users and Groups.
The exportUsersAndGroups and ImportUsersAndGroups commands support only the native users and groups.
-
8. Export the details of Active Directory Users
Srikanth Vishnuvajhala Aug 12, 2013 5:13 AM (in response to Arun.Shukla)Arun,
I agree with you and Yogesh. It does not work for LDAP users. Raise a case with Informatica and explain the requirement. They might propose some alternative. I did the same in the past and they gave me a script to extract LDAP users.
Thanks,
Srikanth
-
9. Export the details of Active Directory Users
Arun.Shukla Aug 12, 2013 6:26 AM (in response to Srikanth Vishnuvajhala)Hi Srikanth/Yogesh,
Thansk for your response on this.
Just to clarify that i donot need to Active directory details for any authentication purpose as we do in Informatica admin console for LDAP authentication.
I need details to be used in mappings that is related to Data Quality.
Will informatica team still assist in this case.
Thanks
Arun
-
10. Export the details of Active Directory Users
Srikanth Vishnuvajhala Aug 12, 2013 6:43 AM (in response to Arun.Shukla)1 of 1 people found this helpfulIf your requirement is just to extract the LDAP users and use the extract file to perform whatever the task you are asked to do, then you can request Informatica to provide some solution for the extract. There is another option you might want to consider is to use PWX for LDAP.
PWX for LDAP will have a component called CDC where it captures the real-time changes on the LDAP directory and push the changes into the target using the designer objects.
Thanks,
Srikanth
-
11. Export the details of Active Directory Users
Arun.Shukla Aug 12, 2013 6:55 AM (in response to Srikanth Vishnuvajhala)Thanks Srikanth,
Will contact Informatica team for any workaround other than Powerexchange>
Will share the solution if provided by Informatica team.
Arun
-
12. Re: Export the details of Active Directory Users
Srikanth Vishnuvajhala Aug 12, 2013 10:56 AM (in response to Arun.Shukla)Hi Arun,
I just tried the attached script on 861 Domain after making few changes to make it work for 861; and it worked. Please find attached modified script. Pass your current Native username and password into the script and use the flag 'skipnative' to extract only the LDAP users.
Execution:
./GetUserGroupPrivileges_861.sh -dn TC_DMN_DEV -un srikanth/Native -pd xxxxx -skipnative
-Srikanth
Message was edited by: Srikanth Vishnuvajhala