LINK bookmark

Link of the selected map objects and records of an open database can be of three types:

1. No link (values from semantics).

Link of objects with the table is not implemented, the information is taken from semantics of the selected objects.

2. Internal link (by LINKOBJECT table field).

In case the thematic map will be constructed only under the information of the table, it is necessary to choose a name of the table of a database.

Link of objects with the table is implemented by internal links of the table. Semantics of the selected objects does not participate in the link.

3. Conditional link (a field of the table <-> semantics of objects).

Link of objects with the table is implemented by way of identification of value of semantics, chosen from the list of semantics of selected objects, and a field of the table, chosen of the list of the link fields. The list of semantics of the selected objects is formed automatically according to type of a link field of the table. If the current link field of the table has numerical type - in the list of semantics only semantics with numerical type will be. If the current link field of the table has character type - in the list of semantics only character semantics will be.

For databases Dbase, specify the source of data - «dbf file». «Table» field should contain a full path to a database file for which choice it is possible to use the button of calling the dialog for a file choice.

For databases of MS SQL Server, PostgreSQL, specify the source of data - "database".

For connection to database of MS SQL Server the dialog of "Property of a data link» is called:

Dialog box of Properties of a data link:

The bookmark «Data Provider» is used for a choice of OLE DB provider. The list contains all detected on disk OLE DB providers, we choose Microsoft OLE DB Provider for SQL Server. We press the button Next>> and we are switched to the bookmark "Connection" (there is an opportunity to immediately go to the bookmark "Connection" by double-clicking the provider name).

Dialog box of Properties of data link - Connection bookmark:

The bookmark «Connection» allows to customize connection parameters. Fill with values the fields containing the server name, the user name, the password, set the flag of permission to save the password and choose a database on the server.

By pressing the button Check connection, we check connection with the specified source. After successful check of connection we press the button Ok.

Further we choose the table from the Table drop-down list.

For connection to PostgreSQL database it is necessary to create preliminarily a data source by use of the ODBC-administrator. The executable file odbcad32.exe is located in the directory \Windows\System32\odbcad32.exe in 32-bit Windows operating system. In 64-bit operating system -\Windows\SysWOW64\odbcad32.exe.

To start the ODBC administrator (Control Panel -> Administrative tools-> ODBC Data Sources).

To activate the bookmark of System DSN, press button «Add».

The ODBC data source administrator:

To select the driver - PostgresSQL Unicode and press the «Finish» button.

Creating new data source:

Setup of properties of a new data source:

Fill in the fields:

- Data Source - a name of data source (for example, ds_thematic_postgresql);

- Database - a database (for example, thematic_postgresql);

- Server - IP address of the server computer;

- Username - the user name;

- Password - the password which will be used to connect to the database (on the server with PostgreSQL the user with such name and the password should be preliminarily created).

To test the connection to the database by pressing the «Test» button. Upon successful testing to complete the creation of the data source by clicking the «Save» button.

Further in the dialog «Building thematic cartograms» for connection to database of MS SQL Server the dialog of "Properties of a data link» is called (the button located to the right of the field the DB Tables):

Dialog box of Properties of a data link:

The bookmark «Data Provider» is used for a choice of OLE DB provider. The list contains all detected on disk OLE DB providers, we choose Microsoft OLE DB Provider for ODBC Drivers. We press the button Next>> and we are switched to the bookmark "Connection" (there is an opportunity to immediately go to the bookmark "Connection" by double-clicking the provider name).

Dialog box of Properties of data link - Connection bookmark:

Fill with values the fields containing the data source name, the user name, the password, set the flag of the permission to save the password and specify the source catalog.

By pressing the button Check connection, we check connection with the specified source. After successful check of connection we press the button Ok.

Further we choose the table from the Table drop-down list.