June 22, 2010
Once ERS is installed, and the ERS limit for initial data import set (see important note below), configuring client iPrism units to upload data to ERS is simple. Go to Reports > Preferences and select ERS. This will enable the ERS Server: field. Type the DNS name (e.g., iprism-ers.mycompany.com) or IP address of the ERS server. This will provide data transfer services between iPrism and ERS.
Important: Note that you control the amount of data to be uploaded/converted from each iPrism by configuring an ERS Settings parameter. Once ERS is installed and you have logged in, go to Reports Manager > Settings, and check the Limit for initial import from iPrism. This controls the default number of days of data to import (typically 90). The default of 90 days can result in as many as 120 million records being uploaded/converted for each iPrism. If you wish to reduce or eliminate the time needed for the initial upload/conversion, click Modify and select a smaller value (down to 0 days).
If you need to ensure that you will see ALL of the iPrism report history in ERS, you may want to examine the Oldest Record (see below) on each iPrism to determine the appropriate number of days to import, which may be greater than 90 days. This is located in the Access Event Status frame, under the iPrism Appliance Manager'sSystem Configuration > Reports > Preferences tab.
Note that data will begin uploading to ERS within two hours. Assuming an upload of 120 million records (the maximum per iPrism), it takes approximately 6 hours for uploaded data to convert to ERS format, per iPrism. The # Web Records (shown above) will provide an indication of how "full" the iPrism is in terms of reporting data. If uploading/converting data from multiple iPrism units, it may require 2 — 3 days to complete the initial upload/conversion effort; however, this is a one-time task. Note that going forward, a job runs hourly on each iPrism unit to incrementally upload reporting information. A nightly job will index and optimize these daily incremental uploads, making the data available for aggregated high-performance reporting the next day.
Note: To run ERS reports via Appliance Manager on a client PC, 512MB of RAM is required; 1GB of RAM is recommended. Less than 512MB may result in a "heap" error when running ERS reports on the client PC.
Be sure to reference the following ERS resources for more information about ERS:
Enterprise Reporting Server Hardware Guide
Enterprise Reporting Server Knowledgebase