Sage 100 ERP Connector

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 configuration where you have it installed.  If you are using the StarfishETL Ray, you will follow the installation instructions below and then configure the Sage 100 Connector in the StarfishETL Cloud Cartographer.

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

Entity
Read
Write
Customer
X
X
Contact
X
X
Products
X

Salesperson
X

Quote
X
X
Order
X
X
Invoice
X
X
Payment
X

Job
X

ChangeOrder
X

Shipments


TaxSchedule
X


Installation Requirements

.NET Framework 4.7.1+
IIS with ASP.NET enabled

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

Download

Please contact support for the latest web service installer.

Installation

  1. Run starfish100.exe  This will create a Starfish100 application pool in IIS
  2. In Explorer, navigate to the c:\inetpub\wwwroot\starfish100 directory
  3. Edit the web.config file with the following information:
    1. Sage 100 username and password
    2. Sage 100 Company code (3 letters all uppercase)
    3. Service username and password.  The default username and password for the service are username: sage100service password: letmein
Sage 100 Connection string
Please update the Sage 100 username, password, Company (three letters uppercase) and Server
      <setting name="Sage100ConnectionString" serializeAs="String">
      <value>Provider=System.data.odbc;DSN=SOTAMAS90; UID=dlh; PWD=9220; ;Company=ABX; SERVER=NotTheServer;</value>

Web Service Connection string:
<setting name="ServiceUser" serializeAs="String">
        <value>sage100service</value>
      </setting>
      <setting name="ServicePass" serializeAs="String">
        <value>letmein</value

If you are using the StarfishETL Windows, open the Admin and configure as follows:
  1. Create a new connection to Sage 100
  2. Enter Username: sage100service
  3. Enter Password: letmein (if you have left at default)


If you are going to be working in the StarfishETL Cloud Cartographer you will need to have the StarfishETL Ray configured locally to communicate with the Sage 100 Connector you just setup.  Please read more about the StarfishETL Ray here:  https://support.starfishetl.com/portal/kb/articles/starfish-ray
  1. Login to your instance if the StarfishETL Cloud Cartographer.  If you have not registered yet, please feel free to do so                  here:  https://designer.starfishetl.com/Account/Register
  2. Click on Connections
  3. Click on New     
  4. Connection name: Sage 100
  5. Ray - If you are using Ray, please choose your connection
  6. Connection Type: Sage 100 ERP from the dropdown
  7. Connections string: http://localhost/Starfish100/CRM100.svc


You are now ready to connect to Sage 100 and start migrating or integrating data!




Parameter
Description
Starfish 100 Web Service URL