Sage Connection Manager is SSIS Connection Manager for establishing Sage Parameters
Server
Use the Server page of the Sage Connection Manager dialog to specify properties for connecting to Sage SData service.
- Test Connection
- Confirm connection manager configuration by clicking Test Connection.
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.
Proxy
Use the Proxy page of the Sage Connection Manager dialog to specify properties if your server is behind firewall.
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.
Knowledge Base
- Where can I find the documentation for the Sage Connection?
- How to trace HTTP(S) and REST API using Fiddler
What's New
- Fixed: Various fixes (Thank you, Adam).
- New: Introduced connection.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.