4 - Database

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: https://howto.erpbridge.io

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

Last updated