Group 65Go to Flowgear
All Collections
Nodes
Sage Pastel Partner

Sage Pastel Partner

Daniel Chilcott avatar
Written by Daniel Chilcott
Updated over a week ago

Provides integration into Sage Pastel Partner via the Sage Pastel Partner SDK.

Revision History

18.0.0.2 Tidied up support for Partner V19

18.0.0.3 Added support for optional fields, updated node samples.

Properties

Connection

Type: Connection Input

CompanyDatabase
Type: String
The path to the company database - eg. C:\PASTEL18\COMPANYNAME

ProgramPath
Type: String
The path to the Pastel installation - eg. C:\PASTEL18

Defines a connection to a Pastel Partner installation and company database.

Module

Type: List Input
Accounts
Documents
GlBatches
The Module that will be affected by the transaction.

RequestXml

Type: Xml Input
The request to be sent to Pastel Partner in XML form.

ResponseXml

Type: Xml Output
The response received back from Pastel partner in XML form.

Remarks

This Node reduces the complexity of integrating into Sage Pastel by enabling integration regardless of the location of the application server. The Node also abstracts away the underlying pipe-delimited strings expected by the SDK and instead exposes well structured XML documents.

Use the Node Samples provided with this Node to get started quickly.

Requirements and Setup

  • Install the Pastel Partner SDK on the server that Pastel Partner is installed on (download the SDK from the Additional Downloads tab at http://pastelupdate.sagesouthafrica.co.za/)
  • Contact Sage to register the SDK, there is no additional cost to do this and you do not need the Developer license of the SDK. Once registered you should see Software Developer Kit listed in the modules section of the Help/About dialog
  • Install a 32bit DropPoint on the Pastel Partner Server

Working with Pastel Partner

The Pastel Partner Connector supports writing of transactional and master data and should always be used for this purpose.

To read data, use an ODBC Query to query the PervasiveSQL database, specifying a ConnectionString in the following form:

Driver={Pervasive ODBC Client Interface}; servername=server_name_or_ip; dbq=data_source_name

Note that as with the Pastel Partner Connector, you must use a 32bit DropPoint to communicate with the PervasiveSQL database.

Troubleshooting

If you get the error "Unable to instance SDK. Ensure the Pastel Partner connector is running through a 32bit DropPoint and that the Pastel SDK has been installed on the server", run through the following diagnostics points.

  • Ensure that the Flowgear DropPoint service is running using a named user account with administrative privileges.
  • Ensure that you have installed the 32bit DropPoint version.
  • Ensure that the Pastel SDK is registered successfully. (Check Requirements and Setup section).
  • Re-register the Pastel SDK files by running the following in the command prompt window:
    1. regsvr32 "C:\Program Files (x86)\Common Files\Sage Pastel\PasSDK.dll"
    2. regsvr32 "C:\Program Files (x86)\Common Files\Sage Pastel\SDKPasV{Your Pastel Partner Version}.dll"

Examples

Refer to Node Samples for example uses.

Did this answer your question?