The File Menu

The File Menu provides access to the following EMarketOffer features:

Data Sources
Map Settings
Save All Settings
Open EMO Data Directory
Exit

The Data Sources Option

Please read in conjunction with the section on Connecting to a Database Server.

Data Source Concepts

Input data can be sourced from file (see Data Files), or from online database servers.

The Database Connection Configuration

EMarketOffer supports multiple connections to multiple database servers. Database connectivity is managed through the Database Connection Configuration (DCC). A DCC contains a number of queries which obtain data from one or more databases. While a DCC's queries can access data in more than one database on more than one database server, it is not possible to have more than one query handling data of the same type (e.g. only one query can return Price data, and only one query can return Demand data). To overcome this limitation it is possible to define multiple DCCs. Each configuration will define a different, but complete set of data access queries. EMarketOffer can use only one DCC at a time, which together with the data files loaded from the Inputs files directory, fully determine EMarketOffer's run-time data environment.

The Database Connection

A Database Connection is a set of data that describes the addressing, technical and security details required to a specific database on a specific database server. The details are combined in to a specific string format and used to access the required data. A DCC must contain one connection string for every database to be addressed in the configuration.

NOTE: Only one Connection per server is required in DCC. Therefore if all your data is stored in the same database then all queries required to access data can use the same Connection.

Source Data Administration Window

Access

The Data Sources option in the Main Window File Menu.

Purpose

To manage Database Connection Configurations (DCC).

Features

Feature	Purpose
Database Connections Configuration Selector	To set the Current DCC from a drop down box of all currently available DCCs.
Open configuration Button	Opens the DCC Window for the selected configuration
New Configuration Button	Opens the New DCC Window Dialogue
Use Grid File Inputs Check Box	When checked (default) EMarketOffer processes Transmission System files in the Inputs/Grid sub-folder
Grid File Inputs Status Button	Opens the Grid File Inputs Status Window to show which Transmission Systems files are currently being used and any associated loading errors
Refresh All Cached Data Button	Reloads all cached data (from file and database)