Connect Pigment with SAP

  • 30 January 2024
  • 0 replies
  • 155 views
Connect Pigment with SAP
Userlevel 2
Badge +2

This article is an overview of different approaches to connect SAP with Pigment.

Table of content

 

CSV export

You can configure scheduled CSV exports from SAP and store the outputs either on an SFTP server or in a file storage service in the cloud. This is usually the easiest setup to get started, but might not be the most flexible (see “ETL and iPaaS” below for more advanced solutions).

 

Import from SFTP server

Once the CSV export is configured on the SAP side and is stored on your SFTP server, you can import directly from Pigment using the native connector. 

The article below explains how to connect an SFTP server with your Pigment workspace to import any CSV file:

 

Import from a cloud file storage service

Once the CSV export is configured on the SAP side and is stored on your cloud storage, you can import directly from Pigment using a native connector.

These articles explain how to connect popular cloud storage services with your Pigment workspace to import any CSV file:

 

ETL and iPaaS

Below is a non-exhaustive list of third-party solutions that can be implemented to export SAP data and import it into Pigment.

 

SAP Integration Suite

SAP offers its own iPaaS solution called Integration Suite, and their Open Connector approach can easily be integrated with Pigment’s Import API:

 

MuleSoft

MuleSoft has several connectors for SAP depending on how you want to export the data. For a list of these SAP connectors, check out the MuleSoft documentation here.

You can connect Pigment with MuleSoft following our extensive guide:

 

Fivetran

Similar to MuleSoft, Fivetran offers several SAP connectors to export data from the ERP to popular data lake or data warehouse services. For a list of these SAP connectors, check out the Fivetran documentation here.

Once the export is configured, to import the data you can use one of Pigment’s native connectors for file storage services (see the list above) as well as the following data lake and data warehouse solutions:

 

Pigment API

If you already have API-based integrations or want the maximum flexibility, you can also use Pigment’s import API which takes a CSV payload as input and can be called from anywhere:

 


This topic has been closed for comments