|
For SLIDRet, a data source consists of both 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 your settings or if no managed connections can be found:
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.
You can also
access the Options window through the application’s menu bar
Tools-Options option.
The Options window has many available settings to help you manage
SLIDRet’s application. Those not covered here will be discussed on
another page.
Here, you can
manage your own connections or have them managed by your SLIDRet Administrator.
If you check the “manage my own connections” checkbox, you now have
control over your connections.
To add a new
connection, you must provide some information:
Name: An identifier of your choice for the connection
Dmms.xml Location: the location of the dmms.xml file. This file is mandatory for
the software to function correctly.
“Has data connection?” checkbox: Check this box if you
have direct connection to SLIDRet’s database server.
The following two fields are only available is you checked the
checkbox.
Data server name: This is the name of the SQL Server you wish to connect to.
Data database name: This is the name of the Database located on the previously
entered SQL Server.
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)
Note: Every time you restart
the software, the previously selected data source is used by default.