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 - Database Mapping

Last updated 1 year ago

This step let you build a translation layer that permit the agent to properly retrieve data from a source and send it to the destination without the need to use the exact same database columns and HubSpot properties names.

Every row can be enabled/disabled using the toggle at the start of the row. When the toggle is OFF, the specific property or database column will be ignored when the data will be sent to the destination.

The central and core drop-down menus representing the database column and the HubSpot object property.

IMPORTANT: In case of HubSpot Drop-Down property make sure every internal value share the same value of the database data or it will return an error when the software will try to send data to HubSpot. For instance: if you have a drop-down property with values "lorem", "ipsum", "dolor" but in the database you have a different value or the same value but with different cases (like "Lorem"), the software will not save/update that record on HubSpot at all.

[Only for Database -> HubSpot operations] : At the end of the row, is present a file checkbox. If it's checked the database column selected the software will read the data (file path or blob), upload the file to HubSpot media and associate the media as attachment to the created/updated object. When the checkbox is checked, the HubSpot property is automatically disabled.

Database Mapping