OASIS has the capability to run reports automatically in a batch environment. This article will explain how to create this batch environment. Note: it is recommended that IT personal or experts perform this setup. The machine running the command file must also have the most current OASIS update in order to run properly.
Creating the OASIS Report
1. Create a report. OASIS recommends using relative dates in the report selection, such as “this week” or “last month”, as this will prevent the need for user input. For more information on OASIS reporting, click here.
2. Save the report using a unique name.
Setting up the Batch Command File
The first command will change the working directory to the OASIS installation directory and is required. The second line cannot be split up with a return or it will break the command and treat it as a new argument. Example:
cd OASIS_INSTALL_DIR\OASIS
..\jre\bin\java -Xmx1G -jar OASIS.jar CLI=REPORTS ARGS DBKind=Sybase DBServer=10.255.10.110 DBPort=5002 DBUser=oasis DBPassword=oasis AUTOLOGIN=demo/ Report=Weekly_Report File=test.pdf
The following sections of the second command line will need to be defined:
- -Xmx1G: define the amount of ram on the machine. For example, 512M = -Xmx512M.
- DBKind: define the database kind to match how the GUI connects to the database.
- DBServer: define the database server address to match how the GUI connects to the database.
- DBPort: define the database port to match how the GUI connects to the database.
- DBUser: define the database user to match how the GUI connects to the database.
- DBPassword: define the database password to match how the GUI connects to the database.
- AUTOLOGIN: define the user login information in userid/password format.
- Report: define the name of the report. Note: replace any spaces with a “_” character.
- File: define the output file name. Note: this feature supports output to PDF and .xls format for individual reports when saving to a file directory. If calling a batch email report, it will only support PDF format and each report will be a separate attachment on the email.
..\jre\bin\java -Xmx1G -jar OASIS.jar CLI=REPORTS ARGS DBKind=Sybase DBServer=10.255.10.110 DBPort=5002 DBUser=oasis DBPassword=oasis AUTOLOGIN=demo/ Report=Weekly_Report File=test.pdf
To generate multiple OASIS batch reports simultaneously, create a batch command file that calls all other batch command files previously created.
Comments
0 comments
Please sign in to leave a comment.