What is happening now?Currently, the client (let's call them abc enterprise) provides us the XML files containing employee data, we have a XSLT using which we transform the XML files into web-service request files and call the Business Rules Engine Web-Services. BRE provides the decision determined by the Rules Engine. We parse all this information from the Web-Service response and store it in the database. An UI application displays this data in Tabular and Charts formats.So the existing applications are:TestHarness application: that reads XMLs, transforms it into Web-Service requests, parses the response and puts into the Database tables.UI application: that displays the data from the database in tabular and charts formats What is the new requirement?Requirement is that the new Client (let's call them xyz enterprise) provides us the Database access (Mysql, Oracle etc.) and we need to generate the XMLs from that DB that the application then transforms into BRE Request XMLs(using the same XSLT transformation above) and then do the rest of the following the same way. So basically we will have to get the data from the database directly instead of the XML files that abc provides.The business team eventually wants a UI where they can map the DB fields to the XML fields but the mapping part can be manual for the initial stage of this project.Ideally, there will be: Mapping the DB(s)to the fields required in the XML (Some kind of UI, with DB table dropdown and Column dropdown on the left and XML fields required on the right). Store this mapping and use it to pull data from Database to 'generate XML files that will be then transformed into BRE request XMLs' or ' generate BRE request XMLs directlySo my questions are: How do i approach this project? How and where do I store these mappings? Am I generating a XSD(or it some other file) after mapping and can leverage that in java to retrieve the data from DB?What libraries/tools can i leverage?The existing applications are written in Java. Not a very good one, but i am attaching a mockup of mapping screen
Database to XML Mapping to generate XMLs from DB data
java;design;sql;xml