Migration of Pick Basic Application to .NET using IBM UniVerse® and UNIOBJECT
Q3's global sourcing model gives the maximum benefit to customers in terms of cost savings, improved quality, access to highly talented professionals, flexibility of operations and reduced time to market.
The organization is a distributor of medical and surgical supplies for virtually every recognizable name brand manufacturer in the healthcare industry. The web site offers its members the ability to search their product offerings, view contract pricing, place orders on-line, create a customized "favorites" page and review the status of previously placed orders.
They offer this convenient and efficient internet-based way of doing business, a traditional "bricks-and-mortar" medical and surgical supply distributor
The company (pharma and medicinal) is maintaining all transactions between his all suppliers and venders and warehouse’s by Using Software MDS (Medical Distribution System) and also MDS maintains all raw stocks on his warehouses.
Today’s software development environment boasts of scalability and platform dependent spectrum of technologies, complexity and size. In every case, the software is transformed from source code written by developers into an application that can be utilized by end-users.
Client is the industry’s choice for software to help provide the infrastructure to transform raw data into consistent, accurate and reliable corporate information. It can access most databases and file formats and profile the results accurately as well as to greatly reduce the time and effort to move and integrate data.
The main effort was transition of UNIX based application to a Windows based application interacting with an UNIX database. This Product had a legacy code of distributed components and dynamic libraries which he wanted under one executable with unbreakable security. IBM UniVerse® is an extended relational (MultiValue™) data server optimized for embedding in superior solutions and is ideal for markets which target small to medium businesses, as well as larger enterprises.
MDS Software is developed in Pick Basic (Language) and UniVerse® Data base. Pick Basic and UniVerse® database is UNIX base database. The application was transitioned to a Windows based application. For windows based application to connect to the UniVerse® Database, we required an intermediate object, UNIOBJECT. The transition was done from the application made on Pick Basic to .NET and the database remained UniVerse® database with UNIOBJECT for connectivity. UNIOBJECT worked as middle man between UniVerse® database and .Net application.
UNIOBJECT provides functionality like SQL SERVER to insert data in to database. UniVerse® database is multi value file system. It’s Different from RDBMS. So in the UniVerse® database separate each row with a special character and each column are separate with a special character.
So Display the reports on window base application from UniVerse® Database, we use Uniobject as intermediate layer.
In this difficult economic environment, Symfo decided to outsource one of its most critical developments to Q3 Tech. We were definitely reluctant doing so at the beginning of the project. But rapidly we understood that Q3 had the necessary skills and professionalism to bring the project to a successful realization. It was not always easy primarily because of the differences of culture. However once we understood each other, things went much better. We also understood that such a difficult project needed intense communications between Q3 and our company. Our company works on two time zones (Europe and East Coast North America) and we were amazed by the availability of the Project Manager and his team. It really contributed improving communications between us.
Phase I of our product is now ready and we are quite happy with it. We are definitely ready to start Phase II with Q3 and we highly recommend them.