# 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>