Solved

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

  • 10 February 2024
  • 1 reply
  • 59 views

Badge

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.

icon

Best answer by CamilleMomo 23 February 2024, 15:45

View original

1 reply

Userlevel 2
Badge +9

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