Pipedrive Datawarehouse

Jens Bohse
Jens Bohse Member Posts: 20
10 Comments Second Anniversary 5 Likes Name Dropper
edited July 2022 in Sales CRM #1

Is there a good tool that can load the Pipedrive data into our data warehouse? We are currently using Stitchdata and the integration for Pipedrive from Singer, but it doesn't work well with the deals products yet. However, once products are removed from a deal, they are not removed from the data warehouse or marked as inactive. This breaks our forecasting and sales reporting. Does anyone know of a solution or possibly a better tool?


  • Andre Vill
    Andre Vill Member Posts: 136
    Third Anniversary 100 Comments Name Dropper 5 Likes
    edited July 2022 #2

    Hi Jens!

    Sadly can't suggest any specific software, just sharing my experience with this. 

    We haven't found an integration that would do this flawlessly. The only way to be sure is to get custom development for it from a 3rd party developer. That at least our experience.

    Best Regards,

    Andre V
    Dominate Sales

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,363
    1000 Comments Third Anniversary 100 Likes 5 Answers
    edited July 2022 #3

    The only thing I have seen work is a periodic backup of the data across all objects. I wrote an article to cover how this works for my Pipedrive clients. 

  • Akhil_Supermeet.ai
    Akhil_Supermeet.ai Member Posts: 67
    10 Comments First Anniversary Name Dropper Photogenic
    edited July 2022 #4

    Hi, @Jens Bohse We recently used Pipedrive APIs to move data to our warehouse which is Postgresql with 2-way sync using Rest APIs and webhooks that ensure real-time updates.

    My general experience is that either you use a Datawarehouse that has native integration with Pipedrive or make use of APIs to do the way you want. I wanted to use Segment but it doesn't have native integration!.

    We haven't worked with Stitch, but might be able to give some insights. Feel free to connect- https://www.linkedin.com/in/akhilks1/