4. Install a database system to handle the ETL_Temp database | Questionmark

4. Install a database system to handle the ETL_Temp database

Applies to the following products: 
Questionmark Perception
Applies to the following Perception versions: 
Perception 5.7

Your ETL server needs to have the following prerequisites installed (apart from a database system):

You can install .NET 4.0 manually or automatically, using the appropriate Web Platform Installer link below. IIS must be installed manually.

A database system for the ETL_Temp database needs to be installed on your ETL server.

A database is needed on the same server where the ETL service is installed to hold result data while it is being readied for the Results Warehouse. Because your Extract, Transform, and Load service is on a different server from the database, it becomes more efficient to ETL the data to a local database and then move it to the destination database in the correct format. This is illustrated in the diagram below:

For instructions on how to install SQL Server, please refer to its accompanying documentation. Once you have installed it, follow the steps below to configure SQL Server for use with Perception.

SQL Server

Make sure that the SQL Server authentication mode is set to Mixed Mode (SQL Server authentication and Windows authentication).

Enable TCP/IP

The following network options that are disabled by default will need to be enabled.

  1. Open SQL Server Configuration Manager.
  2. Expand SQL Server Network Configuration, and select Protocols.
  3. Enable TCP/IP and Named Pipes.
  4. Close the SQL Server Configuration Manager.

Start SQL Browser

  1. Open SQL Server Configuration Manager.
  2. Click SQL Server Services in the left-hand pane, or double-click SQL Server Services in the right-hand pane.
  3. Start SQL Server Browser.

Add Firewall exceptions

If you have a software firewall installed on your server, you will need to add exceptions for the SQL Server and SQL Browser services. If you are using Windows Firewall, do the following:

  1. From the Start menu, navigate to Control Panel | System and SecurityWindows Firewall.
  2. Click Allow an app through Windows Firewall.
  3. Click Change settings
  4. Click Allow another app....
  5. Click Browse... and then navigate to and select C:\Program Files\Microsoft SQL Server\MSSQLxx.<instance_name>\MSSQL\Binn\sqlserver.exe or C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.<instance_name>\MSSQL\Binn\sqlservr.exe if you installed the 32-bit version of SQL Server on a 64-bit operating system (the folder locations may be slightly different for your installation).
  6. Click OK.
  7. Click Add.
  8. Click Browse... and then navigate to and select C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe or C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe.
  9. Click OK and then click OK again.

If you're using a third-party software firewall, you will need to follow their instructions to add exceptions for sqlservr.exe and sqlbrowser.exe.

If you're using a software firewall, you'll need to add exceptions for SQL Server and make sure it allows communication on TCP/IP ports.

After you have configured SQL Server, continue to step 5 using the link below.