SLID Systems

SLIDRet 4.0

 

 

Main page

What is a data source in the SLIDRet application?

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.

 

How do I add a data source to SLIDRet 4.0?

 

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.