Live data from Hacker News

Grouparoo: Open-source app to sync customer data with 3rd party tools

grouparoo.com

31–40 of 43 posts

Re: Grouparoo: Open-source app to sync customer data with 3rd party tools

#31
post #29
post #3

Thanks for checking us out! Co-founder here, happy to answer any questions. There is so much to do in this space, but we’re excited to be getting started. No engineer wakes up in the morning excited to sync data to Marketo, so we started there - `npm install` and so you can get back to building the core product. We make data self-serve for your non-technical colleagues and we handle all the exhausting integration stu…

How does this compare to Piesync? There are many tools that do one-way integration from source to destination. Very few do real two-way sync. Is Grouparoo designed for that?

Piesync looks cool. I don't see any databases on their list, so it looks to be mainly syncing between SaaS apps. We are open source and running in your own cloud as more of an ETL process.

Grouparoo is set up with sources and destinations. The most common sources are likely to be databases/warehouses and the most common destinations are tools like Marketo/Zendesk/etc. That being said, Zendesk will likely be a source one day to pull user info into Grouparoo (number of tickets created, lastEmailedAt, etc). Databases can already be destinations (write back out the member of the VIP group to Postgres, in addition to sending it to Marketo and Zendesk).

I'm not sure all of that is two-way sync or not, but it's certainly round-tripping the data. If you really want a full duplication in your data warehouse of a SaaS tool, I'd look into Stitch or Fivetran at this point. Then, Grouparoo will happily read that :-)

Re: Grouparoo: Open-source app to sync customer data with 3rd party tools

#32
post #25

Wow, this is exactly what I started looking for at the start of the day. Unfortunately I can't use it yet as there's no Postgres SSL support - filed a GitHub issue here: https://github.com/grouparoo/grouparoo/issues/734

Thanks! That should be an easy one. What was your goal when you started the day? :-)

Syncing our customer user data to Zendesk without having to write our own syncing service.

Re: Grouparoo: Open-source app to sync customer data with 3rd party tools

#33
post #32

Earlier quoted context omitted.

Thanks! That should be an easy one. What was your goal when you started the day? :-)

Syncing our customer user data to Zendesk without having to write our own syncing service.

Sounds perfect for us. We have some questions on that issue. Let's make it happen!

Re: Grouparoo: Open-source app to sync customer data with 3rd party tools

#34

Congrats guys from the team @ RudderStack. Glad to see more open-source products in this broad customer data space. Is it fair to say this is more like the Segment personas's product? We see a bunch of use cases for personas (which we don't have in RudderStack) so can point to you guys. Congrats again on the launch.

Yeah, the group-building part and syncing those (for example to Static Lists in Marketo) is like Personas. It was always funny to me that you had to pay quite a bit for Personas for Segment to actually, you know, segment.

The gap we saw was around understanding the user and segmenting in a way that could be shared across multiple services and the product. And doing so in a way where you controlled the data and the total cost was managed.

It's nice to see there are others open in this space. The trends are certainly in the open direction to provide a lot of value and control in a way that's good for everyone.

Re: Grouparoo: Open-source app to sync customer data with 3rd party tools

#36
post #35

What if I need to store all user data (not limited to profile information) in google sheets and I provide only an interface for an specific usage. I cannot see how good this scenario fits. Use cases are quite simple

Everything in Grouparoo is somehow tied to a user, so if you have a list of "locations" or something, that's not a good fit at this point. We basically need a "foreign key" to a property of the user.

If you do have that, we have support for google sheets[1]. You share a sheet with a service account and that allows it to be a source in Grouparoo. From there, you can make groups and send to destinations.

We'd be curious about your use cases. Feel free to make an issue[2] with what you are hoping for and we can discuss there.

[1] https://www.grouparoo.com/blog/google-sheets-source

[2] https://github.com/grouparoo/grouparoo/issues/new?assignees=...

Re: Grouparoo: Open-source app to sync customer data with 3rd party tools

#38
Very cool to see. A lot of folks (Notion, Figma, Loom) use our service (https://getcensus.com) for this purpose if folks are curious to check out a SaaS version of the concept.

We support all the major data warehouses (incl. straight Postgres), connect to a bunch of different applications, and don't store any of your customer data!

Bonus: we recently added native support for dbt :-)

Re: Grouparoo: Open-source app to sync customer data with 3rd party tools

#40
post #25

Wow, this is exactly what I started looking for at the start of the day. Unfortunately I can't use it yet as there's no Postgres SSL support - filed a GitHub issue here: https://github.com/grouparoo/grouparoo/issues/734

Postgres connector enhanced! https://github.com/grouparoo/grouparoo/pull/735

Let us know on the issue if it's working for you.

Post reply on HN