Make sure that you have access to all the DB sources that you will use in WITNESS Miner.
Create a data source node. Double-click on it to display the data source options dialog.
In the text file section, select the database via OLE DB option.
In the records section, choose whether to load all of the records available from the database, or to sample a specified number of records whilst the file is being loaded. The sample method is more efficient than loading the whole database (which might not be possible due to memory limitations) and then sampling the records.
In the database options section, enter the database connection string, which specifies the data source, provider, security and so on. Click on the build button to invoke the data links wizard, which helps you to build the connection string.
Specify an SQL query string or table name that WITNESS Miner will use to build the record set. If an entity name contains spaces, you must enclose the name in square brackets.
For example, this SQL query string selects the Software and Response fields from the Customer Response file to build the database:
SELECT Software, Response FROM [Customer Response]
For example, this table name uses all the fields in the Customer Response file to build the database:
[Customer Response]
If you wish to load date fields as continuous numeric values (doubles) rather than text strings, check the load dates as continuous numeric values box. This means that you can sort the database easily by date fields.
The remaining fields do not apply if you are loading an OLE-DB. Close the data source options dialog.
Create a view node, link it to the data source, then run the view node.
The database is displayed in the data view window.