s ervices Presented by Harsh Jha Sandeep University of Minnesota Class Topics XML Schema integration in Distributed DBMS Sources Wikipedia OFX Official Site httpwwwofxnet ID: 515139
Download Presentation The PPT/PDF document "Evolution of OFX to facilitate online fi..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Evolution of OFX to facilitate online financial services
Presented by:Harsh Jha, SandeepUniversity of Minnesota
Class Topics: XML, Schema integration in Distributed DBMS
Sources
:
Wikipedia
OFX Official Site (
http://www.ofx.net
)
taxOpen Financial Exchange 2.0 Earning Broad Industry Support (January 03, 2001)
Fundamentals of Database Systems (Chap. 12), Elmasri et al.
Harness the power of XML to Open Financial Exchange files, Colin Beckingham (March 17, 2009)Slide2
OFX Introduction
CUSTOMERSConsumersFamilies
Tax PayersSmall BusinessesINSTITUTIONS
Financial Institutions
Financial Advisors
Government Agencies
Merchants and BusinessesInformation ProvidersTransaction Processors
OFX is a framework for exchanging data
.
Employs schema integration.Slide3
Well-formed and valid XML
Well Formed:Has XML declaration Indicates version of XML being used as well as any other relevant attributesEvery element must matching pair of start and end tags Within start and end tags of parent elementValid XML:Must be well-formed
Follows a schemaSlide4
Example of an OFX file
Header:OFXHEADER:100DATA:OFXSGMLVERSION:102SECURITY:NONEENCODING:USASCII
CHARSET:1252COMPRESSION:NONEOLDFILEUID:NONE
NEWFILEUID:NONE
Body:
<OFX> <SIGNONMSGSRSV1> … </SIGNONMSGSRSV1> <BANKMSGSRSV1> …
<STMTTRN>
<TRNTYPE>PAYMENT
<DTPOSTED>20050824080000
<TRNAMT>-80.32
<FITID>219378
<CHECKNUM>1044
<NAME>FrogKick Scuba Gear </STMTTRN> … </BANKMSGSRSV1></OFX>
Well Formed XML?
Valid XML?Slide5
XML-ized OFX versionHeader:<?xml version="1.0" encoding="ASCII"?>
<?OFX OFXHEADER="200" VERSION="211" SECURITY="NONE" OLDFILEUID="NONE" NEWFILEUID="NONE"?> Body:<OFX> <SIGNONMSGSRSV1> … </SIGNONMSGSRSV1> <BANKMSGSRSV1> … <STMTTRN> <TRNTYPE>POS</TRNTYPE> <DTPOSTED>20050824080000</DTPOSTED> <TRNAMT>-80</TRNAMT> <FITID>219378</FITID> <NAME>FrogKick Scuba Gear</NAME> </STMTTRN> … </BANKMSGSRSV1> <CREDITCARDMSGSRSV1> … </CREDITCARDMSGSRSV1></OFX>
Parse OFX XML files (an example):
<?
php
// test
ofx$xmlstr = file_get_contents('sample.xml');$xml = new SimpleXMLElement($xmlstr);
echo $xml->BANKMSGSRSV1->STMTTRNRS->STMTRS->TRNAMT."\
n";
?>Slide6
Understanding OFX
Created on January 16, 1997 by Microsoft, Intuit and CheckFree.Convergence of their respective payment protocols.
Streamlines processes of financial institutions.Full data synchronization and complete error recovery.
Over 5500 financial institutions use it.Slide7
Impacts/Applications of OFX
Tax SoftwaresE-bill payPersonal Financial Management SoftwaresFinancial software developmentInterbank/Intrabank funds transferSlide8
Thanks!Questions?