Sage 300 ERP Connector

Sage 300 ERP Connector

Overview

Sage 300 versions supported: 2014 and higher.  

It can read, write to the following tables (chart updated January 16, 2020)

Sage 300 Entity
Read
Write
Customer
X
X
Contact
1
1
Products
X

Salesperson
X

Quote
X
X
Order
X
X
Invoice
X
X
Payment
X

Job


ChangeOrder


Shipments
X
X
TaxSchedule
X

1 - Contacts are not a separate entity but are included with the Customer entity 

The StarfishETL Sage 300 Connector accesses Sage 300 via web services.   Please refer to the Options to Connect page for more information on the multiple options for implementing StarfishETL to access local data.

Once you have established how you will connect StarfishETL, you will need to run the installer for the Sage 300 locally.

Installation Requirements

.NET Framework 4.7.1+
IIS with ASP.NET enabled

Please install in a location that Sage 300 client has also been installed, it does not have to be directly on the Sage 300 server.

Download

Installation

  1.  Download the installer: https://www.dropbox.com/s/jea9g6461ihvjkr/Starfish%20-%20Sage%20300%20ERP.zip?dl=0
  2. Unzip the file and move the Sage 300 folder to C:\Inetpub\wwwroot\.  This will create a new Default Web Site in IIS.
  3. Right click on the new folder, go to properties and set Write permission for the IIS_IUSRS group            (C:\Inetpub\wwwroot\Starfish300)
      

                  
3.  In the same folder, edit the web.config, configuring the connection string, Sage username/password, and Service username/password.




4.  In IIS, under Default Web Site,  right click and convert Starfish300 to an application.
5.  Another folder from the expanded zip file is SQL Scripts.  Open and execute each script in SQL Management Studio, taking care to change the first line  to USE <your database name> to execute against your Sage 300 database.

In StarfishETL, create a new connection to Sage 300.  If you changed the username and password for the service in the web config file, please use those instead of the defaults below.

b. Username default is sage300service
c. Password default is letmein

Sage 300 Connection Edit Screen
Parameter
Description
Starfish 300 Web Service URL





    • Related Articles

    • Sage 100 ERP Connector

      Overview Sage 100 versions supported: 2014 and higher. The StarfishETL Sage 100 Connector accesses Sage 100 via web services. It can be used with StarfishETL Windows or the Starfish Ray. If you are using the StarfishETL Windows module you will do all ...

    • Sage CRM Connector

      SageCRM Origin Make sure you update your standard SageCRM URL to include ../webservices at the end. The SageCRM Origin will not work if you have a blank password. Your user must have a password. Origin Filters "SageCRM Filters should work just like ...

    • Sage 300 web service setup and configuration

      Setting up Sage 300 web service test Get ready - Prep Sage 300 credentials Sage 300 SQL database Company Username and password System Prereqs .NET Framework 4.7.1+ IIS with ASP.NET enabled. Installed somewhere where the Sage 100 client has also been ...

    • Sage 100 Web Service Setup and Configuration

      Sage 100 Web Service installation and setup instructions Get ready - Prep Sage 100 credentials Sage 100SQL database Company ? Username and password System Prereqs .NET Framework 4.7.1+ IIS with ASP.NET enabled. Installed somewhere where the Sage 100 ...

    • Microsoft Dynamics ERP - AX Connector

      Our Microsoft Dynamics AX Connector is no longer supported.  We will offer support for Microsoft Dynamics 365 Finance and Operations in the near future. Parameter Description Domain Object Server Dynamics AX Connection Edit Screen