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

Environment Configuration

Microsoft SQL Server and Management Studio installation

Last updated 1 year ago

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

DB2 / AS400

Microsoft SQL Server

PostgreSQL

Microsoft SQL Server

MySQL

Microsoft SQL Server

ElasticSearch

Microsoft SQL Server

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

  2. In the Database name box, enter ERPBridge

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

Link
Link
Link
Link
Link