Technology

The system is designed in a 3-tier architecture: the client, the process server, the data server. Indeed, the technical architecture is based on an Oracle database server on Unix, Windows NT or 2000, operating with an or n application servers on Windows. These application servers are all Oracle clients, interacting with the DBMS natively, via the OCI library distributed by Oracle.

  • The Arpson server, written in C++, is installed on the application server(s)
  • The system’s client part, also written in C++, providing the user dialog, the user access to local ressources, is installed on the client workstations

The workstation communicates via TCP/IP application server or via https for an hosted or SaaS version. The user workstation can work also through a browser, via a Citrix layer. The application server performs the access to the database, the calculations and the treatment.

The system is compatible with all the major virtualization tools on the market (VMware, Microsoft Hyper V, Xen).

Architectures

In-hosting setup

  • The client part setup on Windows 2000, XP, Vista, manages the display and direct communication with the application server. The server access is done via a TCP/IP connexion
  • The treatment server part setup under Windows 2000, 2003, 2008, where the application’s treatments and calculations run
  • The datas server part,  Oracle 8 or higher, running under Windows, Unix, Linux, etc.

SaaS setup

  • This configuration is used for the Arpson SaaS and hosted offers
  • The application and data servers parts work in the same way as for a local use. Conversely, the client workstations dialog with the application server via the secure communication protocol HTTPS. Using this protocol requires the setup of an IIS server for routing the communications between clients and procession server. This is transparent for the client.

Additional technology

System interfacing in the target IS

Arpson N3 solution is known for its setting’s openness and interface’s flexibility in an information system. Interfaces implementation with other systems are done without specific developpments, just the setting.

Arpson system has, indeed, a fully integrated interfaces modeling tool making it unnecessary SQL extractions. This tool allows you to build sophisticated extractions, according to a specified format, without the need for learning a particular language.

It is then possible to transform the output file using an external tool, to change its format. The imports are made through specific functionality allowing you to import automatically or manually market datas, deals, etc.. Thus, the software does not offer standard interfaces, but configurable interfaces for various input or output applications.

Softwares with which Arpson solution is interfaced in our clients information system:

  • Upstream systems: FININFO, FINALIM, BLOMBERG, SUMMIT, REUTERS, GL, etc.
  • Downstream systems: SAP, RDJ, CODA, EVOLAN, XRT-CERG, SAGE-CONCEPT, KYRIBA, DEFI, EURO PC, etc.

Market data feeding


Market data feeding can be done:

  • In real time (at the request or sequentially)
  • Though a daily market data feeding, then stocked (vacation feeding)

This feeding is possible in automatic via the main market data feeders like Reuters, Bloomberg, Finalim, etc… Or through a flat file.

Mailing and confirmations automation


Arpson N3 solution offers the possibility, from the server side, to generate automatically mailing confirmations or tickets deal:

  • The email parameters (sender, recipient, copying, subject, body, attached pdf) are dynamically calculated if the models and contacts are setup properly
  • The attachment is dynamically converted to pdf
  • The console provides the user a contact manager tool

Reporting modelling with OLE DB module

N3 solution offers the opportunity to exploit the wealth of Arpson reporting by consulting the data, in real time, extract from the software with the help of applications supporting this technology:

  • Crystal Report
  • Report Builder
  • Excel (with VBA macro knowledge)
  • Etc.

XML & MQ communication

XML communication allows export to XML datas. The system can also be configured to “listen” to one or more message queues MSMQ / IBM WebSphere MQ. It allows – without user intervention – to initiate treatment following the messages it receives and send a report on their implementation.

Reference data plugging

Arpson solution is able to plug into datas from an external database without importing or copying into the application. The principle is to establish, between the master data reference and Arpson system, a communication method builds on dynamic SQL views.

LDAP and password secure management

Arpson N3 solution allows, optionally, to set some constraints defining the valid rules for passwords comply with Sarbanes-Oxley. It is possible to set:

  • Characters minimum number,
  • Uppercase and lowercase alphabetic characters minimum number,
  • Digits (1234 …) and special (& é_ç …) minimum number,
  • A validity period for the new and the old password, in days,
  • A reuse frequency for the password.

The LDAP module allows connection to the LDAP server and authenticate the login and password. This functionnality also recovers from the server, “all groups” to which the user belongs. It is also possible to manage into the platform the groups to intercept, ie the groups useful for system