Architectural options for migrating Power Builder application to .Net technologies  
Author Message
Rahul_It





PostPosted: Architecture General, Architectural options for migrating Power Builder application to .Net technologies Top

Hi I have to provide architectural options using Microsoft Technologies for an window based three tired application. The user interface(Presentation Layer) of this application is developed using Power Builder. The presentation layer works in disconnected and connected mode. Middle tier(Business tier) comprises of C/C++ components which are hosted on EA Server(Sybase componet server like COM+) on a Sun solaris serve with unix. Back end is Oracle which is on the same box where components are hosted. The communication between presentation tier and middle tire happens using RMI/CORBA.

I am looking for various options for suggesting possible architecture using Microsoft Technologies. Pls advice.

Thanks

Rahul




Architecture2  
 
 
Arnon Rotem Gal Oz





PostPosted: Architecture General, Architectural options for migrating Power Builder application to .Net technologies Top

Hi Rahul,

if you are just looking for technology to technology mapping then the answer is easy - winform for presentation layers (in C# or VB.Net) , Serviced Components (COM+) on the server side and you can retain the oracle backend.

Nevertheless - you can probably use this chance to take a look at the overall architecture of the solution and evaluate its applicability to the current business needs (e.g. maybe a web-frontend is more appropriate) maybe you have some business processes that are more volatile (likely to change) and you want to add workflows. Maybe the components are not aligned for the current business needs etc.

Arnon



 
 
Rahul_It





PostPosted: Architecture General, Architectural options for migrating Power Builder application to .Net technologies Top

Hi Arnon,

Thanks a lot for reply.

I concur with you as long as technology mapping is concerned.

I have thoroughly analyze the existing architecture. The current middle tier is implemented using EA Server which is hosted on Unxi box. It comprises of C++ components. Since EA Server is CORBA complaint. The client invokes them using RMI. The communication between client application (windows app) and middle tier (C++ components) is happening using RMI - CORBA since its hosted on non windows platform.

Database and EA Server(middle tier) are hosted on the same unix based sun solaris server.

The requirement for UI is as follows-

-It should work in network and disconnected mode means UI should have its own local database. In existing application SQL Anywhere is used to facilitate the local storage capabilities.

Considering this requirements i am considering following options for UI(windows client)

1. Win forma along with MSDE as local data storage.

2. Smart client along withXML data islands as local data storage

Well about Middle tier - I am thinking of seperating out Application Server and Database servers on different boxes. I am also considering about rewriting the middle tier in C# or VB.Net. Database will be kept as it is.

Following may be the possibe options for middle tier -

1. Serviced components hosted on COM+. Remoting can be used as transport mechanism between client and middle tier.

2. To expose middle tier as Web Services.

What would be your take on this

What should be vaiable option for UI and what should be the corresponding middle tier

If you could suggest some other option, it will be great help

Greeting

Rahul



 
 
Andy Blum





PostPosted: Architecture General, Architectural options for migrating Power Builder application to .Net technologies Top

Rahul,

I developed PowerBuilder applications for 12 years and have faced similar issues. One suggestion, look into the DW.Net component offered by Sybase. That component works well in a WinForms environment (haven't tested the web forms version). I am sure your PB application makes heavy use of data windows and there is no reason to throw all that development away. Especially, if you use complex groupings and cross tabs which are not easily replicated in other environments. I would suggest that you do not use datawindow in a connected traditional Power Builder way, but rather use a dataset XSD as your source. For the middle tier, you may want to consider re-using a lot of your C++, C code - excpet you could create wrappers in C++.Net and use SOAP instead of CORBA.

Just my two cents!

Good Luck,

Andy Blum