Ad Hoc Report Tool Requirements

Topics

System Requirements

Use either Windows Server 2012 or 2016 to host the ad hoc report server. The server must meet these system requirements before you can proceed with the installation.

  • If you use Windows Server 2012, install Microsoft Internet Information Server (IIS) 7.x with the default roles and role services, or 8.x with all the roles and role services shown here.



  • If you use Windows Server 2016, install Microsoft Internet Information Server (IIS) 8.x with the above roles and role services.

  • Microsoft .NET framework 4.6 or 4.7.1.

  • If you have an Oracle database:

    • Ensure that Oracle database version is 11g or higher.

    • The TNS name of the Oracle database host must be the server IP address, not the server name.

    • Ensure that you have added the read & execute permission to the %ORACLE_HOME% folder and sub-folders for authenticated users. If you are adding the permission now, remember to restart the server.

Server Domain Name Requirement

Due to Internet Explorer limitation on cross domain access, you must configure the domain names of the ad hoc report server and the Civic Platform web server with identical hierarchical levels, for Civic Platform to successfully access the report server.

Specifically, if the domain name of the Civic Platform web server has 3 hierarchical levels, the domain name of the ad hoc report server must have 3 hierarchical levels as well. For example, if the web server domain name is test-site.accela.com, the ad-hoc report server domain name can be ad-hoc.accela.com, and cannot be ad-hoc.com.