Tools

Sana Commerce 9.3
Your connector

ERP Connection



Sana is the ERP integrated e-commerce solution. This integration is unique in the sense that all information used in your web store comes directly and in real-time from a single place, your ERP system. As all master data is managed and stored in a single ERP database, you can prevent data inconsistency and ensure that all your departments work with the same data.

Sana connects to the ERP system through the Web service. 

To establish connection between Sana and your ERP system, in Sana Admin click: Tools > ERP connection.

Default Connection

In the Default connection area, you can set up connection to the ERP system.

The table below provides the description of the ERP connection settings:

Field Description 
Provider Type of provider.

Sana Commerce delivers only one global provider type - eBusiness, which can be connected to any ERP system.

By default Sana Commerce is integrated with:

  • Microsoft Dynamics AX
  • Microsoft Dynamics NAV
  • Microsoft Dynamics GP
  • Microsoft Dynamics 365 Business Central
  • Microsoft Dynamics 365 Enterprise Edition
  • SAP ECC
  • SAP Business One
Connection type Select your connection type. The connection type determines which ERP system you are connecting to.
Webservice URL Enter the webservice URL of your ERP system.

If you do not have the webservice URL, contact the person who is responsible for setting up your ERP environment.

See examples:
Microsoft Dynamics NAV
http://domain.com:7047/DynamicsNAV/WS/CompanyName/Codeunit/SC_NAV_WebService

Microsoft Dynamics AX
http://domain.com/AX2012WebService/AXService.svc

User domain Enter the domain and credentials of the user who is accessing the ERP system.

If you do not have the domain and credentials of the user who is accessing the ERP system, contact the person who is responsible for setting up your ERP environment.

User
Password
Connection timeout Determines the time to wait while trying to establish a connection before terminating the attempt. You can set the amount of time in seconds a connection waits to time out. A connection timeout means that a server is taking too long to reply to a data request.

Default: 60 seconds
Enable logging If logging is enabled all requests from the Sana Admin and webstore to ERP and responses will be written into the tracelog file on the server.
By default logging is disabled as it affects performance. Therefore, it is better to use it only for debugging purposes.

For more information about logging in Sana Commerce, see "Sana Commerce Logging".
Extra parameters This field is used when you need to specify some extra parameters in the connection to ERP. Use the ";" character to separate multiple parameters.

When connection to your ERP system is configured, click Test connection to check whether the connection is available.

Custom connections

Custom ERP connections are used for more complex and advanced hosting scenarios.

Below you can read about hosting scenarios when you can use custom ERP connections:

  1. Sana Commerce Framework consists of the following subsystems:
    • Catalog
    • Customer
    • Common
    • Order
    • Price
    • Stock

    You can set up multiple ERP Web services and connect different Sana Commerce subsystems through a separate ERP Web service to handle different requests. For example, price and stock calculation can be handled by one ERP Web service, order management by the second ERP Web service, and the rest logic by the third ERP Web service.

    Each ERP Web service executes ERP business logic and all of them are connected to the same ERP database.

    As ERP is the slowest part of the whole infrastructure, such configuration can be used to improve performance of the high-traffic web stores.

  2. There are some cases, when the catalog is stored in one ERP system, customers in another and orders are placed to the third ERP system, for example.

    Bear in mind that this hosting scenario is very complex. If you are going to connect Sana subsystems to different ERP systems, then products, customers, etc. should be available in all these systems with the same identifiers to synchronize data. For example, when a customer places an order in system A and product information is retrieved from system B, then a product with the same ID should be present in both systems.

    If you are interested in this hosting scenario, please contact your Sana partner or project manager first.

If you connect your webstore to one ERP system, you must set up connection only in the Default connection area. If you connect some subsystems of the Sana Commerce framework to different ERP systems, or to one ERP system but via multiple web services, set up the appropriate connections in the Custom connections area.

Maintenance mode

Sana allows to accept orders when there is no connection to your ERP system. This allows to continue business operations without interruption, even when connection to your ERP system is not available for some reasons. When there is no connection between Sana and ERP, Sana automatically enables the maintenance mode.

For more information, see "Maintenance Mode".