9. Create an ODBC connection to your shared repository database

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

Now, you need to create an ODBC data source to link Perception to the shared repository database you created in step 6 so that the Shared Repository Service can correctly use it.

The ODBC connection needs to be created on the same server on which you plan to install Perception.

If you are using a 64-bit version of Windows (for example, Windows Server 2008 R2), you will need to use the 32-bit version of ODBC drivers.

The sections below provide details about creating the ODBC connections for the following database systems:

SQL Server 2008

To create an ODBC data source:

  1. Open the ODBC Data Source Administrator on the same server on which you plan to install Perception as an administrative user.

    To do so on a:

    • 32-bit operating system, go to Control Panel, double-click Administrative Tools, and then double-click Data Sources (ODBC)
    • 64-bit operating system, such as Windows Server 2008 R2, navigate to and launch the following ODBC driver:

      C:\Windows\SysWOW64\odbcad32.exe

  2. Open the System DSN tab
  3. Click Add...
  4. Select the SQL Server driver for your SQL Server instance and click Finish
  5. Enter a name for the new data source, and select the server you want to connect to (that is, the machine on which your database is installed, i.e., your database server) from the drop-down list. Make sure that you enter the actual server name and not "(local)" or "localhost."
  6. Click Next
  7. Ensure that With SQL Server authentication using a login ID and password entered by the user is selected

  8. Enter the ID and password of the login you created for the Perception database (in step 8) and click Next

  9. Enable the Change the default database to check-box and select your Perception database (i.e., Perception_REPO) from the drop-down list and click Next

  10. Click Finish. Review the details of the new ODBC data source that will be created and click OK.

    You can click Test Data Source to check the connection.

  11. Click OK to close the ODBC Data Source Administrator

You can now begin to install Perception. Follow the link at the bottom of this page to continue to step 10.

Oracle 11g

Once you have created your shared repository database (Perception_REPO), you will need to create a data source. This should be done on the same server on which you plan to install Perceptioin, not your database server.

To do so:

  1. Open the ODBC Data Source Administrator on the same server on which you plan to install Perception as an administrative user.

    To do so on a:

    • 32-bit operating system, go to Control Panel, double-click Administrative Tools, and then double-click Data Sources (ODBC)
    • 64-bit operating system, navigate to and launch the following ODBC driver:

      C:\Windows\SysWOW64\odbcad32.exe

  2. Open the System DSN tab
  3. Click Add...
  4. Select the 32-bit Oracle driver that corresponds to your Oracle installation from the list and click OK

  5. Enter a name and description for the new data source in the appropriate text-boxes
  6. Specify in the TNS Service Name text-box the Net Service Name of the server you want to connect to (that is, the machine on which your database is installed, i.e., your database server). This is the Net Service Name you specified in step 8.
  7. Enter the name of the database user you have created in the User ID text-box. For example, Perception_REPO.
  8. Click OK, and OK again to close the ODBC Data Source Administrator

You can now begin to install Perception. Follow the link at the bottom of this page to continue to step 10.