ERP Bridge
  • Welcome to ERP Bridge
  • Software & Hardware requirements
  • Environment Configuration
  • Data Preparation
  • Overview
  • Registration and first login
  • The Installation
    • 0 - Go to Installation wizard
    • 1 - Name
    • 2 - Hubspot Login
    • 3 - Sync Frequency
    • 4 - Download Wizard
    • ERP Bridge Wizard - On-Premise
      • 0 - Install the wizard on-premise (.msi)
      • 1 - Welcome screen
      • 2 - Login
      • 3 - Select Installation
      • 4 - Database
      • 5 - Database Tables
      • 6 - Download the agent
      • 7 - Start Agent
    • Back to the cloud
  • The Operation
    • 0 - Choose direction
    • 1 - Default settings
    • 2 - [HS -> DB] Filters
    • 2 - Database Mapping
    • 3 - Decision Rules
      • Example with 1 decision rule
      • Example with 2 decision rules
    • 4 - [DB -> HS] Associations
  • Start to Synchronize
  • Uninstall
  • Advanced topics
    • Change ERP Bridge Agent path
  • Troubleshoot
    • On-Premise wizard errors
  • HubSpot to Database sync
    • Handling empty fields
  • Security Documentation for ERP Bridge
    • 1. Product Access Control
    • 2. Rate Limit
    • 3. Authentication Resources
    • 4. Encryption
    • 5. Change Management
    • 6. Cloud Security
    • 7. Security certification
    • 8. Availability
    • 9. Logging
    • 10. Installer Desktop
    • 11. Server Agent
Powered by GitBook
On this page
  1. The Operation
  2. 3 - Decision Rules

Example with 2 decision rules

Let's say that you are creating a Database -> HubSpot and you have companies store in the following table and want to send this data to HubSpot Companies. Our database store companies with same ID and same name for each subsidiary but with different "City".

ID
Name
City

1234

Acme Ltd

Milan

1234

Acme Ltd

Rome

Let's say that on HubSpot we already have the current data:

ID
Name
City

1234

Acme Ltd

Milan

We can build our decision rules like this:

IF [ Company Name ] = 0: ADD = 1: NEXT > 1: NEXT

IF [ City ] = 0: ADD = 1: UPDATE > 1: STOP

And choosing as Decision Algorithm the "Funnel" option.

The cases for each of the 2 records on database will be:

  • For the first record: The first IF will trigger the "= 1" rule and the second the "=1" rule and it will result in an UPDATE decision.

  • For the second record: The first IF will trigger the "= 1" as well, but the second will trigger the "= 0" rule and it will result in an ADD decision.

Last updated 10 months ago