90 likes | 230 Views
Share Solution for XML Converter. 25 March 2003. Back Ground. Some member banks of FBA have no solution to convert from Text files to XML files to submit BOT DMS system of BOT. SCB and SCNB, we have solution to convert from CSV files to XML files as a part of our solution. Scope Definition.
E N D
Share Solution for XML Converter 25 March 2003
Back Ground • Some member banks of FBA have no solution to convert from Text files to XML files to submit BOT DMS system of BOT. • SCB and SCNB, we have solution to convert from CSV files to XML files as a part of our solution.
Scope Definition OLTP OLTP OLTP TXT TXT TXT DB CSV XML TXT XML CSV XML XML
What is CSV? • CSV is Comma Separated Value • CSV is the Text File. • CSV can be opened by Text Editor. • CSV can be opened by Excel. • Normal Text Sample • SomboonHirunpattarasilp112389 • CSV Text Sample • “Somboon”,”Hirunpattarasilp”,112389
Solution Components • Server • Data Stage Software License • ETL development modules CSV to XML • Open Source Codes by Standard Chartered • Development modules TXT to CSV
Benefit of Open Sources • Establish Community • Reduce Development Time • Reduce Investment Cost • Initial Cost • Server • Data Stage Software License • Reduce Development Cost • Maintenance Cost • Share Cost on Changes • Reduce Impacts of Changes • XML Schema Changes • Fields Deduction
Alternative • Option I • Each banks has own system. • Option II • Service Center
Pro & Con of Option I • Pro • Each banks has own tool ready to support further requests from e-government. • Each banks does their own process. No dependency. • Con • High investment • Each bank has to have their own operators and administrator.
Pro & Con of Option II • Pro • Low initial investment. • Con • Need to clarify about data confidential issues • Some dependency because of service centralization • Remark. The service center has to receive and process data for every member banks.