This article is an overview of different approaches to connect SAP with Pigment.
Table of content
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
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:
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:
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: