Skip to content


MSSQL Realtime Datasource Problem

Joe Powers asked 4 years ago
Is the WCF Service REQUIRED to run maps using the MSSQL Real Time Datasource. I have created a MSSQL Realtime datasource and a simple map to test by using a CSV file destination. The trigger is created and registered for Update on the GP Table(IV00105) but updating a item List Price of an item does not get the map to create the CSV file. I am using the .ASP web service and Fiddler does not show a request being sent, but, looking at the IIS log I can see this:
#Software: Microsoft Internet Information Services 8.5
#Version: 1.0
#Date: 2018-03-02 14:05:43
#Fields: date time s-sitename s-computername s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) cs(Referer) sc-status sc-substatus sc-win32-status sc-bytes cs-bytes time-taken
2018-03-11 21:15:17 W3SVC3 KHSERVER25 fe80::7cc2:b1ca:366f:f5a4%15 POST /SmartConnect/SmartConnect.asmx/mssql/23aed8ac-4149-467f-9051-a89f01101c21/Update – 5556 – fe80::7cc2:b1ca:366f:f5a4%15 – – 500 0 0 625 430 109
If WCF is required, can it run SxS the .ASP web service, or do I need  all the existing maps to use the WCF also?
Joe Powers
Lorren Zemke Staff answered 4 years ago
Yes, the WCF Web Service is required to use the MSSQL Real-Time events. You can run modify on the SmartConnect install and select the WCF service to install and set up that web service.
Go To Setup->Setup->SmartConnect Generic Connector. This is where you set the Web Service that is use for MSSQL Real-Time integrations. All maps for this type of Data Source would then use this service.
Joe Powers answered 4 years ago
Hi Lorren
OK Thanks for that info. This part of the installation procedure documentation should be changed to reflect that requirement. As it is currently written it only mentions that it is required for the Salesforce connector, not the MSSQL connector:
WCF Service – required if this install is to be used to process Salesforce real time data sources.  This or the web service is required if this install is to be used to process Dynamics CRM real time data sources, Dynamics GP real time data sources, Dynamics GP SmartList data sources, data pushes from the SmartConnect Excel Add-In, or run other processes via the a web service  Note: only one web service install is required to support this functionality.
When doing a repair install to add the WCF service do I remove the ASP web service that is currently processing the GP real time maps or do ASP and WCF exist side by side? If I remove it will the currently registered maps just start using the WCF Service or do I need to change anything else ?
Ethan Sorenson Staff replied 1 year ago


The WCF and asmx service can exist side by side. they run on different ports so they do not interfere with each other.

If you would like to submit an answer or comment, please sign in to the eOne portal.