APS.net Interface Service

The APS.net Interface Service (PTIS) is a Windows Service that is used by APS.net to import data from one or more data sources (usually an ERP system) into APS.net. It is a batch-style interface that works by running pre-configured queries or a custom programmed CustomImporter dll against various data sources and submitting the results using the APS.net API. The interface is invoked from within the APS.net Client.  It can also be setup to run automatically at pre-determined intervals using the APS.net Scheduling Agent.

Setting it up

  • The connection, field mappings, and other various PTIS settings can be configured using the Interface Setup Wizard.
  • Since PTIS acts as a bridge between a data source and APS.net Service it is usually best in terms of performance to install it on either the computer that is running the source database or the computer that is running the APS.net Service.
  • The PTIS service Startup typeshould be set toAutomaticso that it is started automatically when its host PC reboots. Otherwise it will not be possible for APS.net users to either start or configure their (usually at least daily) data import.
  • The service will usually work if setup to logon as the Local System account. The account must have rights to read and write to the Working Directory and the root of the C drive. It also needs to be able to listen to a port for data from other processes (such as PT Service).
  • Using the interface will require setting up a data source for creating a database connection unless the CustomImporter option is used in which case that dll must be programmed.

Note

  • The name of the service, as listed in the Windows Services utility, isPlanet Together Interface Service
  • All database access is through a Microsoft .NET DataReader. This means that access to the databases is read-only, forward-only and that no data will be modified in the target database.
  • Only one user can configure or run the PTIS import at a time. If another user attempts to run or configure it while it is busy then an error message will be displayed warning that this is not possible.