HubDB Vs Product Object Vs Custom Object Vs External postgresql ..

[jpsanchez]

Hi Friends!,

I need your help

We are developing for a rental car client a website with car deals using hubDB and all deals in Product Object ( in order to create a custom estimate and or quote template within hubspot ).

Client don´t have any ERP or previous database so we had to develop a learning by doing process relationship arquitecture ( hard way )

- Cars information comes from public data and several sources.

- Cars offerts from the big 5 rental companies ( the cliente is not) are not related it with public information and deterministic positve ID is a difficult one (disambiguation) and i guess we solve it well.

- So at the end we had develop a postgresql database that will manage the hard work. ( and will be the single source of truth.

What will be your suggesitions to this quesitons?

1.- Best option to sincronize in one way or two ways to HubSB and Product Catalog objects in HubSpot?

2.- Best option to create an external frontend in order to manage the postgresql what it will be? ( client will need to access in a day basis to update, change, etc cars and offerts)

Any other suggestion ;)) will be really appreciate it!!

Best

JP

[tominal]

It sounds like we’re both in the exact same automation-development industry with different clientele. There’s always a million ways to solve everything, so I can’t say this is the right answer. I can only offer what immediately came to mind.

1. If your source of truth is external, then you want to make sure any changes made there will trigger changes in HubSpot’s records. Event listeners can trigger SDK calls over to HubSpot to keep your data in sync. You could also write up something that fires off after a period of time to double-check.
2. That’ll be up to you. It may be overboard to whip up a PWA or SPA if it’s just team-facing, so perhaps some server side rendered application to interact with your data?

Hope that helps!