Building scalable enterprise digital commerce for a global pharma giant
Digital transformation around the e-commerce services across multiple geographies and business divisions for a globally leading pharma company.
In the changing Internet economy, applications are required to talk to each other across the world, and irrespective of their existing formats & platforms. XML has emerged as the standard data format, which is recognized b y all the platforms & applications across the world. So in order to support this network applications the organizations require their databases to be in XML, & already an enormous amount of data is present in proprietary database formats.
The porting of the data is going to be huge market in coming few years. ‘The XML data converter’ aims at this market. It’s an application, which convert most of the proprietary database formats (DB2, Oracle, Ingress, SQL server etc) to XML.
e-Zest has developed the solution of XML data converter in Visual Basic and Perl. The current solution is supported by most of standard RDBMS like MS Access, SQL server, Oracle, Visual FoxPro. The Java version of XML data converter utility is in development phase.
The idea is to create the XML file out of every RDBMS, with the DTD for storing the Database structure. SO this XML file conversion utility contains 2 Parts:
The software has following features/Functionalities:
DATA IMPORT UTILITY This utility needs the input:
It gives the output as the XML file with the data inside it As:
1. The Conversion utility reads the data structure and makes the DTD and constraints.
2. The Data is migrated in XML file format with the filed name as the tag, for each record of the Table.
3. The XML file itself now becomes the self-explanatory information container.
DATA EXPORT UTILITY
It accepts the XML file as input and requires the following information
It gives the output as the restored Data in the proper dB Tables.
Industries in which this tool can be implemented: Banks, Financial institutions, Government organizations, Hospitals, Public sector units, Private sector businesses & any entity which has a legacy database will require this tool to convert it to platform independent data i.e. XML.
Read more about Data Conversion / Migration Services
