New Mexico

1
New Mexicos Evolving Water Rights Information
System
2
OSE IT 1993

• Paper Records (90 years)
• Limited Technology
• No Enterprise Vision
• No Project Coordination
• No Integration
• No Basic IT Services
• No IT Funding
• Two IT Employees

1993
Paper
3
OSE IT 1993

• Paper Records (90 years)
• Limited Technology
• No Enterprise Vision
• No Project Coordination
• No Integration
• No Basic IT Services
• No IT Funding
• Two IT Employees

(APPLICATIONS)

• Core Development Tools
• None

1993
Paper
4
OSE IT 1993

• Paper Records (90 years)
• Limited Technology
• No Enterprise Vision
• No Project Coordination
• No Integration
• No Basic IT Services
• No IT Funding
• Two IT Employees

(INFRASTRUCTURE)

• Network, Server, Desktop
• Novell (one file print server)
• 3270 Terminals

1993
Mainframe
5
OSE IT 1997

• Database
• 4GL Client/Server Apps (telnet sessions)
• IT Services
• IT Funding
• Project Coordination
• Enterprise Vision
• Integration
• Seven IT Employees

(APPLICATIONS)
WATERS(4GL telnet)

• Core Development Tools
• IBM Informix 4GL C
• MS Access
• MS Visual Basic

1997
Imaging
WRATS
1993
Paper
6
OSE IT 1997

• Database
• 4GL Client/Server Apps (telnet sessions)
• IT Services
• IT Funding
• Project Coordination
• Enterprise Vision
• Integration
• Seven IT Employees

(INFRASTRUCTURE)
Windows 95
ETHERNET

• Network, Server, Desktop
• Novell/Ethernet CAT 3/5-10BaseT
• 3270 Terminals
• OpenMail (email)
• Netscape Enterprise Server (Web)
• HP 9000-H70/HP-UX 9
• IBM Informix RDBMS 7.13
• Desktop PCs (Windows 3.1/95)

1997
HP Server
INFORMIX
1993
Mainframe
7
OSE IT 2001

• Database
• 4GL Client/Server Apps (telnet sessions)
• IT Services
• IT Funding
• Enterprise Vision (first web app)
• Project Coordination
• Limited Integration
• Nine IT Employees

(APPLICATIONS)
iWATERS I(javascript)
2001
WATERS(4GL telnet)

• Core Development Tools
• IBM Informix 4GL C
• MS Access
• NetConnect (server-side javascript)
• BEA Webgain Studio
• Merant PVCS
• MS Visual Basic

1997
Imaging
WRATS
1993
Paper
8
OSE IT 2001

• Database
• 4GL Client/Server Apps (telnet sessions)
• IT Services
• IT Funding
• Enterprise Vision (first web app)
• Project Coordination
• Limited Integration
• Nine IT Employees

(INFRASTRUCTURE)
Windows NT
2001
Network Upgrades
Windows 95
Server Upgrades
ETHERNET

• Network, Server, Desktop
• Ethernet (CAT 5-100BaseT)
• OpenMail (email)
• Netscape Enterprise Server (Web)
• Apache Web Server
• HP 9000-L2000/HP-UX 10
• IBM Informix RDBMS 9.21
• Desktop PCs (Windows NT)
• Servers (Windows NT)

1997
HP Server
INFORMIX
1993
Mainframe
9
OSE IT 2003

• Database
• n-tier Web Apps
• IT Services
• IT Funding
• Enterprise Capability (eGIS eWATERS)
• Project Coordination
• Integration
• Open Source Tools
• Sixteen IT Employees

(APPLICATIONS)
Litigation Support
eGIS
eWATERS(J2EE)
iWATERS I(javascript)
2003
2001
iWATERS II(MVC)
WATERS(4GL telnet)

• Core Development Tools
• IBM Informix 4GL
• MS Access
• NetConnect Java Servlets (MVC)
• J2EE (EJBs/Servlets/JDBC/Applet)
• BEA Webgain Studio Eclipse IDE
• Merant PVCS Subversion
• MS Visual Basic

1997
Imaging
WRATS
1993
Paper
10
OSE IT 2003

• Database
• n-tier Web Apps
• IT Services
• IT Funding
• Enterprise Capability (eGIS eWATERS)
• Project Coordination
• Integration
• Open Source Tools
• Sixteen IT Employees

(INFRASTRUCTURE)
Windows 2000
2003
Windows NT
More Upgrades
2001
Network Upgrades
Windows 95
Server Upgrades
ETHERNET

• Network, Server, Desktop
• Ethernet (CAT 5 1GB Fiber)
• OpenMail (email)
• Apache Web Server
• DNS Firewall
• HP 9000-L2000 HP-UX 10
• Informix RDBMS 9.3
• PCs (Windows 2000 Pro)
• Servers (Windows 2000 Adv Server)

1997
HP Server
INFORMIX
1993
Mainframe
11
OSE IT 2006

• Database
• n-tier Web Apps
• IT Services
• IT Funding
• Enterprise Capability
• Project Coordination
• Integration
• Open Source Tools
• Sixteen IT Employees

(APPLICATIONS)
Litigation Support
2006
eGIS
eWATERS(J2EE)
iWATERS I(javascript)
2003
2001
iWATERS II(MVC)
WATERS(4GL telnet)

• Core Development Tools
• IBM Informix 4GL
• MS Access
• Java Servlets (MVC)
• J2EE (EJBs/Servlets/JDBC/Applet)
• Eclipse IDE w/ MyEclipse plug-ins
• Subversion w/ Apachemod_dav_svn
• MS Visual Basic

1997
Imaging
WRATS
1993
Paper
12
OSE IT 2006

• Database
• n-tier Web Apps
• IT Services
• IT Funding
• Enterprise Capability
• Project Coordination
• Integration
• Open Source Tools
• Sixteen IT Employees

(INFRASTRUCTURE)
DNS Firewall
Windows 2000
2006
2003
Windows NT
More Upgrades
2001
Network Upgrades
Windows 95
Server Upgrades

• Network, Server, Desktop
• Ethernet (Cat 5 1GB Fiber)
• Enterprise email (MS Exchange)
• Radio MPLS Link to GSD-IT
• DNS, Firewall, FTP Server
• HP 9000-RP4440/HP-UX 11i
• Informix RDBMS 9.4
• PCs (Windows 2000 Pro/XP)
• Servers (Windows 2000/2003 Server)

ETHERNET
1997
HP Server
INFORMIX
1993
Mainframe
13
OSE IT Future
(NEAR)

• Database
• n-tier Web Apps
• IT Services
• IT Funding
• Enterprise Capability
• Project Coordination
• Integration
• Open Source Tools
• Sixteen IT Employees

(APPLICATIONS)
Future
Litigation Support
2006
eGIS
eWATERS(Java EE)
iWATERS I(javascript)
2003
2001
iWATERS II(MVC)
WATERS(4GL telnet)

• Core Development Tools
• Informix 4GL Java
• MS Access
• Java Servlets (MVC)
• J2EE (EJBs/Servlets/JDBC/Applet)
• Java EE, EJB 3, Web Services, SOA
• Eclipse IDE MyEclipsePro plug-ins
• Subversion w/ Apachemod_dav_svn
• Visual Basic Java

1997
Imaging
WRATS
1993
Paper
14
OSE IT Future
(NEAR)

• Database
• n-tier Web Apps
• IT Services
• IT Funding
• Enterprise Capability
• Project Coordination
• Integration
• Open Source Tools
• Sixteen IT Employees

(INFRASTRUCTURE)
DNS Firewall
Future
Windows 2000
2006
2003
Windows NT
More Upgrades
2001
Network Upgrades
Windows 95
Server Upgrades

• Network, Server, Desktop
• Ethernet (Cat 5 1GB Fiber)
• Enterprise email (MS Exchange)
• Radio MPLS Link to GSD-IT
• DNS, Firewall, FTP Server
• HP 9000-RP4440/HP-UX 12
• Informix RDBMS 10
• PCs (Windows XP/Vista)
• Servers (Windows 2003 Server AD)

ETHERNET
1997
HP Server
INFORMIX
1993
Mainframe
15
OPEN SOURCE ITSB (A PRAGMATIC APPROACH)
16
OPEN SOURCE ITSB (A PRAGMATIC APPROACH)

• THE 3 Ps
• PrioritiesDoes an open source solution address
  priorities?
• PossibilitiesWhat open source solutions are
  available?
• PracticalitiesWhich open source solutions are
  practical?

17
OPEN SOURCE ITSB (A PRAGMATIC APPROACH)
THE 6 Ps
Proper Planning Prevents Piss Poor Performance
18
ALIGNING IT PRIORITIES TO OPPORTUNITIES

• ITSB Priorities
• Maximize Productivity(rabidly avoiding
  technology churn thrash)
• Minimize Risk(carefully choosing targeting
  technologies)Jan 9, 2006 Peter Quinn - CIO who
  brought OpenOffice to Massachusetts resigns
• Save Money(leveraging open source solutions)
• Save Time(empowering resources)

• ITSB Opportunities
• Business Needs Focus(as opposed to technology
  desires focus)
• Robust Toolkits(as opposed to flakey OTS
  behemoths)
• Minimal Cost(as opposed to expensive per-seat
  licensing)
• Automation(as opposed to error-prone manual
  drudgery)

19
LOW-RISK OPEN SOURCE OPTIONS

• PHASE I Software Development Life Cycle
• Requirements Issue Management
• Bugzilla
• Tracker
• gtTrack
• Test Automation
• gtjunit
• gtjwebunit
• gthttpunit
• gtcactus
• gtFIT
• Team Training Collaboration
• gtWebsite (Eclipse/XM)
• gtJSPWiki

Opportunities Realized More Focused on
Business Needs More Robust Toolkits Continued
Minimal Cost Automated Testing Improved
Communication
20
MEDIUM-RISK OPEN SOURCE OPTIONS

• PHASE II Development Environment
• Software Change Management
• CVS
• RCS
• gtSubversion Apache mod_dav_svn
• Automated Build Management
• Shell Script
• Make
• gtANT
• Integrated Development Environment
• gtEclipse Platform Plug-ins
• NetBeans Plug-ins

Opportunities Realized Robust Toolkits Minimal
Cost Automated Builds Deployments
SDLC Optimized
21
HIGH-RISK OPEN SOURCE OPTIONS

• PHASE III Runtime Environment
• Web Application Server
• gtApache Tomcat
• ?Jboss AS
• Operating System
• ?LINUX
• ?Open Solaris

Possible Opportunities M i n i m a l C o s t
22
JBoss 3.x
Apache 2.x
DEV SERVER
WINDOWS 2000 Adv Server SP4
changes(Windows Explorer)
changes(http-WebDav)
issues(http)
USER
Tortoise
ECLIPSE
ANALYST
Track Web App
MyEclipseplug-ins
SubClipseplug-in
files folders
MANAGER
devops
XM plug-in
FIT plug-in
tables fixtures
DEVELOPER
devwork
FIT test, run, debug
FIT
OSE/ISCWeb Site
HTML
JUNIT test,run,debug
eWATERSWeb App
JWebUnit
DEV WORKSTATION
WINDOWS 2000 PRO SP4 or WINDOWS XP PRO SP2
deploy debug
http
http
NMOSE/ITSB Dev Tools Dev Environment
Relationship
data sp
text ksh
HP/UX
DATA/LEGACY SERVER
data (view)
APP SERVER WINDOWS 2000/2003 Server
LEGAL SERVER
(WIN2K)
23
Maximizing Productivity Leveraging IDE for Agile
Development
CONSTRUCTION BUILDING
24
Maximizing Productivity Leveraging IDE for Agile
Development
DEPLOYMENT
25
Maximizing Productivity Leveraging IDE for Agile
Development
APPLICATION SERVER MANAGEMENT
26
Maximizing Productivity Leveraging IDE for Agile
Development
UNIT TESTING (JUNIT)
27
Maximizing Productivity Leveraging IDE for Agile
Development
INTEGRATION TESTING (FIT plug-in)
28
Maximizing Productivity Leveraging IDE for Agile
Development
SERVER-SIDE DEBUGGING
29
Maximizing Productivity Leveraging IDE for Agile
Development
CLIENT-SIDE DEBUGGING
30
SUCCESSFUL USE OF OPEN SOURCE

• Priorities Satisfied
• Productivity Maximized(automating build, deploy,
  and test cycles of SDLC)
• Risk Minimized(using process-proven, robust open
  source tools)September, 2006 Joe Summars -
  Manager who brought open source to ITSB/NMOSE
  still on the job ?
• Money Saved(zero-cost licensing)
• Time Saved(through optimized SDLC)

• Opportunities Realized
• Focus on Business Needs(using tools that fit
  SDLC)
• Toolkits are Robust(not struggling with tools)
• Cost is Minimal(zero-cost licensing)
• Automation(build, deploy, and test automated)

31
EVOLVING NMOSE/ITSB PEOPLE
DIVISION CHIEF
GIT
Nancy Knouse
Gar Clark
Stephen Hayes
IT SUPPORT
Lisa Barela
John Buchser
Jon Lemasters
Chris Lopez
Rodney McKnight
Tarmo Sutt
IT APPLICATIONS DEVELOPMENT
vacant
Joe Summars
Mercedes Ortega
Michael Mackenzie
Jina Lindsay
Diana Hardy
Daniel Harris
Brent Pearce
Contractor Thirumaleswara Thiruveedula
32
Contact Information
Joe Summars Applications Development
Group Information Technology Systems Bureau New
Mexico Office of the State Engineer 407 Galisteo
Street Bataan Memorial Bldg., Ste. 130 Santa Fe,
NM 87501 [phone] joe.summars_at_state.nm.us h
ttp//www.ose.state.nm.us
33
Open Source Resources
Track Ant Eclipse MyEclipse Subversion Subcl
ipse Tortoise SVN junit FIT Httpunit jwebunit
Cactus XM JBoss JSPWiki
http//www.trackplus.de/ http//ant.apache.org/ ht
tp//eclipse.org/ http//www.myeclipseide.com/ htt
p//subversion.tigris.org/ http//subclipse.tigris
.org/ http//tortoisesvn.tigris.org/ http//www.ju
nit.org/index.htm/ http//fit.c2.com/ http//httpu
nit.sourceforge.net/ http//jwebunit.sourceforge.n
et/ http//www.ananas.org/xm/ http//jakarta.apach
e.org/cactus/ http//labs.jboss.com/portal/ http/
/jspwiki.org/
34
Questions?