13. Create the temporary ETL (ETL_Temp) database | Questionmark

13. 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 (the ETL_Temp database is created for you, using the credentials you provide)

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 2008 R2

      1. Enter the database server name of your ETL server
      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 2008, you will typically use the sa user.
      3. Enter a Database Name for the temporary ETL database. Ensure you do not use illegal characters when creating your database. For more information, please refer to A1. 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 14 using the link below.

Manual (you create the database manually, and then provide the details to the configuration application)

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:

ADV12. Create the databases manually

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

  • SQL Server 2008 R2

    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 your ETL server. 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>
    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 14 using the link below.