ERP Bridge
Search
K

Environment Configuration

Microsoft SQL Server and Management Studio installation
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.
It's possible to use a docker container with a SQL Server or SAP Hana image inside.
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
DB2 / AS400
Microsoft SQL Server
Link
PostgreSQL
Microsoft SQL Server
Link
MySQL
Microsoft SQL Server
Link
ElasticSearch
Microsoft SQL Server
Link
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. 1.
    Right-click > New Database
  2. 2.
    In the Database name box, enter ERPBridge
It follows a diagram of how the integration technique via ERP Bridge works.
Last modified 18d ago