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


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




    • Related Articles

    • 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 ...
    • 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 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 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