Create a new source

For Foundry to connect to the Palantir Foundry Connector 2.0 for SAP Applications ("Connector"), a source needs to be configured in the Data Connection app. The configuration requires an agent, user credentials for the connection, and the URL for the SAP Source System.

To create an SAP source follow these steps:

  1. Navigate the Data Connection app in the sidebar.

  2. Select Add Custom Source option.

  3. Choose the connection Via an agent option.

  4. Give the source a name and location.

  5. Complete the Source Setup requirements:

    • Select the Agent in the SAP network.
    • In the custom YAML section, fill in the definition as follows.
      Copied!
      1 2 3 type: magritte-sap-source url: https://<host>:<port>/sap/palantir usernamePassword: <username>:{{password}}
      • The username and password are those for the technical user that was created for Foundry to use to connect to SAP.
      • The host is where the relevant SAP application server is located.
      • The port is the default HTTPS (or HTTP) port for ICM (the Internet Communication Manager), a component of the SAP application server.

      The expression {{password}} should be written as it appears. You can then enter the password under Encrypted values on the right of the dialog box and it will be encrypted.

  6. Save the source definition.

Configuration

These are the extra parameters that can be configured on the source.

ParameterRequired?DefaultDescription
urlYThe base URL of the SAP add-on service endpoint.
usernamePasswordYThe username and password are those for the technical user that was created for Foundry to use to connect to SAP.
useKernelJsonSerializationNfalseSwitch on kernel JSON serialization for paginated data returned from SAP. Only works for JSON formatted data: checks will fail if set to true when useTsvFormat:true.
useTsvFormatNfalseSwitch on using TSV format for paginated data returned from SAP (vs JSON).
outputN50,000 rowsDefinition of the maximum file size (rows or bytes) that will be returned from SAP.
convertDatesToStringsNfalseIngest all dates as strings for this source.
proxyNNoneProxy configurations for connecting to SAP.
cacheConfigurationsNNoneCache configurations for configuring cache timeouts for different SAP Object types.

Configuring the maximum size of each Parquet file

The maximum file size of each Parquet file in Foundry datasets can be defined on a specific sync (for that specific sync) or on the Source (for all syncs).

If you would like to change the maximum size of each Parquet file for all syncs under a given source, you can configure this in the source config.

Examples:

Copied!
1 2 3 4 5 output: maxFileSize: type: rows rows: max: 10000
Copied!
1 2 3 4 5 output: maxFileSize: type: bytes bytes: approximateMax: 400MB

Specifying the maximum size in bytes is only approximate. The resulting file sizes might be slightly smaller or larger.

If specifying a maximum size in bytes, the number of bytes needs to be at least twice as large as the in-memory buffer size of the Parquet writer (which defaults to 128MB).