# Operation Configuration in ERP Bridge

[Please refer to this section](https://docs.erpbridge.io/the-operation) for technical details on how to configure ERP Bridge.

## Database Mapping

In the Database Mapping section you decide which fields to connect from the SQL view to HubSpot.

On the left-hand column select the data from SQL that you want to synchronize and link it with the related property on HubSpot. For more information about which properties to synchronize, please refer to the [synchronization section](/readme/companies/synchronization-from-erp-to-hubspot/sql-recommended-synchronization.md).

<figure><img src="https://lh7-us.googleusercontent.com/X-Ro0TjIIsx5cQgnOvw2kRblYdoDfL7dECBgIb8vCCvT5giqx5krMyW8peBkhD7X0D5SeHEGtOyLVt1g8HZTc5t3U2xb2sQXZ-ZMmQHvR2XFBjU8i5ZJrOovnNISvNJ4SPof4YoylDEDbuz-PvfmJ44" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
We recommend to create custom section for the new properties:

* Create a property group called ERP Information for all custom company properties
* Create a custom section called ERP Information on the left sidebar of the Deal record, where insert all the created custom properties
  {% endhint %}

## Decision rules

The following section is Decisions rules, where you set all the actions that the agent will perform once the synchronization will be on. For general guidelines, please refer to the [specific section](https://docs.erpbridge.io/the-operation/3-decision-rules).

<figure><img src="https://lh7-us.googleusercontent.com/15bWeHo5zdXB5B7xjRdtETd-UM9q7zA6pk6ZQAgCGKNWOfY-b-bSV1h_5fsvNn7z71xvq8rzPgmWBFYTY93TBMzNHcQhIcKCYkOB69XIELLBdBuXzpKAxKmEVFKaMF-kTrEsj0A4lVXhmtrhms0s8Wo" alt=""><figcaption></figcaption></figure>

In our example we set Deal Name as primary key, because in SQL we connect in the same field Offer Number and Deal Name:

* Insert =0 in the first line means that if that specific Deal Name does not exist, the agent will add the record,
* With several records with the same Deal Name (=1), the agent will update the record,
* If there are several identical records (>1), the agent will skip the record.

{% hint style="info" %}
We connect Offer Number and Deal Name in the same property because then you can directly use the search bar on the deal section to find a specific offer number or deal name.
{% endhint %}

{% hint style="danger" %}
It's fundamental to choose a field as 'primary key' that will always be uniquely populated, otherwise records will be duplicated in the next synchronization.
{% endhint %}

## Associations

Now we want to associate the object Deal with an important object in our database, our advice is to create a link with the object “Companies”, and the property used to connect these two is “Customer ERP Code” and “ERP Code”.

<figure><img src="https://lh7-us.googleusercontent.com/_79y4Dojz-AS7wo_2pKPcO3zc4IjAOphblXiJgjkqDqtm6PBCAN25jtzogZFPlj0UZzWaSBmF-VYbEAPfvQNVJ57JLUjTAacBLco93seKw1ZpDSTkO-zbA2vb2BrSkLxIH-sE2wp6Qz0jt-GRaLPh5E" alt="" width="563"><figcaption></figcaption></figure>

Please refer to the [Associations section](https://docs.erpbridge.io/the-operation/4-db-greater-than-hs-associations) for more information.

<figure><img src="/files/uicozModzyGRo3aipkWE" alt=""><figcaption></figcaption></figure>

Now the new operation Deal will appear on the Homepage, to activate the synchronization make sure the button is on.

<figure><img src="https://lh7-us.googleusercontent.com/fnHtABGj5Mv_VDZeMJ3X9386zIqtxJpqseyMJEPFsXXkCFgEr8DuNzXtHAKjB9jIuevYRHp25Te_tt9DQRwoApzN6XphoAJ5gV_uA_-7nFBFZsii6NNgueAS38BAloromcVticQgpgOAQ6RUesjxre4" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://howto.erpbridge.io/readme/deal/synchronization-from-erp-to-hubspot/operation-configuration-in-erp-bridge.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
