IA315 Developing an e-Commerce Web Site with PowerBuilder and Enterprise Application Server

1
IA315 Developing an e-Commerce Web Site with
PowerBuilder and Enterprise Application Server
Timothy P Beck Managing Partner IntelliServe
LLC tpbeck_at_intelliserve.com
2
Session No. 12345 Developing an e-commerce web
site with PB and EA Server
Timothy P Beck Managing Partner IntelliServe
LLC tpbeck_at_intelliserve.com
3
The Agenda

• Our Timeline
• What is e-commerce?
• What are the components of an e-commerce site?
• Our site Overview
• Our site Database
• Our site Jaguar / PowerBuilder Components
• Putting the Pieces together
• Questions and Answers

4
Our Timeline
0 5 15 30 45 55
65 75 90

• Introduction
• What is an e-commerce site
• The components of an e-commerce site
• Site Overview
• Site Database
• Jaguar / PB Components
• Putting the Pieces together
• QA

5
What is e-commerce?

• E-commerce (n)
• The buying and selling of goods trade business
  in an electronic forum or medium such as the
  internet.
• The ability to buy and sell via the internet.

6
e-commerce components

• The pieces of a web site which enable customers
  to purchase products and services
• Product List
• Selected Product Display
• Purchase Information Collection
• Purchase Method (Credit Card) Processing
• Order Confirmation

7
Site Overview
Home
Cart Summary
Search
Your Cart
Our Products
Contact Us
The Credit Card may be processed through a
gateway such as AuthorizeNet or VirtuaBill
Contact Thanks
Check Out
Order Summary
Confirm Order
8
Site Database

• Requirements
• Must contain product, customer and sales order
  information.
• Must respond quickly to client requests.
• Must be accessible from within PowerBuilder,
  Jaguar and PowerDynamo.
• Must be Robust.
• Our Choice
• Adaptive Server Anywhere 6.0

9
Site Database
10
Jaguar / PowerBuilder Components
Home
Cart Summary
Search
Your Cart
Our Products
Contact Us
Send Mail
Product List
View Cart
Add To Cart
Search
Contact Thanks
Check Out
Order Summary
Confirm Order
Order Summary
Process Card
11
Putting the Pieces together

• The Pieces
• Web Pages
• Server Side Script
• Server Side Components
• A Database
• A Web Browser
• A Credit Card Processor Gateway
• A Domain (www.OurSite.com)

12
Putting the Pieces together

• The Tools
• Adaptive Server Anywhere 6.0
• PowerDesigner 7.0
• PowerBuilder 7.02
• PowerSite7.1
• PowerDynamo 3.5
• Jaguar CTS 3.5
• Personal Web Server

13
Putting the Pieces together

• The Steps
• Create our Database using ASA 6.0
• Deploy our Schema to the database using
  PowerDesigner 7.0
• Populate the database with test data using
  PowerDesigner 7.0
• Create the Web Database Profile with PowerDynamo
  3.5
• Create the Web Pages using PowerSite 7.1

14
Putting the Pieces together

• The Steps (continued)
• Create the Server Components using PowerBuilder
  7.02
• Deploy our components to Jaguar CTS 3.5
• Create the Server Side Script to connect the web
  pages to the server side components using
  PowerSite 7.1
• Test the Site using our favorite browser and the
  Personal Web Server.
• Repeat Steps 2-9 as needed to complete the site.

15
Putting the Pieces together

• To meet our time frame, some of these steps have
  already been partially completed.
• The database schema has already been built.
• Most of the web pages have already been built.
• Most of the components have already been built
  from an ancestor library.
• The tools have already been configured for this
  demonstration.

16
Putting the Pieces together

1. Create our Database using ASA 6.0

17
Putting the Pieces together

1. Deploy our Schema to the database using
   PowerDesigner 7.0

18
Putting the Pieces together

1. Populate the database with test data using
   PowerDesigner 7.0

19
Putting the Pieces together

1. Create the Web Database Profile with PowerDynamo
   3.5

20
Putting the Pieces together

1. Create the Web Pages using PowerSite 7.1

21
Putting the Pieces together

1. Create the Server Components using PowerBuilder
   7.02

22
Putting the Pieces together
7. Deploy our components to Jaguar CTS 3.5
23
Putting the Pieces together
8. Create the Server Side Script to connect the
web pages to the server side components using
PowerSite 7.1
24
Putting the Pieces together
9. Test the Site using our favorite browser and
the Personal Web Server.
25
Summary

• What have we learned

26
Questions and Answers

• Its your turn .