2j. Create the temporary ETL (ETL_Temp) database | Questionmark

2j. Create the temporary ETL (ETL_Temp) database

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

Now you need to create the temporary ETL (ETL_Temp) database using the configuration application.

The configuration application can create the ETL_Temp database for you automatically, or you can create it manually.

Please choose your preferred method below.

Automatic creation

To create the ETL_Temp database automatically:

  1. Select Automatic.
  2. Select the database type you are installing Perception on from the Choose database type drop-down list.

  3. Refer to the relevant section depending on your database type.

SQL Server

  1. Enter the database server name of the server on which you want to create the ETL_Temp database.

    The configuration application states that the ETL_Temp database must be installed on the same server on which the ETL service is installed, but this is no longer the case, and this message can be ignored.

  2. Select how you connect to the database on your ETL server using the I connect using drop-down list. If you login using:
    • Windows authentication, you will need to enter the Windows username and password associated with the system administrator for the database server. If you are using a domain server, remember you should use the fully qualified <domain>\<username>. For example, myorganization\dbsysadmin.
    • SQL Server authentication, you will need to enter the database system administrator and password. For example, on SQL Server, you will typically use the sa user.
  3. Enter a Database Name for the temporary ETL database. Please ensure you do not use illegal characters when naming your temporary ETL database. For more information, please refer to Illegal characters.
  4. Set a password or use an auto-generated one.
  5. Click Create. Once complete, you should be presented with a screen similar to the following:

Now you can continue on to step 2k using the link below.

Manual creation

To manually create the ETL_Temp database, you will need to create the database first. For instructions on doing so, please refer to the following section:

After you have created the temporary ETL database, refer to the relevant section depending on your database type.

SQL Server

  1. In the configuration application, select Manual from the How do you want to create the databases? section.
  2. Select SQL Server from the Choose database type drop-down list.
  3. Enter the address of the server on which you want to create the ETL_Temp database. Enter the fully-qualified name in the format <servername>.<domain>, e.g., db2008.myorganization.local. You may also use an IP address or just the server name if the server is not part of a domain. Do not use (local) or localhost. Remember to include the instance name where necessary: <servername>\<instancename>.

    The configuration application states that the ETL_Temp database must be installed on the same server on which the ETL service is installed, but this is no longer the case, and this message can be ignored.

  4. Enter the name of the temporary ETL database you created before.
  5. Click Create. Once complete you should be presented with a screen similar to the following:

Now you can continue on to step 2k using the link below.