Technologies

We focus on enterprise software development and we base our solutions mainly on technologies provided by Microsoft and Oracle.

The majority of the projects developed in the recent years are web based applications even when they are enterprise applications used only in the local intranet.

For the front end of such applications we use ASP.NET and the .NET Framework capabilities. We build the presentation layer using either the standard ASP.NET WebForms or the newer ASP.NET MVC.

We usually implement the middleware containing the business logic and the data access logic as .NET Assemblies (DLL’s) that are directly loaded by the ASP.NET application (WebForms or MVC). If there is a need to have a distributed system and run the middleware on separate machines it is usually implemented as .NET Remote Objects with binary serialization for maximum performance.

In some cases there is a need to integrate with other systems and there we use one of the following approaches:

• Provide or Use Web Services (SOAP) interface – the system we build either consumes existing Web Services provided by other systems or provides own Web Services built with ASP.NET Web Services.
• File Based Interfaces – many systems provide file based data exchange either using simple formats like CSV, Tab Delimited, Fixed Length Text etc. or self descriptive formats like XML. In such cases we build the appropriate import/export functionality and if needed we can build windows services that regularly push data forth and back reading and writing files in specified folders.
• Direct Database Access – read and/or write to the external systems database if it is possible to have direct connection. This is the least preferred approach as the database structure of the integrated systems changes over the time.

As database storage we mainly use MS SQL Server, but depending on the customer requirements (for example existing licenses) we use Oracle as well. In both cases we build the database interface using stored procedures written in T-SQL or PL/SQL so there is no ad-hoc SQL code in the middleware.