Database Linker

Connect to a Microsoft SQL Server Database and show a dataset from the database in a map.

After installing this addin creates a new Task pane called “Database Linker”. Currently it is working only with Microsoft SQL Server. You need to specify the server manually. After selecting a valid server you can choose a database and a table of this server. This table needs to have an index (primary key) All results (first column of each dataset) of this Table will be shown in the Result window. You can increase the number of shown columns by clicking on the arrows. By selecting a result all columns of the dataset will be shown in the Detail Results window. There you can check the columns which will be shown in the short view of a Business Topic. With drag & drop you can move the result (in the Result window) into the Map, a new Business Topic will be created. If you edit the business topic this will be updated in the database. Also you can refresh the data by clicking the refresh button.

You can simply install the MSDE and the Northwind example database on your PC to test it. If you got an local MSSQL-Server you need to write "(local)\servername" in the "Server" field of the Database Linker and press OK.

• 4/7/2006 Updated to work with Primary Interop Assembly