2l. Creating database links

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

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 process of linking up the databases is different for Oracle and SQL 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 click on the relevant section below to expand its 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 2008 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 14 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:

A2. Manually link the databases

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 14 using the link below to finish installing Perception.

Oracle

Automatically

To automatically link the database servers:

  1. Select Automatically from the Would you like to setup your database links option buttons
  2. Enter your database administrator username and password
  3. Click Create

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

A2. Manually link the databases

To manually link the database servers:

  1. Select Manually 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 2m using the link below to finish installing Perception.