Web-enabling the Enterprise

1
Web-enabling the Enterprise

• Craig McQueen
• Sage Information Consultants Inc.

2
Web-enabling the Enterprise Overview

• Windows DNA
• Universal Data Access
• Data Transformation Services
• DCOM
• Miscellaneous

3
Web-enabling the Enterprise Goals

• Build and deploy web applications quickly
• Leverage existing technology investment
• Leverage existing employee skill set
• Maintain clear distinction of responsibilities
• Scalability

4
Windows DNA Architecture
The cheerleading version...
5
Windows DNA Architecture
D
Distributed

• Computing machines spread across space and time
• Space - office, corporation, world
• Time - Legacy systems
• Different operating systems and capabilities

6
Windows DN A Architecture
N
interNet

• Network - set of connected nodes
• Connected - enabling machines to communicate
• Protocols - set of mutually agreed upon rules of
  procedure stating how two or more parties are to
  interact to exchange information

7
Windows DNA Architecture
A
Applications

• Application - set of software technologies
  working together to solve a problem
• Many types of tools required for development
• Base services used across all applications

8
Windows DNA Leveraging the Enterprise
9
Windows DNA What the Enterprise Provides

• Optimized data storage
• Business rules
• Business object model
• Transactional support

10
Windows DNA What Web Applications Provide

• User interface(s)
• Targeted customer delivery
• Added value through information
• Customer support
• Rich, real-time marketing information based on
  customer behaviour

11
Universal Data Access Goals

• Microsofts strategy for providing access to
  information across the enterprise
• Variety of information sources, including
  relational and non-relational
• Easy to use programming interface that is tool
  and language independent

12
Universal Data Access Architecture
13
Universal Data Access Leveraging the Enterprise
ODBC
OLE DB
14
Universal Data Access Variations

• ADO used within ASP
• ADO used within COM objects
• ADO calls straight to the database
• ADO calls straight to programs
• Stored procedures wrap existing programs

15
Universal Data Access Sample Physical
Architecture
Router
Enterprise Server
Web Server
Customer
Firewall
16
Universal Data Access Integration with IBM
DB2/AS400

• AS/400 is IBMs server line for the Enterprise
• Range in size from supporting 350 clients to 8000
  clients
• DB/2 is 64-bit relational database system for the
  AS/400

17
Universal Data Access Integration with IBM
DB2/AS400

• IBM Client Access ODBC Driver
• Microsoft SNA Server OLE DB Provider for AS/400
  and VSAM
• IBM Client Access OLE DB Provider

18
ODBC Access IBM Client Access - Features

• ODBC driver for DB2/400 is part of Client
  Access/400
• Access to files and stored procedures
• Been around for a long time

19
ODBC Access IBM Client Access - How to Configure

• Install Client Access
• Configure Client Access connection to AS/400
• Run the CWBCFG utility
• Add a System DSN and select the driver, "Client
  Access ODBC Driver (32-bit)

20
ODBC Access IBM Client Access - Sample Access
objConnection.Open "Data SourceAS400_DSNUser
IDUSERIDPasswordPASSWORD"
21
ODBC Access IBM Client Access - Notes

• Previous to V4R4 no native SQL, must wrap
  programs
• V4R4 can create SQL but required to purchase a C
  compiler
• Errors on AS/400 can cause client to hang
• Firewall
• Beware the single-threaded driver!

22
ODBC Access IBM Client Access - Tips

• The ODBC client can easily hang
• Default error handling on AS/400 prompts for user
  intervention
• Legacy programs may depend on a display
• Can add multiple default libraries

23
OLE DB Access Microsoft SNA - Features

• Access record-level data in mainframe VSAM,
  Partitioned Data Sets (PDS), and midrange OS/400
  files
• A "source" Distributed Data Management (DDM)
  requester implementation that can initiate DDM
  commands to be serviced by a remote host-based
  "target" DDM server

24
OLE DB Access Microsoft SNA - Features (cont)

• Set attributes and a record description of a host
  file (column information)
• Lock files and records
• Record navigation
• Seek to a record based on an index.
• Change records in a file.
• Insert new records and delete records in a file

25
OLE DB Access Microsoft SNA - How to Configure

• Set up both an SNA client and SNA server
• SNA client is installed on the web server
• Configure a data source through the Microsoft
  Management Console

26
OLE DB Access Microsoft SNA - How to Configure
27
OLE DB Access Microsoft SNA - Sample Access
objConnection.Open "ProviderSNAOLEDBUser
IDUSERIDPasswordPASSWORDData SourceSAMPLE
SOURCE"
28
OLE DB Access Microsoft SNA - Notes

• Cannot get output parameters
• Firewall ports 1477 and 1478 PLUS ports to
  enable NT Authentication
• Not specific to an AS/400
• Require a machine to run SNA Server

29
OLE DB Access IBM Client Access - Features

• Record level access to tables
• SQL stored procedures and SQL statements
• Data queues
• Programs
• CL commands

30
OLE DB Access IBM Client Access - How to
Configure

• Install Client Access on the web server
• Configure Client Access connection to AS/400
• You are done!

31
OLE DB Access IBM Client Access - Sample Access
objConnection.Open "ProviderIBMDA400Data
SourceSYSTEM_NAME"
32
OLE DB Access IBM Client Access - Notes

• Require log in via a dialog box when making a
  connection before Client Access Express V4R4M0
  (V3R2M0 has Record level access)
• Can call exiting programs with no changes
• Firewall

33
Data Transformation Services Overview

• Feature of SQL Server 7
• Import, export, and transform data between
  Microsoft SQL Server and any OLE DB, ODBC, or
  text file format
• Can be scheduled
• Can modify/transform data during import

34
Data Transformation Service Benefits for
Web-based Application

• Enterprise data sometimes not available 24X7
• Off-load Internet load from enterprise system
• Security
• Transform data for presentation to the public

35
Data Transformation Service Example - Store
Locator

• Store address recorded in enterprise system
• Want to built an Internet application to find
  nearest store
• Use DTS to move data to SQL Server nightly
• Build web application on SQL Server

36
Data Transformation Service Wizard
37
Data Transformation Service Wizard
38
Data Transformation Service Wizard
39
Data Transformation Service Wizard
40
Data Transformation Service Wizard
41
Data Transformation Service Wizard
42
Data Transformation Service Wizard
43
DCOM SAP

• SAP is worlds largest enterprise software
  company
• Integrates an organization from financials and
  human resources to manufacturing and sales and
  distribution
• Main value is data schema and business rules

44
DCOM SAP on the Internet

• Web-enabling SAP extends the enterprise to
  business customers and partners
• Leverage business rules and data schema
• Provide rich UI and broader reach with web
  application
• Enables choice (targetted) user interfaces

45
DCOM SAP DCOM Component Connector

• Enables a Windows programmer to view SAP Business
  Objects and Business APIs (BAPIs) as native COM
  components
• Integrate RFC tables and structures with the
  standard Windows data access technology OLEDB/ADO
• Integrate SAP into other aspects of the
  organization

46
DCOM SAP DCOM Component Connector

• Code generator provided by SAP - dont need to
  know C-based APIs!
• Creates standard MTS components that are based on
  SAP ABAP objects
• SAP components can participate in transactions
  with other MTS components

47
DCOM SAP DCOM Component Connector
48
DCOM Integration with MTS
49
DCOM Destinations
50
DCOM Destination Details
51
DCOM Monitoring connections
52
DCOM SAP DCOM Component Connector
lt Dim oRS ' ADODB.RecordSet Dim
oSAPDataObj ' SAPDemoObj.SAPDemoObj Set
oSAPDemoObj Server.CreateObject("RFCSampObj.R
FCSampObj.1") oSAPDemoObj.Destination "TEST"
Call oSAPDemoObj.GetCustList( "", "" ,
oRS ) gt
53
Other Options COM Transaction Integrator (COMTI)

• Execute Customer Information Control Systems
  (CICS) (LU 6.2) or Information Management Systems
  (IMS) transactions on MVS systems
• COMTI-created components appear as simple
  automation servers that developers can easily add
  to their application

54
Other Options MSMQ

• Access message queuing systems on other platforms
• SNA Server 4.0 SP2 has MSMQ-MQSeries Bridge that
  allow interoperation with IBM's MQSeries

55
Other Options XML

• Share data with other applications
• RPC via XML (example XML server for SAP by
  webMethods)
• Come see Using XML for E-commerce

56
Web-enabling the Enterprise Call to Action

• Look for functionality in Enterprise that can be
  extended via the Web
• Keep responsibilities where they belong
• Leverage existing data, applications and skills

57
Web-enabling the Enterprise Questions?