SQL/MX Connectivity Service Manual (SQL/MX 3.x)

Overview of MXCS
HP NonStop SQL/MX Connectivity Service Manual—640327-001
1-2
Data Sources
•
NSM/web: Manages and configures MXCS service. Requires an installed web
server. NSM/web is not a server component because it does not run in the host. It
is a client component.
Data Sources
A datasource is a logical grouping of MXOSRVRs. The data source definitions include
the basic configuration performed on the data source. MXCS requires data source
definitions on the NonStop server, and for ODBC clients on the client workstation.
Server Data Sources
Server data sources reside on a NonStop server. Each server data source represents a
pool of SQL MXCS servers that share the same NonStop SQL context. Use NSM/web
Figure 1-1. MXCS Architecture - Interactions Among Three Components
Client Interface
(Windows 98, 2000,
2003, or NT4)
Tdm_Default
_
_DataSource
Other
Data Source
Client Components Server Components
MXCS Service
VST1001.vsd
Management Interface
(Web Browser)
MXCS
SQL Server
Client Application
Association
Server
Configuration
Server
MXCS
SQL Server
Client API
Client Driver Manager
Client Driver
NonStop Server
ODBC/MX
Configuration
Data
SQL/MP
Database
SQL/MX
Database
NSM/
web
NSM/web MXCS
Management Servers