3795515 - How to Configure a File Server Import Connection in SAP Analytics Cloud

 How to configure an import connection via File Server in SAP Analytics Cloud.

 Prerequisite: The Cloud Connector and Cloud Agent must be installed and configured before proceeding.

  - Installing the Cloud Connector
  - Configuring the Cloud Connector
  - SAP Analytics Cloud Agent

  ---

Configure an Import Connection via File Server

  1. Configure the File Server allowlist

  You can use the existing allowlist files in the Cloud Agent config folder:

  - fileServerWhitelist.txt (import)
  - fileServerExportWhitelist.txt (export)

  Or create a new allowlist.txt file following the rules below:

  - Encoding: UTF-8
  - Each line must contain only one allowed path (all descendant paths are automatically allowed)
  - Windows: C:\folder1\folder2 or \\servername\volume\path
  - Linux: /net/abc/

  ---

 2. Register the allowlist file

  Choose one of the methods below:

  Option A – Tomcat JVM properties

  In the Apache Tomcat GUI, go to the Java tab > Java Options and add:

  - Import: -DSAP_CLOUD_AGENT_FILE_SERVER_WHITELIST_PATH=<full_file_path>
  - Export: -DSAP_CLOUD_AGENT_FILE_SERVER_EXPORT_WHITELIST_PATH=<full_file_path>

  Option B – Operating system environment variable

  Set the environment variable SAP_CLOUD_AGENT_FILE_SERVER_WHITELIST_PATH or
  SAP_CLOUD_AGENT_FILE_SERVER_EXPORT_WHITELIST_PATH to the full path of the file, including the filename (e.g.,
  C:\path\allowlist.txt).

After setting the variable, restart Tomcat:

  - Command line: shut down the existing Tomcat process, add the environment variable, then start Tomcat from a new
  command line window.
  - Windows service: restart the Tomcat service using the Tomcat Configuration Manager.

  Then restart the SAP Analytics Cloud Agent.

  Note: Changes to the allowlist environment variable only take effect after the agent is restarted. After restarting, allow up to one minute for the changes to apply.

  ---

3. Enable File Server in SAP Analytics Cloud

  1. Go to Main Menu > System > Administration > System Configuration.
  2. Select Edit.
  3. Enable Allow model import from File Server (import) and/or Allow model export to File Server (export).
  4. Select Save.

  ---

 4. Create the connection in SAP Analytics Cloud

  1. Go to Main Menu > Connection > Connections.
  2. Select Add Connection > Import Data Connection > File Server.
  3. Fill in Connection Name, Description, and Folder Path (must match the path defined in the allowlist).
  4. Select Create.

  ---

  5. Create a model based on the File Server connection

  Create a Model from a File

• Installing the Cloud Connector
• Configuring the Cloud Connector
• SAP Analytics Cloud Agent
• Create a Model from a File
• KBA 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• KBA 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
• KBA 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• SAP Analytics Cloud Connection Guide
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support 

Your feedback is important to help us improve our knowledge base.

SAP Analytics Cloud, SAC, File Server, import connection, Cloud Agent, Cloud Connector, allowlist, fileServerWhitelist, fileServerExportWhitelist, Tomcat, JVM, environment variable, model import, model export, import data connection , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , How To