1. Perception 5.7 Install Guide
  2. Creating a basic installation
  3. 14. Create the database links

14. Create the database links

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

You will now be asked to create the database links. A database link is required to allow tables and views from one database be used by another. The linking of databases is a direct communication from database server to ETL database server, so if the connection doesn't work, the cause could be a communication problem between these two that doesn't involve the Perception server.

Database links can be configured automatically, Where the configuration application is provided with administrator details for each database server and it runs the necessary procedure, or manually, where you create the links manually on each database server and the configuration application confirms if they are setup correctly.

Please refer to the relevant section for instructions:

SQL Server

Automatically

To automatically link the database servers:

  1. Select Automatically from the Would you like to setup your database links option. You will be shown an entry for each database server used in your installation. So you could have one entry, similar to below, or you could have several entries. For each entry the Databases on the Server section will identify which database(s) can be found on the server identified in the Database Server Name.
  2. When creating the links to the server, you will need to login as an administrator. Select how you connect to the database 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 that you should use the fully-qualified domain name: <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. Repeat the above steps for each database entry and click Create.

Now you can continue on to step 15 using the link below to finish installing Perception.

Manually

For instructions about setting up you database links manually, please refer to the following before completing the steps below:

To manually link the database servers:

  1. Select Manual from the Would you like to setup your database links option.
  2. Click Verify to check the linking is successful.

Now you can continue on to step 15 using the link below to finish installing Perception.