Desktop User Guides > Professional > Interview scripting > Sample management > Sample management facilities > Sample table > Using an existing database as a sample database
 
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. Refer to the SQL Server documentation for how to create distributed queries via linked servers.
2 Activate the project as normal, selecting the new view as the sample table.
3 In DPM Explorer, navigate to Site > Servers > ServerName > SampleManagements > ProjectName> Queueing > Queues > Properties and 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
Sample table