EMO:Connecting to a Database Server - Revision history

Greg at 01:08, 7 February 2014

2014-02-07T01:08:34Z

2014-02-07T01:08:17Z

2014-02-07T01:07:39Z

Creating a Database Connectivity Configuration

2013-02-08T00:50:06Z

Creating a Database Connectivity Configuration

2013-02-08T00:49:38Z

Input Data Handling Mechanism

2013-02-08T00:47:27Z

Input Data Handling Mechanism

2013-01-31T01:18:26Z

Input Data Handling Mechanism

2013-01-31T01:17:05Z

Input Data Handling Mechanism

2013-01-31T01:10:32Z

Input Data Structure

2013-01-31T01:09:35Z

Input Data Structure

@@ Line 1: / Line 1: @@
 {{#hidens:}}
-'''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 [[Help:COntents|helpdesk]] for advice on the best approach.
+'''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 [[Help:Contents|helpdesk]] for advice on the best approach.
 ----

@@ Line 1: / Line 1: @@
 {{#hidens:}}
-'''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.
+'''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 [[Help:COntents|helpdesk]] for advice on the best approach.
 ----

← Older revision		Revision as of 01:07, 7 February 2014
Line 261:		Line 261:


−	[[~~EMO:Getting Started\|Back]] - [[EMO:EMarketOffer User Manual~~\|Home]]	+	[[Main Page\|Home]]

@@ Line 258: / Line 258: @@
 ===Creating a Database Connectivity Configuration===
-The functions used in Configuration setup are fully described in the [[EMO:Menu Bar|Menu Bar]] segment under the [[EMO:The Main Window|Main Window]] section.
+The functions used in Configuration setup are fully described in the '''''[[EMO:Menu Bar|Menu Bar]]''''' segment under the '''''[[EMO:The Main Window|Main Window]]''''' section.
 [[EMO:Getting Started|Back]] - [[EMO:EMarketOffer User Manual|Home]]

@@ Line 243: / Line 243: @@
 *A Data Source Name (DSN) file containing the above information
-See the section on '''''[[EMO:Control_Panel_Components#The_Data_Source_Manager|Data Sources Options]]''''' for more information on Connection Strings.
+See the section on '''''[[EMO:Securing Database Access|Securing Database Access]]''''' for more information on Connection Strings.
 A separate query is used for each data item to be imported. Each query must be associated with a Connection and contain a standard SQL-compliant query string defining the specific data to be returned.  Query strings should:

@@ Line 237: / Line 237: @@
 A Configuration contains a collection of queries that may reference more than one online database. Each query can reference a single database using a pre-defined Connection containing the information required to interact with a database server; once defined a Connection can be used repeatedly by the queries in a Configuration.
-The main component of a Connection is the Connection String which EMarketOffer uses to locate and connect to online database servers.  The string varies in format depending on the target database server type and its specific access security provisions.  It may contain:
+The main component of a Connection is the Connection String which ''EMarketOffer'' uses to locate and connect to online database servers.  The string varies in format depending on the target database server type and its specific access security provisions.  It may contain:
 *A data provider: this specifies the type of database server to be accessed (e.g. Oracle or MS SQL) and the specific access protocol to be used (e.g. OleDB or ODBC)
 *Name of the database to be accessed (if required)

@@ Line 232: / Line 232: @@
 ''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 '''''[[EMO:Forecasting|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.
+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 '''''[[EMO:The_File_Menu|Main Window File Menu]]''''' can be used to make an alternative configuration current.
 ===Input Data Handling Mechanism===

@@ Line 230: / Line 230: @@
 ===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.'''''
+''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 '''''[[EMO:Forecasting|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.