Although role-based SQL security is recommended, you can use hybrid mode.

  1. Using SQL Server Management Studio, you should now add a Login for the Anaplan XL application pool user.  If the default Anaplan XL application pool is used with the Application Pool Identity, then you can use IIS AppPool\Anaplan XL as the Windows Authentication login name. For more information, view Creating default IIS application pool user in SQL.
  2. On the User Mappings screen, map that user to the XLCUBED_USER role
  3. If any users should be able to administer the repository, map those users to the XLCUBED_ADMIN role

If the file system is your chosen location for storing the reports, then no further configuration is necessary.

If you want to store the reports in SharePoint, you need to add this line to the Anaplan XL Web web.config file.

<add key="SharePointServerUrl" value="http://sharepointserver"/>

Where sharepointserver is the SharePoint web server address. Then to publish Excel users should connect directly to SharePoint, for scheduling. For Mobile app access, they should connect to the Anaplan XL Web server

Continue setting up SharePoint with the SharePoint Integration guide.