Query on integration of C# appln with Legacy appln
Currently working in software company as Senior Software Engineer in dotnet applications.
Here we a requirement to extract some data from excel files based on business logic and update this data in existing applications. The existing applications are developed in old technologies like VB/ASP & VC++. These applications are in LAN and users have access permissions. I am supposed to develop an application which extracts data from excel files and integrate with existing applications.
My area of concern is will windows forms based C# application developed to extract data from excel files in LAN integrate with existing applications by providing link to VB/ASP web application, provided there is access for web application. If the existing applications are desktop applications, how can we integrate?
Please suggest me proper design asap.
[868 byte] By [
Shilpa] at [2007-11-11 7:26:34]
# 1 Re: Query on integration of C# appln with Legacy appln
When you say , you would extract data from excel files and update it in existing applications, What is the datastore for the existing applications, Are you using a database like SQL server 2000 for the existing applications(can be any database) or are these applications querying data of the excel files runtime?
# 2 Re: Query on integration of C# appln with Legacy appln
When you say , you would extract data from excel files and update it in existing applications, What is the datastore for the existing applications, Are you using a database like SQL server 2000 for the existing applications(can be any database) or are these applications querying data of the excel files runtime?
Datastore for existing application is oracle. Proposed appln will read data from excel files and find errors or no issues. Existing desktop application is where we can log tickets for errors which is in VC++ and oracle. Based on whether its an error or not, the proposed windows forms based C# application should be linked to Existing desktop application. In web application, we can provide link to existing application. For desktop applications, how can we integrate?
Shilpa at 2007-11-11 21:50:07 >
# 3 Re: Query on integration of C# appln with Legacy appln
If all these applications are deployed on the same server a windows service would be a good solution, This service if it could read these excel files on a regular basis (scheduled to your requirement) and raise an error or issue by inserting the data into the database if you store the tickets in the database or can send out a serialized xml object of the error or issue?
