Connect to a Microsoft SQL Server Database and show a dataset from the database in a map.
Version 1.2.0 (12/5/2006)
How It Works
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.
Requirements
You can 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.
Customizing the Database Connection String
The default database connection string for connecting to databases is
- server={0}; integrated security=true;
where {0} is replaced with the server name. If the database that you want to connect to needs different security, you can modify the connection string by adding a string value named ConnectionFormat to a new registry entry:
- HKEY_CURRENT_USER\Software\Mindjet Labs\Database Linker
So, for example if you need to specify a user ID and password, this would be the value for ConnectionFormat:
- Persist Security Info=False; User ID=*****; Password=*****; Initial Catalog=AdventureWorks; Server={0}
Important: The database linker is a solution demonstration only and storing a password in a registry entry is not a secure practice. If you want to use the Database Linker for an enterprise solution, you should adapt the code to use a more secure authentication mechanism.
Revision History
- 12/4/2006 Updated installer to work on Windows Vista
- 10/31/2006 Updated to work with .Net Framework 2.0.
Added registry entry for connection string.
Signed installer. - 4/7/2006 Updated to work with Primary Interop Assembly