Clear Analytics Cloud configurations

Issue

• I would like to clone my environment, but an Analytics Cloud token can only be used by one DXP instance at a time.
• How do I remove the token from my cloned environment to keep it from disconnecting my original environment from Analytics?

Environment

• DXP 7.2

Resolution

This resolution includes instructions to manually alter the database. Any changes to data should be approached with caution and should be made at your own team's discretion. Please take a backup of your database prior to making any alterations.

• The configurations must be removed from the database using the following SQL queries:

update PortalPreferences set preferences =
  UpdateXML(
    UpdateXML(
      UpdateXML(
        UpdateXML(
          UpdateXML(
            preferences,'/portlet-preferences/preference[name/text()="liferayAnalyticsEndpointURL"]',''),
        '/portlet-preferences/preference[name/text()="liferayAnalyticsDataSourceId"]',''),
      '/portlet-preferences/preference[name/text()="liferayAnalyticsFaroBackendSecuritySignature"]',''),
    '/portlet-preferences/preference[name/text()="liferayAnalyticsFaroBackendURL"]', ''),
  '/portlet-preferences/preference[name/text()="liferayAnalyticsURL"]', '')
  where preferences like "%liferayAnalyticsEndpointURL%" ;

and

DELETE FROM configuration_ where configurationId like 'com.liferay.analytics.settings.configuration.AnalyticsConfiguration%'

Additional Information

• Unable to disconnect Analytics Cloud instance from Liferay DXP
• Connecting DXP to Analytics Cloud