EMO:Connecting to a Database Server

WARNING: Connecting to a local or networked database server is complex and can be time-consuming. If no people in your company have previous experience of configuring EMarketOffer it is strongly recommended that you consult your company's technical support and also the Energy Link helpdesk for advice on the best approach.

---

Terminology

EMarketOffer's data design consists of 'things' included in the model, and their characteristics'. In this manual the 'things' are called Entities and their characteristics are called Traits. Traits may be static or dynamic.

For example the Circuit Entity can have the static Traits of Start Node and End Node, and the dynamic Traits of Powerflow and Loss by Trading Period.

Input Data Types

EMarketOffer can load the folowing types of Input data directly from external databases.

Entity	Type	Trait	Mandatory	Defined by
Node	Demand (Load)	Node.Load	No	Date, TP, Node, Load
	Price	Node.Price	No	Date, TP, Node, Load
Unit	Unit Node (Links Units to Nodes)	Unit.Node	Yes	Unit, Node
	Generator Unit (Links Units to Generators)	Unit.Generator	Yes	Unit, Generator (Generators are always three alpha codes e.g. HLY = Huntly
	Unit Generation	Unit.Generation	No	Date, TP, Unit, Generation
	Unit Offer Quantity	Unit.OfferQn (where n = band)	No	Date, TP, Unit, OfferQn
	Unit Offer Price	Unit.OfferPn (Where n = band)	No	Date, TP, Unit, OfferPn
Circuit	Circuit	Circuit.Name	Yes	Date, TP, Name
	Node From	Circuit.NodeFrom	Yes	Date, TP, Circuit, NodeFrom
	Node To	Circuit.NodeTo	Yes	Date, TP, Circuit, NodeTo
	Reactance	Circuit.Reactance	Yes	Date, TP, Circuit, Reactance
	Resistance	Circuit.Resistance	Yes	Date, TP, Circuit, Resistance
	Fixed Losses	Circuit.FixedLosses	Yes	Date, TP, Circuit, FixedLosses
	Capacity	Circuit.Capacity	Conditional	Date, TP, Circuit, Capacity
	Winter Capacity	Circuit.WinterCapacity	Conditional	Date, TP, Circuit, WinterCapacity
	Summer Capacity	Circuit.SummerCapacity	Conditional	Date, TP, Circuit, SummerCapacity
Equation	Formula	Equation.Formula	Yes	Date, TP, Equation, Formula
	Limit	Equation.Limit	Yes	Date, TP, Equation, Limit
	Type	Equation.EquationType	No	Date, TP, Equation, EquationType
	Season	Equation.Season	No	Date, TP, Equation, Season
	Active	Equation.Active	No	Date, TP, Equation, Active

---

Note:

1. Mandatory Traits are the minimum required for EMarketOffer to operate
2. Either a single Circuit capacity OR two seasonal Circuit Capacities are mandatorily required

---

Input Data Structure

EMarketOffer requires input data to generate the Market Data Source for viewing historical market conditions and to create the Forecast Definitions used to generate detailed market Forecasts. Input data can be retrieved from external databases using standard SQL queries, which can be grouped together into Database Connection Configurations.

---

NOTE: Only one Database Connection Configuration can be in use at any one time. This "current" configuration tells EMarketOffer where to find the input data for the Market Data Source and for loading data into Forecast Definitions. The most recently used configuration is opened automatically as the default configuration on startup. The Data Sources Option in the Main Window File Menu can be used to make an alternative configuration current.