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
  1. The Installation
  2. ERP Bridge Wizard - On-Premise

4 - Database

Last updated 1 year ago

In this step you have to perform the connection to the database where there are the tables or the views where the agent will retrieve the data from.

Choose the technology of your database in order to follow the specific instructions:

Microsoft SQL Server

  • Instance Name / IP Address: you can choose from:

    • the local IP of your database server if it's on the same network and you network policies let you reach that. You can find your local IP address going to Windows Settings -> Network and Internet -> View your network properties -> IPv4 address.

    • the database instance name if the database is on the same server of the current wizard.

    • the public IP of your database server if it's publicly or whitelist-accessible (not recommended for security reasons).

  • Port: the port used to access your database. The default port for Microsoft SQL Server is "1433".

  • DB Name: the main database name used by your ERP

  • Username & Password: the credentials connected to a user that have right permissions to access your database

SAP Hana

  • Instance Name / IP Address: you can choose from:

    • the local IP of your database server if it's on the same network and you network policies let you reach that. You can find your local IP address going to Windows Settings -> Network and Internet -> View your network properties -> IPv4 address.

    • the database instance name if the database is on the same server of the current wizard.

    • the public IP of your database server if it's publicly or whitelist-accessible (not recommended for security reasons).

  • Port: the port used to access your database. The default port for SAP Hana is "30015".

  • DB Name: the main database name used by your ERP

  • Username & Password: the credentials connected to a user that have right permissions to access your database

I Don't Know

If you know the name of your ERP but don't know the database technology, the most of the time the vendor make public the database technology via documentation, try to contact the support or google for it.

If you don't find your ERP documentation online or you have a custom ERP, you can contact your ERP consultant asking which DBMS technology your ERP has as main database.

My DBMS is not listed

You don't see your database technology listed? Don't worry there is a solution, find the right tech in our "How To", you can connect ERP Bridge to almost all databases!

Follow this link to know how to do it:

After you fill all the form fields, you can press "Test DB connection" button to perform a test connection with your database.

If the result is a green light and a message with "Great, credentials are valid" message, you are good to go to the next step by clicking "Continue" button at the bottom-right of the window.

Issues during database connection? you can visit go to the following page of the documentation in order to find out if your issue is been mapped: Troubleshoot -> Database connection errors

https://howto.erpbridge.io
Database