Communication between the Workspace Designer and the company information is through models and data source connection strings.
Usually there is one modelModels are data schemas that describe how the information held in a particular database can be accessed and displayed within Sage 200. Each model is contained in its own dynamic link library (dll). for each Sage 200 data sourceThe origin of the information being included in the Sage 200 suite. This includes the location of the information on the server.. Each model is contained in its own DLL file. Models are data schemas that describe how the information held in a particular data source can be accessed and displayed within the installation. Models are installed on the Sage 200 client.
Data source connection strings are access keys to model information. They contain information such as the serverThe server is the computer running the Sage 200 Server software. The server provides information over the network to computers running the Sage 200 Client software. the company information is held on and the password required to look at the company information.
You get the information you need to put into the workspaces you are designing by querying models within the Workspace Designer.
The model translates your queries into SQLStructured Query Language (SQL) is used for querying the databases used by the Sage 200 suite. code. This code is passed through the data source connection string into the relevant company.
This code searches for the information needed to fulfil the queries and this is returned back through the connection string, by the model to the Workspace Designer.
For example, in Sage 200 Accounts, a query on company 1 information is made via the Sage 200 Accounts model via the Accounts data source connection string 1.
Results from the query are used in the Workspace Designer.
Tip: For the most recent version of this topic, please see our help website here.