Pipedrive Datawarehouse

Jens Bohse
Jens Bohse Member Posts: 21 VERIFIED MEMBER
Third Anniversary 25 Up Votes 10 Comments 5 Likes
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?

Answers

  • Andre Vill - DominateSales.io
    Andre Vill - DominateSales.io Member Posts: 148 VERIFIED MEMBER
    Fourth 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,613 VERIFIED MEMBER
    1000 Comments 250 Likes Fourth Anniversary 25 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: 66 VERIFIED MEMBER
    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/

     

  • crmcraft
    crmcraft Member Posts: 1 VERIFIED MEMBER
    First Comment

    i know www.mycrmbackup.com is working on such solution. Ping them with your requirements - they should help out