|
For SLIDRet, a data source is your link to SLID’s
data (SQL server) and Data Dictionary (XML document).
SLIDRet’s data dictionary is required for the user interface
and for SQL generation dynamically creating SQL statements on SLID’s
Data.
SLID’s data is required to execute the SQL statements and
retrieving the results. It is important to note that the application will work
without any link to SLID’s data (to browse variables for example) but
will not give you any data in the results file.
You should get
this informational message box when starting SLIDRet if no data sources are
present in the settings.:
If you select yes, the software will automatically
open the Options window.
If you select
No, you will be returned to SLIDRet’s main window. Please note that you
will have to return to the Options window to add a data source before using the
software.
The Options window has many available settings to help you manage
SLIDRet’s application. They will be discussed on another page.
To add a data source,
fill in the required information under the Add data source group box.
Current data
source for 2006:
Name: what you
can associate with the data source. Ex: RY2006_Final
Dmms_2006.xml
location: \\lhs5\inc\APEX\Programs\Applications\SLIDRet\DMMS\dmms_2006.xml
Has data
connection? : Checked
Server name:
F8ISDSQLDEV
Database name:
ISD_SLID_PROC_DATA
Click the Add button to add
the connection.
There should
now be an entry in the Current data sources view.
Click the
“Save and close” button to return to SLIDRet’s main window.
Select the
previously create Data Source using the combo box on the toolbar. Note that the
Name of your connection is displayed in this list.
You will know
the process works when the titles become blue (Type of analysis, Analysis
Unit and Reference years)
After that you
are ready to go and create your first query. Please see this tutorial (under construction) if you want to
learn how to create a new query!
Note: Every time you restart
the software, the previously selected data source is used by default.