This article shows how to extract the aggregation data for the Adobe Creative Cloud connector before importing it into the Snow License Manager (SLM) portal.

1. On the Snow License Manager server, open services and stop the following services:
 

• Snow Software Adobe CC Service
• Snow License Manager AdobeCC BFF
• Snow Software Event Warehouse Service

2. In Snow Integration Manager (SIM) open the Connector options and check that your Adobe connector is configured correctly.

3. Select aggregate selected for the Adobe connector. 

4. Once finished, you can validate the SnowLicenseManager.adobecc.Import table to confirm that there is data in the row, using the following query:
 

select * from SnowLicenseManager.adobecc.Import

5. In order to export this information, we first need to generate a script to export the data of the table.  In SQL Server Management Studio right-click on the SnowLicenseManager database select Tasks and Generate Scripts.



6. It will open a new window to generate the script. In the Introduction section click Next. Then click Select specific database objects and then select the adobecc.import table:



7. Select Save to file. Set the path and the filename to save the data. Click Advanced and select Data Only for Types of data to script:

 

8. Review your selections and click Next and Finish. The data will be within a .sql file in the path selected.

9. On the Snow License Manager server, open services and start the following services:

• Snow Software Adobe CC Service
• Snow License Manager AdobeCC BFF
• Snow Software Event Warehouse Service