Section 7

1

• Section 7 Database Support

2
Database Integrations

• Export using
• .pdf
• .csv
• .txt
• SQL queries
• Oracle queries
• Java
• Email
• SNMP
• Web Services
• HTML
• XML
• OPC

KEY
Data Flow Direct
Data Flow through Web Supervisor
3
DB Integration Why?

• Make BAS data part of the Enterprise
• Financial management
• Asset management
• Enterprise Resource Planning (ERP) systems
• IT information systems
• Make BAS data available to other systems
• Work order management
• Capital improvement systems
• Energy management

4
Data Integration Methodologies Using

• Exporters using
• .pdf
• .csv
• .txt
• Custom JAVA exporter
• SQL Queries
• Oracle Queries
• Email
• Java DB Connectivity
• SNMP
• Web Services
• HTML
• XML
• OPC
• oBIX

5
DB Interface Definitions/Uses

• Exporters design to move data from matrix
  formats in JENEsys generally to Microsoft
  applications such as Access or Excel
• DB Queries (SQL, BQL, Oracle) allow JENEsys
  stored data to be retrieved by standardized query
  languages.
• Queries allow the user to specify a description
  of the desired result set, but it is left to the
  devices to perform the physical operations that
  produce the result

6
DB Interface Definitions/Uses

• SNMP Simple Network Management Protocol an
  open Internet standard SNMP exposes data on the
  managed system (JENEsys). This data can be
  queried (monitored) and written to (controlled)
  by the management system
• XML eXtended Markup Language a fee-free, open
  Internet standard whose purpose is to help
  information systems share structured data via the
  Internet
• Standardizes JENEsys data so any database
  application, program or system can read, share
  and communicate with the JENE.
• XML allows sharing of information between new and
  legacy data applications without spending any
  money on s/w acquisition

7
DB Interface Definitions/Uses

• oBIX - OASIS Open Building Information Exchange
• From an industry point of view
• Open Standard Protocol, XML based
• From a Tridium point of view
• The primary use of oBIX is to enable Niagara R2
  systems to communicate with Niagara AX (JENEsys)
  based systems
• R2 Development ended with launch of AX in 2005
  but R2 systems are widely installed and continue
  to be sold by some OEMs notably TAC/Invensys

8
Section 7 Takeaways

• Methods of DB Integration are numerous
• Integration methods generally have a license fee
  associated with them
• Most DB Integrations require
• Inclusion of PC-based Web Supervisor software on
  the network
• Transfer of data to Web Supervisor from the
  JENEsys platform
• This requires a communication protocol to be
  licensed on the JENEsys platform BACnet or Fox
• Fox is the primary protocol used Niagara to
  Niagara IP communication

9
Questions Section 7
?
?
?
?
10

• Section 8 Key Sales Points

11
Value Pyramid
12
Sales Benefits

• Preserves customer investment in legacy systems
• Extend the life of existing control systems
• Saves customer money by deferring product
  replacement
• Makes legacy systems and new Trane systems part
  of an integrated BAS network - Embrace not
  Replace.
• Legacy driver applications allow sharing of data
  from one system to another, allows greater
  flexibility for the customer when choosing
  equipment or services

13
Sales Benefits

• Future proof technology open solution
• Customer owns the IP and programming tools
• Multi-tier enterprise level system allows user to
  extend beyond HVAC control. (Lighting, Security,
  Energy Modeling, etc)
• Highly Scalable. Stand alone small building to
  multiple instances all communicating together

14
Future Proof Sales Points

• Open APIs invoked to run programs add value
  without touching source code - allows
  independently developed products and apps
• Scalable same software can be used in small low
  cost devices and at enterprise app level
• Internet, TCP/IP, Web Services value from
  1000s other applications example weather,
  stock price, soft t-stat
• Standards vendor independence ability to
  capture existing data ability to move quickly to
  new technologies example BAS 3-5 equipment
  10-30
• JAVA non proprietary programming language allows
  easy access to technical experts
• Embedded Technology Pay for what you use

15
Freedom of choice

• Manufacturer of choice
• Protocol of choice - BACnet, LonTalk, Modbus, and
  many legacy systems.
• Contractor independence
• Choice to select add-on applications and devices
  from third party suppliers
• Choice to extend the capabilities of the system
  through standard software interfaces

16
Lynxspring Benefits to Trane

• JENEsys products and related services complement
  not compete with Trane controls and equipment
• JENEsys enhances Tranes position as solution
  providers (equipment, service, control, energy
  reduction, information, etc) by delivering
  flexible hardware and software options to meet
  your customer needs.
• JENEsys product help expand existing Trane
  offerings (equipment sales, service, etc)
• Lynxspring provides secure access to Niagara
  technology and outstanding support of your
  technical and sales efforts

17
Section 8 Takeaways

• JENEsys adds planks to Tranes value pyramid
• Key sales point is the preservation of clients
  investment in controls and equipment
• JENEsys provides a future proof benefit to users
• JENEsys provides user with the freedom of choice
• Choice between Embrace or Replace

18
Questions Section 8
?
?
?
?
19

• Section 9 Legacy Solutions

20
Eliminate the Integration Gotchas

• Integration team requires someone with specific
  knowledge of the target control system. This
  can be a client employee, integration team member
  or a third party
• Integration may require 3rd party devices be
  installed in the target system
• The end client needs to provide Integration team
  with a list of points in the target system that
  require integration and the list needs to clearly
  indentify monitor points (read) and control
  points (read/write).
• End client needs to provide the integration team
  with access to the system during the life of the
  integration project including any maintenance
  period

21
Client Vs. Server ArchitectureN2 Integration
Examples
Ethernet LAN
CLIENT TYPE
SERVER TYPE
N2 Manager
Standard Browser
PDA/Cell
N2 System Bus
N2 System Bus
JENE is Managed by N2 Master This is a Server
Type License
JENE Manages N2 Devices This is a Client Type
License
22
Open Client Drivers
Driver Description Available From Price Published?
BACnet IP Client BACNet IP Client over Ethernet Lynxspring Yes
BACnet MS/TP BACNet MS/TP over RS-232 or RS-485 Lynxspring Yes
LON LON over twisted pair, FTT-10 Port (client and server) Lynxspring Yes
iLON iLON over Ethernet (client and server) Lynxspring Yes
Modbus RTU Modbus RTU over RS-232 or RS-485 Lynxspring Yes
Modbus TCP Modbus TCP over Ethernet Lynxspring Yes
M-Bus M-bus serial and IP Note1 Lynxspring No
oBIX Client oBIX Client over Ethernet Note1 Lynxspring No
OPC Client OPC Client over Ethernet Lynxspring Yes
SMS SMS over Ethernet Lynxspring No
SNMP SNMP over Ethernet Lynxspring No
Z-Wave Z-Wave via ACT RS232 to wireless interface Lynxspring No
23
Open Server Drivers
Driver Description Available From Price Published?
BACnet IP Server BACNet IP Server over Ethernet Lynxspring Yes
Modbus RTU Slave Modbus RTU Slave over RS-232 or RS-485 Lynxspring Yes
Modbus TCP Slave Modbus TCP Slave over Ethernet Lynxspring Yes
oBIX Server oBIX Server over Ethernet Note1 Lynxspring No
OPC Server OPC Server over Ethernet Note1 Lynxspring No
24
Legacy Client Drivers
Driver Description Available From Price Published?
AAM PHP American Automatix PHP over RS-232 or RS-485 Lynxspring Yes
AAM PUP American Automatix PUP over RS-232 or RS-485 Lynxspring Yes
Andover AC256 Andover AC256 over RS-232 or RS-485 Lynxspring Yes
Andover Infinity/Continuum Andover Infinity/Continuum Lynxspring No
Barber Coleman GCM Network 8000 RS232 driver Note2 Call No
Barber Coleman GCM Network 8000 RS232 driver Note1 Lynxspring No
Barber Coleman ASD Network 8000 ASD RS485 Driver Note1 Lynxspring No
Clipsal Cgate Server Driver Lynxspring No
Dynalite Dynalite Note2 Call No
E-Mon Meters Class 300, 500, and IDRs Note2 Call No
Global Cache Global Cache over Ethernet Note1 Lynxspring No
Helvar Helvar via RS232 to DALI interface Note1 Lynxspring No
Honeywell C-BUS AX interface to Softyon C-Bus OPC Server Call No
Honeywell C-BUS OPC interface to Softyon C-Bus OPC Server Call No
Honeywell Security Vista Note1 Call No
Honeywell Hometronic Hometronic via RS232 to wireless interface Note1 Call No
Horstmann Mainscomm Hortsmann powerline via RS232 interface module Note1 Call No
25
Legacy Client Drivers
Driver Description Available From Price Published?
Johnson Controls N2 Open Lynxspring Yes
Josam Grease Trap Sensor Josam Grease Trap Sensor Note1 Call No
Lang Oven Lang Oven over RS-232 or RS-485 Note1 Call No
Motion Control Engineering Motion Control Elevator Controller Interface over Ethernet Note2 Call No
OMRON FINS Ethernet Protocol Note1 Lynxspring No
Resol Resol via RS232 port Note1 Call No
Siebe, Robertshaw Microsmart Lynxspring No
Siemens System 600/Apogee RS-232 to MMI port Note2 Call No
Sonance/IPORT IPOD docking station Note1 Call No
TCS/BASYS RS-485 driver Note1 Call No
Trend Serial IQ Serial Driver Note1 Call No
Trend Ethernet IQ Ethernet Driver Note1 Lynxspring No
Ubiwave Ubiwave Note1 Call No
Veeder Root VeederRoot over RS-232 or RS-485 Note1 Lynxspring No
Wattstopper Miro Control of Miro wireless lighting devices Note2 Call No

26
Driver Notes

• Note 1
• Contact Lynxspring for Information
• Note 2
• Driver published by independent developer

27
Niagara Legacy

• Niagara R2 is the original O/S supported by
  Tridium
• Stopped development in 2005
• Continue to sell and support this O/S
• Vykon contractors
• TAC Invensys dealers
• Staefa dealers
• JENEsys O/S is AX
• Method to communicate R2 to AX is through the
  oBIX driver
• If an opportunity is specified Niagara, be sure
  to determine if it is R2 or AX
• Call Lynxspring for clarification if necessary

28
NiCS - NIagara Compatibility Statement

• Licensing model for Niagara OEMs to define levels
  and types of interoperability
• Two primary interactions
• Sharing of data between stations (application)
• Ability of the programming tool to engineer the
  station
• Limits are for security or competitive reasons
• JENEsys and tools are completely open
• Any Niagara-certified technician can work on the
  system
• Customers can always get the stations and
  programming tools (by others) opened up for Trane

Implications Service of the system
29
Section 9 Takeaways

• Qualify your opportunities
• Clearly identify the target systems
• Develop a plan
• Eliminate gotchas
• Know which drivers are off-the-shelf pricing and
  which require consultation with Lynxspring
• Be aware of differences in Niagara R2 and AX
• NiCS Who can service the system(s)

30
Questions Section 9
?
?
?
?
31

• Section 10 Solution Examples

32
Testimonials

• Using JENEsys we can sell more Trane controls,
  not less.  And we have just touched the surface
  of the potential that can be reached by
  combining the JENEsys solution with standard
  Trane controls.  The JENEsys product opens up
  more options. For example, we have the option of
  better integration to competitors' systems. This
  opens up opportunities for more Trane controls to
  be sold, and helps connect us with new customers
  to broaden our base of potential service
  contracts. 
• Steve Brimeyer of Trane Des Moines

33
Testimonials

• Lynxspring products have increased both our
  controls and equipment business by allowing us to
  integrate into other peoples systems. This has
  resulted in both increased equipment and service
  business. We now are able to talk to customers
  that we couldnt talk to in the past. We are
  doing a job right now with a school district that
  has four Johnson schools and one Honeywell.
  Before Lynxspring we would not have been
  considered. With Lynxspring, we have the job.
• Kevin Hauser at Harshaw Trane

34
Testimonials

• The Lynxspring product has helped us secure new
  business as well as expand our horizons on
  existing or new Summit. The product has made it
  possible for us to respond to requests from
  customers to integrate other competitive systems
  into our Summit Workstation.  Recently,
  Lynxspring assisted us with integration
  information from Network8000 through Lynxspring
  to Summit and we have responded favorably to the
  customer.  We have also used it to expand from
  our Summit system on a campus of one of the
  Energy Industry customers to pick up two JCI
  buildings and integrate the information through
  our Summit workstation.
• From Al Connelly at the Hunton Group (Houston
  Trane)

35
Testimonials

• Lynxspring has top graded our capabilities by
  providing Trane Arkansas with a larger tool set
  and more flexibility. As a result our people got
  better. We were also better able to focus on
  retrofit and service opportunities. Also, we had
  lost out to Niagara on some campus and
  government contracts and Lynxspring let us come
  back to compete for those jobs.
• Frank Mayfield of Trane Arkansas

36
Arkansas Tranes Frank Mayfields Case Study
37
Tactic 1 Target Competitive Controls Systems as
Service Opportunities

• Use knowledge of competitive controls to expand
  share of service customers
• Meet the owners need for comfort, reliability,
  efficiency
• Start with maintaining the incumbent system
• Leverage the lament Its not working now and
  its never worked!

2008 WEBINAR on SYSTEM INTEGRATION with a
TRANE Focus
38
Tactic 2 Map the Migration Path

• System Migration is going from proprietary to
  open
• System Migration is site specific
• Plan for spare parts through integration to
  become independent of the incumbent
• Promote an open vision
• Web enabled
• Competitive bidding for expansion and service
• Single seat operation
• Virtual services
• Sell the vision

2008 WEBINAR on SYSTEM INTEGRATION with a
TRANE Focus
39
Tactic 3 Make the building work better

• Selectively apply systems knowledge to enhance
  building operation
• Define your performance with the building stake
  holders
• Some items to consider for fast improvement
• Throttling ranges of VAV controller
• Reset setpoints to relax the system
• Nail humidity problems

2008 WEBINAR on SYSTEM INTEGRATION with a
TRANE Focus
40
Tactic 4 Overthrow the incumbent

• System crash issues
• Central Plant Efficiency
• System Obsolescence
• Parts not available, not reasonable about
• Workstation operating system (OS/2, win95)
• Single source for controls and equipment
• Is there hostility towards the incumbent?
• Plant the flag, Install the integration platform

2008 WEBINAR on SYSTEM INTEGRATION with a
TRANE Focus
41
Chenal Country Club

• 800 point Siemens' System 600
• Long standing equipment relationship
• Took advantage of poor performance of the
  incumbent to get the control service contract.
• Sold integration with JENE prior to major
  expansion and upgrade of facility
• Siemens to JENE to Summit (BACnet)
• Spec read connect to existing Summit system

2008 WEBINAR on SYSTEM INTEGRATION with a
TRANE Focus
42
Cypress Plaza

• Longstanding equipment relationship
• Andover OS/2 front end crashed
• Andover bid 15,000 to replace
• We cut their number and wound up paying some
  tuition
• There is still an orange box on the wall
• Building has renewed 3 times since Integration
• Mediocre relationship between owner and Andover
  went sour

2008 WEBINAR on SYSTEM INTEGRATION with a
TRANE Focus
43
Andover

• RS232 interface, dependent upon their building
  level panel for data
• Long update times, takes patience to operate
• Tough to support, have to reload data in segments

2008 WEBINAR on SYSTEM INTEGRATION with a
TRANE Focus
44
Siemens

• Ditto from Andover, low fidelity integration
• Be careful of taking on a new hospital with Div
  17 integrations
• Comfortable with SCUs and MBCs

2008 WEBINAR on SYSTEM INTEGRATION with a
TRANE Focus
45
TAC Vista

• 2 communications link configurations
• Classic (LonWorks)
• Lon (LonMark)
• Once you touch a classic network with a 3rd party
  tool the network is in jeopardy
• TAC LonMark is very well behaved
• Easy tunneling through JENE and ProBuilder with
  Menta engineering software

2008 WEBINAR on SYSTEM INTEGRATION with a
TRANE Focus
46
Johnson Controls

• JENE has both N2 Server and Client
• Our initial jobs were using FX 40, Johnson
  JACE, N2 driver and everything else Niagara

2008 WEBINAR on SYSTEM INTEGRATION with a
TRANE Focus
47
Other AX Drivers

• BC Network 8000
• CSI INET
• BACnet MSTP Alerton, Delta, Reliable, KMC, etc.

2008 WEBINAR on SYSTEM INTEGRATION with a
TRANE Focus
48
Niagara Framework

• Distech
• Carrier One
• Staeffa
• Invensys
• Honeywell
• Vykon
• Know the rules of access for other Niagara based
  systems
• Know the vendor specific tools

2008 WEBINAR on SYSTEM INTEGRATION with a
TRANE Focus
49
Caveat Integrator

• Must have a native guide
• Tools for set up and programming legacy unit
  controllers need to evaluated and maintained
• Integrations occur at different levels within
  competitive system architectures, understand the
  where and how
• Know the pitfalls, manage customer expectations
• Andover, CSI, JCI, Siemens Div 17 elements raise
  the bar
• Avoid one offs dont get spread too thin
• Know whats important schedules and setpoints
  carry large weight for everyday operators

2008 WEBINAR on SYSTEM INTEGRATION with a
TRANE Focus
50
Caveat Vendor

• Know the facts that threaten the credibility of
  the incumbent
• Clients sometimes will keep dancing with the one
  that brought us
• Most of Trane Arkansas JENE installations have a
  Summit front end
• Compliment the ICS story
• Step into the role of best of breed solutions
  provider

2008 WEBINAR on SYSTEM INTEGRATION with a
TRANE Focus
51
Arkansas Trane History with System Integration

• Andover
• Alerton
• Echelon (Distech, Viconics, HVAC equipment)
• Johnson
• KMC
• Siemens

2008 Lynxspring Partner Conference
Paradigm Return to Energy Savings
52
The Untouchables

• Novar
• TAC classic network

2008 Lynxspring Partner Conference
Paradigm Return to Energy Savings
53
Summary of Essential Information

• Fluency in legacy system, native guide
• Tools for legacy system
• Integration platform and protocol translators
• JENE
• Appropriate drivers
• Map of the job
• Current layout
• What are the systems actual functions?
• Where are they stashed?
• Applications knowledge
• HVAC systems
• IT

2008 Lynxspring Partner Conference
Paradigm Return to Energy Savings
54
The Intangible Ingredients

• Customer Expectations
• Speed
• Fidelity
• Connectivity
• Simplicity
• Customer Tolerance for Change
• One Client
• Many Customers Board Room to Boiler Room
• Thermostat and Time Clock habits

2008 Lynxspring Partner Conference
Paradigm Return to Energy Savings
55
Relationship Progression

• Repair
• Maintenance
• Enhancement
• Displace legacy OEM
• Listen and Discover
• Develop and Advocate a System Migration strategy

2008 Lynxspring Partner Conference
Paradigm Return to Energy Savings
56
Section 10 Takeaways

• JENEsys is working with many Trane offices as an
  Integration enabler
• There are many examples within the Trane
  community of successful integrations
• Review Frank Mayfields case study material for
  valuable and specific information

57
Questions Section 10
?
?
?
?