12. Create the temporary ETL (ETL_temp) database

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

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

      1. Enter the database server name of your ETL server, which is where your ETL service is installed
      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. Please ensure you do not use illegal characters when naming your temporary ETL database. For more information, please refer to A4. 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 13 using the link below.

    • Oracle 11g
      1. Enter the name of your ETL server (it must be entered in uppercase form in the Enter database server name: text-box), which is where the ETL service is installed
      2. Add the Oracle System ID (SID) for your ETL server (it must be entered in uppercase form) and ensure the Port used to connnect is correct
      3. Enter a Username and Password for an Oracle user who has permission to create users, Tablespaces, and assign roles. For example, the username might be SYSTEM.
      4. Determine how this user should connect to the Oracle instance in the This user should connect as drop-down list. For example, SysDba.
      5. Enter a name for the User and Tablespace you want to create. For example, the user might be named Perception_ETL_Temp.
      6. Set a password or use an auto-generated one
      7. Click Create. Once complete, you should be presented with a screen similar to the following:

      Please note that it is important to ensure that all tnsnames.ora files need to be aware of all Oracle connections in order for database links to function. All tnsnames.ora files need to be identical and point to the same Oracle instances.

      Now you can continue on to step 13 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:

A1. 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

    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, which is where your ETL service in installed. 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 13 using the link below.

  • Oracle 11g
    1. In the configuration application, select Manual from the How do you want to create the databases? section
    2. Select Oracle from the Choose database type drop-down list
    3. Enter the Database server name where you created the ETL_Temp schemas (note that this will be your Perception server in this single-server installation)
    4. Enter the Sytem ID (SID) for the Oracle server and make sure the Port number used to connect is correct for your database
    5. Enter the User and Tablespace and Password details for the ETL_Temp database you manually created
    6. Click Create. Once complete, you should be presented with a screen similar to the following:

      Please note that it is important to ensure that all tnsnames.ora files need to be aware of all Oracle connections in order for database links to function. All tnsnames.ora files need to be identical and point to the same Oracle instances.

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