Home / commercebuild connection information.commercebuild connection information. Step 1 of 1 100% Welcome!This form will allow you to securely transmit information from your server and ERP system to commercebuild. If you need to return to this form later or share it with someone on your team, click Save and Continue Later at the bottom of the form. You will be provided a link that you can revisit or share with others you trust.What is your organization's name?(Required) IT contact name(Required) The name of the person we can contact if there are any questions regarding the connection.IT email address(Required) IT phone number(Required) Which ERP does your organization use?(Required)-- Choose your ERP --Microsoft Business CentralSage 300Sage X3 Business Central - Coming SoonThe form for Business Central sites is not ready yet. Thank you for your patience! Firewall/Router Port Forwarding DetailsYour router’s public (external) Static IP(Required) We need to know the external (public facing) IP address of your router/firewall – this must be a static IP address. If you need to withelist our connecting IP addresses, please see this document.Firewall Port(Required) On your router/firewall, open up ports 8060 & 8085 (or any other available ports) to allow traffic between our servers, and your LAN/DMZ.Port Forwarding Has Been Configured(Required) Yes Configure a port-forwarding rule to direct traffic to the local IP address of the server on which the commercebuild Connector will be installed commercebuild ConnectorFor your commercebuild webstore to communicate with your Sage system, a Windows client called commercebuild Connector needs to be installed and configured on one of your servers in your LAN or DMZ. On this server, you may also need to configure your Windows (or other) firewall to allow traffic through to your chosen port.Internal Server IP(Required) What is the IP address of the server on which the commercebuild Connector software will be configured, and to which your router will forward traffic? SQL Server Database DetailsAn SQL Server database user, with sysadmin rights, is required. The SQL user must be able to create a database, create tables, and add/modify/delete data.SQL Server Hostname/IP (& Instance)(Required) The SQL Server Hostname should be in capital letters. Please indicate if there is a SQL Instance.SQL Database Name(Required) SQL Server Username(Required) SQL Server Password(Required) Is SQL Server Management Console installed on the server?(Required) Yes If it is not installed, please kindly install it.Has changed tracking been enabled on the database as well as for the tables?(Required) Yes Changes should be tracked for at least 3 days. To see which tables require tracking, https://support.commercebuild.com/article/sql-server-change-tracking-query-for-sage Sage 300 DetailsThe commercebuild Connector software will need to know which Sage 300 database should be connected to and will require a Sage 300 username and password with ADMIN rights.Sage 300 Username(Required) NOTE: If using a Sage version older than 2022.2, the Sage 300 API requires that the Sage 300 username be uppercase.Sage 300 Password(Required) NOTE: If using a Sage version older than 2022.2, the Sage 300 API requires that the Sage 300 password be uppercase.Both the username and password are UPPERCASE.(Required) Yes (Sage 2022.1 or older) No (Sage 2022.2 or newer) Sage 300 Version(Required) Sage 300 Database Name(Required) Sage X3 DetailsSage X3 Login URL Your URL needs to be accessible from these commercebuild testing IPs: 35.247.46.91, 34.83.204.220, 34.82.80.134 and the IP's the webstore will use. See the full list of IP addresses for your region here.Company Folder(Required) Sage X3 User(Required) Sage X3 Password(Required) Sage X3 Version Web Services Pool Name(Required) Web Services URL(Required) Please be sure to specify https or http. Order API Integration(Required) Have you allowed access to Sage through the indicated IP's addresses?(Required) Yes No Access Required: Please note that the Sage login URL should be able to access from: 35.247.46.91 34.83.204.220 34.82.80.134 Important!NOTE: For versions of Sage X3 2011 or newer, the webservices below must be installed and deployed into all the folders the webstore will connect. For instance PILOT and PROD. List of required Webservices: ECMBPC - E-commerce customer ECMBPD - E-commerce shipping address ECMPAY - E-commerce payment receipt ECMSEB - E-commerce pmt gateway data ECMSETXN - E-commerce pmt gateway trans ECMSOH - Ecommerce orders ECMSOHPMT - E-commerce sales order prepmt ECMSOHTXT - E-commerce sales order text ECMSQH - E-commerce Quotes Remote Access DetailsAccess to the server will allow us to install and configure commercebuild software, which is required for the integration. Furthermore, this access will also allow us to debug any integration issues that arise throughout the implementation, as well as when the web store goes live.How can you provide us access?(Required)--Access--RDPTeamViewerOtherTeamViewerFor more information on TeamViewer, please see our guidance.TeamViewer ID(Required) TeamViewer Password(Required) Windows User(Required) Windows Password(Required) RDPRDP Host/IP Address(Required) RDP Username(Required) RDP Password(Required) Windows Password(Required) Windows User(Required) VPN DetailsIf a VPN is required, please provide us the instructions to connect, e.g. VPN client download link, username, password, etc.Other MethodPlease tell us how we can connect to the server. Thank you!(Required) Almost done!Before you click submit, here is a checklist to make sure you didn't miss any of the requirements.I confirm that:(Required) All required IPs are allow listed. (Review IP allow list) The Windows user has Administrator rights. Ports 8085 and 8060 (or the ones indicated in the form) are opened, SSH traffic allowed and the redirect to the application is served. The Sage 300 password is configured in UPPERCASE and no special characters. The SQL Server database user, has sysadmin rights. The SQL user must be able to create a database, create tables, and add/modify/delete data. The SQL user password does not have special characters and the expiration date is disabled. Select AllThanks for confirming the settings for your Sage 300 ecommerce web store. You are ready to submit the form! Almost done!Before you click submit, here is a checklist to make sure you didn't miss any of the requirements.I confirm that:(Required) All required IPs are allow listed. (Review IP allow list) The Windows user has Administrator rights. Ports 8085 and 8060 (or the ones indicated in the form) are opened, SSH traffic allowed and the redirect to the application is served. All the required web services (e.g. ECMSOH) are configured and published globally. The SQL Server database user, has sysadmin rights. The SQL user must be able to create a database, create tables, and add/modify/delete data. The SQL user password does not have special characters and the expiration date is disabled. Select AllThanks for confirming the settings for your Sage X3 ecommerce web store. You are ready to submit the form!Untitled Untitled Δ
