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 installed. It does not have to be directly on the Sage 100 server.
Setup overview
- Get zip file
- Sage 300 ERP
- starfish300.zip and instruction file - instruction.txt
- Extract it and paste it into inetpub\wwwroot
- Set up the Sage 300 web service as an application in IIS
- Go to IIS
- Go to Sites
- Go to default web sites
- Set up a new application pool
- call it starfish 300
- click advanced settings and make it a 32-bit application
- Convert the site to an application
- Set app pool to Starfish300
- Configure the web service to connect to Sage 300
- Go to web config file using explorer
- use default to a log file
- set up service user
- this is what Connect Creatio is using for the connection not the credentials for Sage
- set up sage connection
- connection string - this is the SQL connection string to the Sage 300 connection string
- catalog, user id and password and version
- version, you don’t need to modify
- Test the web service
- Select browse
- May see a basic page with the files
- click through the 300.svc
- end point not found but use the the URL
- Open up access through the firewall to web service
- Need access to the web service
- Set up Connect Creatio connection to connect to Sage 300 web service
- Go to Connect Creatio
- create new connector
- user name, password, service uRL from above test
Zip file
Sage 300 download - includes web service instructions and stored procedures
https://www.dropbox.com/s/jea9g6461ihvjkr/Starfish%20-%20Sage%20300%20ERP.zip?dl=0
Instructions | Snapshot |
- Extract the Starfish300 folder under C:\Inetpub\wwwroot\
| |
- Copy folder to C:\Inetpub\wwwroot
| |
- Go into IIS, under sites, default website
| |
- Set Write permission for the IIS_IUSRS group on the new folder c:\Inetpub\wwwroot\Starfish300
|
|
- Edit the web.config, configuring the connection string, Sage username/password, and Service username/password
|
|
|
|
- In IIS, under Default Web Site, convert Starfish300 to an application. Enable 32-bit on the Application Pool
|
|
- Create a separate application pool
|
|
- Enable 32-bit - needed to communicate to Sage 300
|
|
Select browse
|
|
You might see this if you select browse
Click on CRM300.svc
|
|
This is okay
|
|
The URL from the browser is what you put into Connect Creatio - needs something besides localhost
| |
Edit the web config file that is under the ?
|
|
|
|
Service user and service password - give it a user name and password to secure the web service
- HTTPS?
- What else do you set up here?
- Firewall rule
Sage user, sage password, sage company - this is what they use to log into Sage
Need the SQL connection string
- Name of sever, connection string, user and password
- Version string - it is defaulted to 65A
Need to open up the firewall to get access to
- In Connet Creatio Admin, create a new connection to Sage 300
Copy and paste the Starfish300 folder into the wwwroot
Right click on it and convert to application
Related Articles
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 ...
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 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 ...
Microsoft Dynamics ERP - GP Connector
Additional Documentation This Connector is based on the Dynamics GPADO.NET Provider by CData. For additional help, including String parameters, please see: https://cdn.cdata.com/help/DPG/ado/ Dynamics GP Version Support The provider supports read ...
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 ...