In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   Cloud ERP  |   Home  |   qad.com




Installation of QAD BI Analytical Modules
This topic includes installation and configuration steps for the following QAD Business Intelligence analytical modules:
 
Financials
Enterprise Asset Management
Order Management
Transportation Management
Operations
 
Requirements
QAD BI DWD (version 6.6.2 or later), Data Warehouse installed and Scheduler running.
QAD Business Intelligence Metadata installation files, in the form of QAD BI DWD application files.
Note: This consists of one set of application files for each analytical module to be installed, plus the Common set of application files.
Installation Steps
Follow these steps to install the QAD Business Intelligence metadata modules.
The previous installation task created the System ODBC connections to the QAD Progress databases. Now, for each one of these ODBC connections, in the QAD BI DWD in the Browser pane, create a Connection object for each:
1
Right-click Connection in the QAD BI DWD Metadata Browser and choose New Object.
2
Enter a short descriptive name for the data source; for example, QAD_MAIN, QAD_US, QAD_EMEA, or QAD_ASIA. Click OK;
3
Select a Connection Type of ODBC and select the ODBC connection.
4
Enter a work directory. This directory must be different for each QAD Data Source. Create this directory in the file system. You will create a matching directory in step 6.
5
Enter the Extract user ID and password required for the Progress database. This user must have read permission for the QAD tables.
6
Using Windows Explorer, create a directory to match the directory you entered as the Work Directory for the connection you just set up.
7
Repeat all steps for each data source.

Object Connection Definition