Exporting LDAP groups in Administration Manager

Exporting LDAP groups in Administration Manager

The Export tab of the Administration Manager lets you export the current groups from the Spotfire Database on the server. This way, you can import and reuse the information on a different server if you need to change servers. When exporting the groups from the Administration Manager in the TIBCO Spotfire Analyst client via the following steps, you may see that LDAP groups are not included in the exported list.

1. Launch the TIBCO Spotfire Analyst client
2. Click on "Tools" menu
3. Select "Administration Manager"
4. Click on "Export" tab
5. Click on "Export Groups" to export all the groups

User groups can be exported, but LDAP synchronized groups are not exported using the "Export groups" option in Administration Manager. This is by design since this feature is used for managing the user-managed groups, not groups synchronized from external systems (which would be automatically synchronized based on the TIBCO Spotfire Server LDAP configuration). 

Note: Both user groups and LDAP synchronized groups can be exported when the user group is at top level and LDAP group is the child of user group when you have selected "Include member groups" in Export tab.

To export all groups from the Spotfire environment, you can query the GROUPS table in the Spotfire application database with a query like:

SELECT * FROM GROUPS

Note: Externally synced groups that match the current LDAP group synchronization configuration will have GROUPS.CONNECTED = 1

Disclaimer: The content of this article is for informational purposes only. The subject material may change in any new versions with no notice and there is no responsibility by TIBCO to maintain or support future access to this internal application content. Modification of any internal application content is not recommended and can lead to an unsupported configuration.  It is not intended to be used "As Is" in a Production environment. Always test in a Development environment.
  Doc: export-groups

• https://docs.tibco.com/pub/spotfire_server/7.11.1/doc/html/TIB_sfire_server_tsas_admin_help/GUID-B15CFD0C-BB7F-483B-857D-7CFA9B8F7C2A.html