Skip to main content
Solved

Has anyone tried integrating CAPIQ with Pigment for public company benchmarking?

  • February 10, 2024
  • 1 reply
  • 294 views
R
Apprentice Author
Forum|alt.badge.img

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.

Best answer by CamilleMomo

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)

1 reply

CamilleMomo
Master Author
Forum|alt.badge.img+14
  • CamilleMomoMaster Author
  • Master Author
  • Answer
  • February 23, 2024

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)

Camille
Benji

Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement