Français Index

SLID Systems

SLIDRet 4.0

ADDING NEW CONNECTIONS

What is a data source in the SLIDRet application?

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.

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 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.