Exporters using

Download Report

Transcript Exporters using

Section 7 – Database Support

Database Integrations

Corporate DB Niagara AX Web Supervisor Trane Summit Network

Export using:  .pdf

 .csv

 .txt

 SQL queries  Oracle queries  Java  Email  SNMP  Web Services  HTML  XML  OPC

Legacy Network KEY Data Flow Direct Data Flow through Web Supervisor

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

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

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

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

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

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

Questions: Section 7

Section 8 – Key Sales Points

Value Pyramid

Total Building Solutions 3 rd Party application integration Legacy Integration DB Integration Facility Management Power Demand Management Energy Management Software BAS Software Service Parts Control Systems Chillers Mechanical Equipment Competition

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

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

Lynxspring™ Benefits to Trane

• • • JENEsys™ products and related services complement not compete with Trane controls and equipment JENEsys™ enhances Trane’s 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

Section 8 Takeaways

• • • • JENEsys™ adds planks to Trane’s value pyramid Key sales point is the preservation of client’s 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

Questions: Section 8

Section 9 – Legacy Solutions

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

Client Vs. Server Architecture

N2 Integration Examples

CLIENT TYPE SERVER TYPE Ethernet LAN N2 Manager N2 System Bus JENE Manages N2 Devices This is a “Client” Type License N2 System Bus JENE is Managed by N2 Master This is a “Server” Type License Standard Browser PDA/Cell

Driver

BACnet IP Client BACnet MS/TP LON iLON Modbus RTU Modbus TCP M-Bus oBIX Client OPC Client SMS SNMP Z-Wave

Open Client Drivers

Description

BACNet IP Client over Ethernet BACNet MS/TP over RS-232 or RS-485 LON over twisted pair, FTT-10 Port (client and server) iLON over Ethernet (client and server) Modbus RTU over RS-232 or RS-485 Modbus TCP over Ethernet M-bus serial and IP Note1 oBIX Client over Ethernet Note1 OPC Client over Ethernet SMS over Ethernet SNMP over Ethernet Z-Wave via ACT RS232 to wireless interface

Available From

Lynxspring Lynxspring Lynxspring Lynxspring Lynxspring Lynxspring Lynxspring Lynxspring Lynxspring Lynxspring Lynxspring Lynxspring

Price Published ?

Yes Yes Yes Yes Yes Yes No No Yes No No No

Open Server Drivers

Driver

BACnet IP Server Modbus RTU Slave Modbus TCP Slave oBIX Server OPC Server

Description

BACNet IP Server over Ethernet Modbus RTU Slave over RS-232 or RS-485 Modbus TCP Slave over Ethernet oBIX Server over Ethernet Note1 OPC Server over Ethernet Note1

Available From

Lynxspring Lynxspring Lynxspring Lynxspring Lynxspring

Price Published?

Yes Yes Yes No No

Legacy Client Drivers

Driver

AAM PHP AAM PUP Andover AC256 Andover Infinity/Continuum Barber Coleman GCM Barber Coleman GCM Barber Coleman ASD Clipsal Dynalite E-Mon Meters Global Cache Helvar Honeywell C-BUS Honeywell C-BUS Honeywell Security Honeywell Hometronic Horstmann Mainscomm

Description

American Automatix PHP over RS-232 or RS-485 American Automatix PUP over RS-232 or RS-485 Andover AC256 over RS-232 or RS-485 Andover Infinity/Continuum Network 8000 RS232 driver Note2 Network 8000 RS232 driver Note1 Network 8000 ASD RS485 Driver Note1 Cgate Server Driver Dynalite Note2 Class 300, 500, and IDRs Note2 Global Cache over Ethernet Note1 Helvar via RS232 to DALI interface Note1 AX interface to Softyon C-Bus OPC Server OPC interface to Softyon C-Bus OPC Server Vista Note1 Hometronic via RS232 to wireless interface Note1 Hortsmann powerline via RS232 interface module Note1

Available From

Lynxspring Lynxspring Lynxspring Lynxspring Call Lynxspring Lynxspring Lynxspring Call Call Lynxspring Lynxspring Call Call Call Call Call

Price Published?

Yes Yes Yes No No No No No No No No No No No No No No

Legacy Client Drivers

Driver

Johnson Controls Josam Grease Trap Sensor Lang Oven Motion Control Engineering OMRON Resol Siebe, Robertshaw Siemens System 600/Apogee Sonance/IPORT TCS/BASYS Trend Serial Trend Ethernet Ubiwave Veeder Root Wattstopper Miro

Description

N2 Open Josam Grease Trap Sensor Note1 Lang Oven over RS-232 or RS-485 Note1 Motion Control Elevator Controller Interface over Ethernet Note2 FINS Ethernet Protocol Note1 Resol via RS232 port Note1 Microsmart RS-232 to MMI port Note2 IPOD docking station Note1 RS-485 driver Note1 IQ Serial Driver Note1 IQ Ethernet Driver Note1 Ubiwave Note1 VeederRoot over RS-232 or RS-485 Note1 Control of Miro wireless lighting devices Note2

Available From

Lynxspring Call Call Call Lynxspring Call Lynxspring Call Call Call Call Lynxspring Call Lynxspring Call

Price Published?

Yes No No No No No No No No No No No No No No

Driver Notes

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

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

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

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)

Questions: Section 9

Section 10 – Solution Examples

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

Testimonials

Lynxspring products have increased both our controls and equipment business by allowing us to integrate into other people’s systems. This has resulted in both increased equipment and service business. We now are able to talk to customers that we couldn’t 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

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)

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

Arkansas Trane’s Frank Mayfield’s Case Study

Tactic #1: Target Competitive Controls Systems as Service Opportunities

• • • • Use knowledge of competitive controls to expand share of service customers Meet the owner’s need for comfort, reliability, efficiency Start with maintaining the incumbent system Leverage the lament: “It’s not working now and it’s never worked!” |

2008