# Environment Configuration

**ERP Bridge supports potentially every on-premises ERPs.**

If you have an ERP based on Microsoft SQL Server (including Express version) or SAP Hana DBMS, you can create a new database for ERP Bridge on the SQL server or SAP Hana instance.

{% hint style="info" %}
It's possible to use a docker container with a SQL Server or SAP Hana image inside.
{% endhint %}

If the ERP relies on a database other than SQL Server or SAP Hana, our recommendation is to use an instance of Microsoft SQL Server - including  Express version - to create a linked server to the ERP database. In the table below you will find the official documentation for each database:

| Database of ERP | Connector type       | Documentation for create Linked Server                                                                                                            |
| --------------- | -------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------- |
| Oracle          | Microsoft SQL Server | [Link](https://blogs.oracle.com/cloud-infrastructure/post/how-to-create-linked-server-from-microsoft-sql-server-to-an-oracle-autonomous-database) |
| DB2 / AS400     | Microsoft SQL Server | [Link](https://www.ibm.com/support/pages/configuring-ole-db-provider-sql-server)                                                                  |
| PostgreSQL      | Microsoft SQL Server | [Link](https://www.mssqltips.com/sqlservertip/3662/sql-server-and-postgresql-linked-server-configuration-part-2/)                                 |
| MySQL           | Microsoft SQL Server | [Link](https://www.mssqltips.com/sqlservertip/4577/create-a-linked-server-to-mysql-from-sql-server/)                                              |
| ElasticSearch   | Microsoft SQL Server | [Link](https://www.cdata.com/kb/tech/elasticsearch-odbc-linked-server.rst)                                                                        |

Both SQL Server and SAP HANA do not need Linked Server to proceed.

## ERP Bridge database creation on Microsoft SQL Server

After installing Microsoft SQL Server Management Studio, we create a new database.

1. Right-click > New Database<br>

   <figure><img src="https://lh7-us.googleusercontent.com/Kq5Ol1KMQcMxkMFx1XPbD1laXLKRE5DUWHSWcDg4_RxxN8wQkc3WBJA_zdxBmxp0QRb01s7r1u4zPMGRliTPBh-JC90Y4_TMBAnCRpEX4yLe_36CUJaYqbYJSxyDHiji9HKK_n_00_wy0464_WmES9E" alt="" width="375"><figcaption></figcaption></figure>
2. In the Database name box, enter ERPBridge<br>

   <figure><img src="https://lh7-us.googleusercontent.com/UVkqWhVamAR0LYOjdiqOOR0WvZ4UY8kvErUl1qfXkE0Xn7hFLuSF4ZCjcXhmYo5wz--TKT7Df86ByQeuJlDe1ld-kBdwWXA4arTTPoEU1U5teDiUeyFHAxWD5rwy7jIGnZpVUyLNrszChjPN7Ok9bfM" alt="" width="375"><figcaption></figcaption></figure>

It follows a diagram of how the integration technique via ERP Bridge works.

<figure><img src="https://lh7-us.googleusercontent.com/2YQ6yjxMEx9P7HqWDsiDW6Dq39uu5lKMS07AWMiC0Pj4dwou7MUfIBPfUQ8bpjAK6snhA-KKhEgr3eaVbyjf23No1Ap6SuV0xTzKEDPL_TMottC9KxaSN58q_jXhBnS5KjTGn6MEfQ4y_4rmpS8ZndE" 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://docs.erpbridge.io/environment-configuration.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.