Installing QAD BI
This chapter describes how to install QAD BI. It discusses the following topics:
Pre-Install Information
To save time during the installation, record the following customer’s information in advance:
Installation Packages
There are two installation packages for Progress Open Edge for Windows: one is for 64-bit, one for 32-bit.
Currently, you must install the 32-bit version; do not install the 64-bit version. Even if you have a 64-bit server, you must install the 32-bit package to get the 32-bit ODBC drivers. QAD’s understanding of the Progress Open Edge knowledge base is that you cannot install both on the same server. For instance, do not install the 64-bit package on your 64-bit server and then install the 32-bit ODBC drivers. Install the 32-bit Open Edge package only.
Important: The Progress Source database or databases must be running Progress version 10.1B03 or later.
Note: If the installation requires that the DWD is on a different server than the database server, contact QAD customer support to obtain documentation.
SQL Server Notes
• Configure the SQL Server for both SQL Server and Windows authentication.
• Set the Recovery Model for the Data Warehouse databases to Simple.
• Evaluate the default autogrowth settings for the data warehouse database. If the database is handling large quantities of data, increase the settings from the defaults.
• Ensure that there is plenty of space for tempdb. When the Data Warehouse processes large amounts of data, it sometimes uses a lot of space in tempdb for calculations. If necessary, move the tempdb data and log files to a larger drive.
• As with any database product, always create an appropriate database backup and restore plan.
Requirements
• Tomcat 5.5, 6, or 7 installed and configured.
Note: Tomcat’s Java Maximum memory pool should be set to a minimum of 1024 MB RAM. If multiple Web applications are running, or if you are installing dashboards for multiple modules, you may need to increase Java memory to up to 2048 MB RAM.
• Java 1.5 JRE or higher.
• Java 6 JDK or higher.
• SQL Server 2008 or 2012 installed and configured. SQL Server 2005 is acceptable, but not recommended due to poor performance.
• SQL Server has TCP enabled, to connect via JDBC.
Note: End users need Adobe Flash Player installed for their browsers.
Configuration Parameters
The following configuration parameters are required during installation. Write them down before you start:
• Tomcat Port. The port in which Tomcat is running; for example, 80 or 8080.
• SQL Server JDBC URL. The URL required to connect to the SQL Server database (host name, port number, and database name).
• QAD BI Data Warehouse Designer user / pwd. The User name and password to connect to the SQL Server Database where QAD BI DWD is running.
Note: This user must have “dbo” (owner) privileges to be able to create the necessary data model security on the Data Warehouse database.
• BI Portal database User / pwd. The user name and password to connect to the SQL Server database where BI Portal repository is installed.