Configuring the insert scripts

Eight provided batch files load data files into the database.

In the above directory, you must edit bcp_load_data_files8x.bat and set the following variables if needed:


set BULKDIR=C:\Discover\DataExtractor\DataFiles
set SCRIPTDIR=C:\Discover\DataExtractor\Scripts
set DBSERVER=localhost
set DATABASE=TLWEB.dbo
Variable
Description
BULKDIR
The directory on the local server where the generated data files are outputted.
SCRIPTDIR
The directory where the scripts are located. If the script files were not moved, this value should be set to the DataExtractor\Scripts folder inside the Discover installation directory.
DBSERVER
The host name of the server where the database is stored.
DATABASE
The name of the database.

Configuring load scripts to use SQL authentication

To use SQL authentication with the BCP load scripts, you must set the BCPOPTIONS variable for several script files.

For example, if the set BCPOPTIONS declaration is the following in your script files:


set BCPOPTIONS=-F 2 -b 250000 -m 50 -a 32000 -T

It must be changed to the following:


set BCPOPTIONS=-F 2 -b 250000 -m 50 -a 32000 -U login_id -P password

Where:

Parameter
Description
-U login_id
Login ID used to connect to SQL Server.
Note: When the bcp utility is connecting to SQL Server with a trusted connection using integrated security, use the -T option (trusted connection) instead of the user name and password combination.
-P password
Password for the login ID.
  • If this option is not used, the bcp command prompts for a password.
  • If this option is used at the end of the command prompt without a password, bcp uses the default password (NULL).

In the <Discover_install_directory>\dataextractor\scripts directory, the following files must be updated with the above command:


bcp_bulkappdate8x.bat
bcp_bulkattribute8x.bat
bcp_bulkcookie8x.bat
bcp_bulkevent8x.bat
bcp_bulkhit8x.bat
bcp_bulksesn8x.bat
bcp_bulkurlfield8x.bat