Skip to main content

Curious to know if there any 1st or 3rd party connectors to get capiq data directly in pigment automatically.

It’s not too difficult to upload a CSV on a monthly cadence, but would be great if there was a live connection. The alternative is to send this to an internal DWH then to Pigment, but that might be a lot of internal work from our BI teams.

Hi,

It seems that capiq has an API available. When there is no native Pigment connector the “classic” scenarios are :

  • Using a third party tool (an ETL like Talend or a datapipeline like Data Factory) to extract and push the data to Pigment or a datalake/database with a native connector (Snowflake, BigQuery, ...)
  • Program an extraction to an file storage or an SFTP folder and use the native Pigment connector : 

     

  • Manual upload (as you’re currently doing)

Reply


Ask your question here!

Terms & ConditionsCookie settings