Unicode in Enterprise Portal Solutions

1. Unicode in Enterprise Portal Solutions by Michael G. McKenna / Sybase, Inc. mgm@sybase.com v.1.0 March, 2000

2. Introduction • Business Issues • eCommerce Transactions • Technologies • Internationalization Capabilities • Other needs

3. Business Issues • What is an Enterprise Portal? • What is your market? • International marketing • Payments • Post-sales support

4. FinancialInst. E-CommCo. Client Transaction Diagram • Buyer/Client • Enterprise Portal: Vendor • Financial Institution • Communication protocols • Differing Standards Vendor

5. Transact Req time Client Verify Req Client Verify Confirm Transact Confirm Prod Order Prod Order Confirm Vendor Financial Institution eCommerce Co. Client / Buyer Ship Product Shipping Confirm Shipping Confirm $ Transfer Req $ Transfer Confirm Example Transaction

6. 5 IBM... ...QFR.... .. SYB... /8... 7 /8 1 6 /8... System Management Auditing System Configuration Performance Monitoring Security Enterprises in the Real World PeopleSoft WWW Clients SYBASE Baan DB2 Application Integration Oracle Java, EJBJ2EE Distributed Commerce Information Multiple SQL Database Access Embedded Training Flat Files Web Servers Legacy & Non- Relational Data Real-Time Mainframe Data XML Protocols Plug & Play Users TCP/IP HTTP CORBA

7. 5 IBM... ...QFR.... .. SYB... /8... 7 /8 1 6 /8... System Management Auditing System Configuration Performance Monitoring Security Enterprises in the Real World PeopleSoft WWW Clients SYBASE Baan DB2 Application Integration Oracle Java, EJBJ2EE Distributed Commerce Information Multiple SQL Database Access Embedded Training Flat Files Web Servers Legacy & Non- Relational Data Real-Time Mainframe Data XML LAN-Based Systems Plug & Play Users TCP/IP HTTP CORBA

8. IBM... ...QFR.... SYB... /8... 6 /8... Global EnterprisesPortal Requirements PeopleSoft Multilingual WWW Clients SYBASE Multi-local Business Rules Baan DB2 Application Development Oracle Java, EJBJ2EE XML - data Java - code Multiple SQL Database Access Distributed Enterprise Information Embedded Training Flat Files Remote Backup Legacy & Non- Relational Data Real-Time LocalizablePreserveculturalcontext SeamlessInteroperability (IDL/CORBA) Mainframe Data System Management Auditing XML LAN Based Systems Plug & Play Users System Configuration Performance Monitoring TCP/IP HTTP CORBA Security

9. Technical Issues • Protocols • http/ftp • IIOP • EDI • APIs • IDL • Java • JavaScript • HTML (post, cgi, NAS, etc.)

10. Technical Issues (2) • Data Content Standards • HTML • Unicode • MIME • XML • System Integration • CORBA • Heterogeneous systems • Unix, Wintel, Mac • Locale determination • User, http, client profile

11. Technical Issues (3) • Application Integration • Business Rules • Data mapping • API mapping • Transaction expectations • Cross-national data security • UI • User Language, Country, Region • Cultural Screen Display • Colors, BiDi, density, fonts, text-expansion, layout • Input methods needed?

12. Example Message (DTD) <?xml version="1.0"encoding="UTF-8" ?> <!DOCTYPE Book [ <!ELEMENT Book (BookDesc)+ > <!ELEMENT BookDesc (Title, Author, Publisher, ISBN, Price, CoverImage, Desc) > <!ATTLIST Book xml:lang CDATA #REQUIRED > <!ELEMENT Title (#PCDATA) > <!ELEMENT Author (#PCDATA) > <!ELEMENT Publisher (#PCDATA) > <!ELEMENT ISBN (#PCDATA) > <!ELEMENT Price (Currency, Amount) > <!ELEMENT Currency (#PCDATA) > <!ELEMENT Amount (#PCDATA) > <!ENTITY CoverImage EMPTY > <!ELEMENT Desc (#PCDATA) > <!ATTLIST CoverImagemage type (bmp|gif|jpg|other) "gif"> <!NOTATION gif SYSTEM ("gwswin/gws.exe"> <!NOTATION bmp SYSTEM ("gwswin/gws.exe"> <!NOTATION jpg SYSTEM ("gwswin/gws.exe"> <!NOTATION other SYSTEM ("gwswin/gws.exe"> ]>

13. Example Message (XML) <Book> <BookDesc xml:lang=“EN”> <Title>Java in a Nutshell</Title> <Author>David Flanagan</Author> <Publisher>O'Reilly & Associates </Publisher> <ISBN>156592262X</ISBN> <Price> <Currency>USD</Currency> <Amount>24.95</Amount> </Price> <CoverImage>jnut_us.gif</CoverImage> <Desc>The bestselling Java in a Nutshellhas been updated to cover Java 1.1. If you're a Java programmer who is migrating to 1.1, this second... </Desc> </BookDesc>

14. Example Message (XML) <BookDesc xml:lang=“DE”> <Title>Java in a Nutshell</Title> <Author>David Flanagan</Author> <Publisher>OReilly/VVA </Publisher> <ISBN>3897211009</ISBN> <Price> <Currency>DEM</Currency> <Amount>49.00</Amount> </Price> <CoverImage>jnut_de.gif</CoverImage> <Desc>Dieses Handbuch ist eine unentbehrliche Kurzreferenz, die dazu gedacht ist, aufgeschlagen neben der Tastaturjedes Java-Programmierers zu liegen. Es enthält eine... </Desc> </BookDesc>

15. Example Message (XML) <BookDesc xml:lang=“JP”> <Title> </Title> <Author>David Flanagan</Author> <Publisher> </Publisher> <ISBN>4-900900-08-7</ISBN> <Price> <Currency>JPY</Currency> <Amount>3900.00</Amount> </Price> <CoverImage>jnut_jp.gif</CoverImage> <Desc> ... </Desc> </BookDesc> </Book>

16. Sample User ID <UserId xml:lang=“EN”> <UserIdNum>A47US37892</UserIdNum> <Name>Bob Smith</Name> <Address>1226 Poplar Avenue</Address> <City>Detroit</City><Locality>MI</Locality> <PostalCode>84512</PostalCode> <Country>US</Country> ... <PaymentMethod> <Currency>USD</Currency> <Type>CC</Type> <Card>MC</Card> <CCNum>1234567812347890</CCNum> <ExpDate>03-2001</ExpDate> </PaymentMethod> </UserId>

17. Sample Order <Order> <OrderNum>20193786</OrderNum> <UserIdNum>A47US37892</UserIdNum> <ItemsOrdered> <Item> <ProductId> 156592262X </ProductId> <Qty>1</Qty> </Item> <Item> <ProductId> 3897211009 </ProductId> <Qty>12</Qty> </Item> <Item> <ProductId> 4900900087 </ProductId> <Qty>2</Qty> </Item> </ItemsOrdered> </Order>

18. Development Tools Management Tools FIX Other PB EJB OFX E-Com Messaging and Events Data and Applications Enterprise Information Portal Translation Services E-Banking E-Brokerage eCommerce Knowledge Management Custom Clients Application Server OFX FIX E-Com Other TMXOpenTag EJB Com CORBA Enterprise Integration ERP Integrators Partner Plug-in Enterprise Event Broker

19. Applications & Solutions Horizontal and Vertical Components & Services GlobalizationServices Portal Services Generic Services Infrastructure Software Enterprise Integration Enterprise Portal

20. CORBA and Code Set Conversion • Use Unicode for Inter-ORB global communications • OMG Common Object Services (COS) • Inter-ORB Bridge Support • General Inter-ORB Protocol (GIOP) • Internet Inter-ORB Protocol (IIOP) • Code Set Negotiation: use CONV_Frame IDL Diagram from “The Common Object Request Broker: Architecture and Specification”, Rev. 2.2, Chapter 11: ORB Interoperability Architecture

21. Monetary Transactions • Credit Card • e.g., JCB, Maestro, Visa, Mastercard • Bank Transfer • Automatic Deposit • Support multiple payment systems! • Support multiple currencies

22. Flexible Business Rules • Market validity rules • Is it legal to sell in that market? • Is it legal to sell specific products in that market? • Transaction Rules • Application Integration • Currency for payment • Shipping • Taxes

23. Future Issues • Corporate Education Issues • Standards • Standard Meta-Data • Native Language Messages

24. Summary For Global Enterprise Portals, add: • Unicode for universal language support • Standard API (CORBA/IDL) • Java for portable code • XML for portable data • Application Server for component integration • Planning and design