Change a Delphi / Oracle application from two-tier to three-tier

Question

In my company, they finally (about time ...), considering the possibility of converting one of our best-selling applications from architecture with 2 levels to 3 levels, both at the logical level (Presentation, Business and Data), and at the physical level . We'll probably go either to Delphi-Delphi-Oracle, or to Delphi-Java-Oracle for a change.

This is a fairly old and large application that was created and modified for a long time before I started working there. Refactoring, except when something needed to be changed, was usually never considered. In addition, business logic is present at both actual levels ... sigh.

The physical change does not bother me, but the logical change will be a kind of passage through Hell. To smooth it out as much as possible, I would like to explore which Delphi components are best suited for the three-level model.

¿What alternatives could you use?

Answer 1

We recently converted our 2-tier Delphi application to 3 tiers using RemObjects DataAbstract. Although the initial learning curve was rather steep, we are absolutely pleased with the results.

DataAbstract allows you to forget about the basic nuts and bolts of the database and network connections and concentrate on business logic. It allows you to create an abstract level of service that provides your server clients with a good API. Using this API, we connect to the server using both the Delphi client and the Delphi Prism ASP.NET client.

Answer 2

Another good n-level core library is kbmMW from component developers4: http://components4developers.com/

Answer 3

I found RemObjects quite useful. They also have DataAbstract built-in, but I have not used it.

Answer 4

Have you ever considered DataSnap XE?