Using an existing database as a sample database
UNICOM Intelligence Interviewer - Server expects the sample table to be part of an SQL database. If you have an existing database of a different type (Oracle, for example) that contains the records you want to use as the sample for a project, you can often read the data directly from that database rather than having to export it and then load it into UNICOM Intelligence Interviewer - Server.
The procedure describes how to create a link from a external database into UNICOM Intelligence Interviewer - Server, while at the same time limiting the information in the external database that can be accessed by UNICOM Intelligence Interviewer - Server activities.
1 Open SQL Server and do the following:
Create a linked server that links to your external database. (Linked servers run against OLE DB data sources and the OLE DB provider for non-SQL databases runs over SQL*NET.)
Create a table that contains the sample fields that UNICOM Intelligence Interviewer - Server requires (Active, Id, Queue, Serial, and Test for Web projects, for example) and the foreign key to the sample table in your external database.
Create a view that joins the SQL Server table with the table in the external database. For information about how to create distributed queries by using linked servers, see the SQL Server documentation.
2 Activate the project as normal, selecting the new view as the sample table.
3 In DPM Explorer, go to Site > Servers > ServerName > SampleManagements > ProjectName> Queueing > Queues > Properties, and then add a property called ReadOnlyFieldColumns. Make its value a comma-separated list of the column names in the external database that should not be updated by the sample management system.
See also