S.P.E. – Client / Server Engine for CA-Visual Objects

Features

MANAGE REMOTE VO OBJECTS

As for classic VO objects, S.P.E. has the CreateRemoteInstance function which returns a instance to the remote object, to which you call methods like any other instance.

The main difference is that remote objects can only manage late-bound calls because they are running outside the application process.

REMOTE DBF DATABASES VIA OWN SPECDX.RDD

Use remote DBF using a true TCP/IP connection without the need to change almost any code because the RDD is compatible with DB like functions and DbServer class.

Our RDD is optimize to reduce network usage through its local caching mechanism.

ADMINISTRATION TOOL

S.P.E. comes with its own administration tool, a sort of DBU under steroids.

It allows to manage remote DBFs, visually design queries, browse data, access remote .INI files e and to view remote log files.

OBJECT DRIVEN QUERY ENGINE OVER DBF

S.P.E. has its own query engine, which is accessible by code and very easy to use.

It allows to design queries without the hassle of writing lot of code, letting you to concentrate to the result.

BASIC SQL INTERPRETER OVER THE QUERY ENGINE

It is possibile to run queries by passing a simple SQL string when opening the data, easy like writing DbServer{"SELECT * FROM CUSTOMERS WHERE NAME='JOHN'"}

CUSTOM SDBCDX.RDD

S.P.E. comes with its custom RDD to extend DBF with advanced features like:

  • AUTOINCREMENT ROW ID (a sort of Pack-Safe RecNo)
  • DATE/TIME RECORD CREATION
  • DATE/TIME LAST RECORD EDIT
  • FAST ON-THE-FLY ENCRYPTION/DECRYPTION

HTTPS INTERFACE

The HTTPS interface allows to interact via a REST-LIKE interface to pure VO classes.

For instance, you can write a class to be consumed by a web-site or mobile app, which communicate each other using JSON.

INTERNAL SCHEDULER

Simple scheduler which allows to plan execution of application at predefined intervals

INTERNAL SERVICE MANAGER

This manager allows to run automatically your background applications and restore them after crash.

Technical Notes

USER AUTHENTICATION

Each connection needs to authenticate by providing user name and password

USER RESTRICTION BY IP ADDRESS AND FOLDERS ACCESS

It is possibile to restrict users by their IP address and to limit filesystem access.

USER SESSIONS ISOLATION

Each connection runs in a separate server-side process, this avoids that one session crash could impact the others

ENCRYPTED LOGIN

The login mechanism is handled by a runtime generated asymmetric key exchange.

CONNECTION AUTO RECOVERY

The client library automatically restores the connection if it was lost or where it is unstable.

BLACKLIST

The service automatically put in a blacklist the IP address which fail authentication or doesn't send recognized command after 20 times.

RAPID INSTALLATION AND CONFIGURATION

The setup quickly and simply installs all the software and write all the settings needed to taste its main features.