Tags: 
1.6, Connection, Sage, CRM, Accounting

Overview

Sage Connection Manager is SSIS Connection Manager for establishing Sage SData connections. Use the API to build components based on Sage Connection Manager.


Setup

Use the Sage Connection Manager dialog to specify properties for connecting to Sage SData service.

Server Parameters

Specify the name or IP address of the Sage data server.

Specify SData application identifier. The following list of identifiers are known:

Id Application
slx SalesLogix
sageERP Accpac (not tested)
crmj Sage CRM (not tested)
x3 Sage X3 (not tested)

Specify SData contract identifier. The following list of identifiers are known:

Id Application
dynamic SalesLogix
accpac Accpac
sagecrm Sage CRM
erp Sage X3

Specify SData DataSet identifier. The following list of identifiers are known:

Id Application
- SalesLogix
<company> Accpac
- Sage CRM
<company> Sage X3

Specify user name to access Sage.

Specify password to access Sage.

Specify the number of seconds before timing out session connect. The default value of this property is 100 seconds.

Specify if all clients should use the same connection. This property has the options listed in the following table.

Value Description
True All clients use same connection (default).
False Every client use different connection.
Test Connection

Confirm connection manager configuration by clicking Test Connection.

Proxy Parameters

Specify the name or IP address of the proxy server. If not specified, proxy server is not used.

Specify the port number on the proxy server to use for the connection.

Specify user name to access the proxy server.

Specify password to access the proxy server.


How to trace the web services calls in use?

We recommend using the Fiddler tracing application. Make sure you enable HTTPS tracing option before you start your trace.


Related documentation