Our products serve a wide range of customers with varying goals. To ensure the lowest costs and most effective results, we will create a custom package that works for you and your company's needs. Please contact our sales department at sales@quadbase.com to build your package.
Yes, it's written in pure java and can be run on any platform that supports Java.
Our support team stands ready to help you design professional reports and dashboards for your targeted audience. We can even use samples from your actual data to provide meaningful templates and examples. Please contact Quadbase support at support@quadbase.com to discuss with a representative regarding your specific requirements. For more involved projects, please inquire about our professional services.
ERES uses the following extensions:
RPT - Report Designer report
QRP - QuickDesigner report
PAC - ChartDesigner chart package (with data, background images etc.)
CHT - ChartDesigner chart with data
QCH - QuickDesigner chart
TPL - ChartDesigner chart template
PAK - Report archive
DSB - Dashboard
GXML - Google map
SXML - SVG map
CXML - Google map coordinates
SVG - SVG map image
GPAK - Google map package
SPAK - SVG map package
DPAK - Dashboard package
The ERES appearance can be easily modified without any programming by using the customization feature found under the Admin Console.
If you want to move a licensed ERES from one machine to another, you may re-use the same license key by the following procedure, as an example.
(1) On Windows machine that has installed the licensed version, go to
Or you may use the Windows shortcut, Start /All Programs / ERES /Uninstall ERES
(2) Move InstallERES66.exe to another machine and use the same license key again.
(3) The above procedure also works on non-Windows machine where you should use a Command Prompt and run the corresponding file in the UninstallerData directory.
ERES requires a Oracle / Sun Java Development Kit (JDK) installed on your machine to install and run. If you only have a Java Runtime Environment (JRE) or if you don't have Java at all, please visit the Java SE Download Page and download the latest JDK.
If you have both JDK and JRE installed, make sure to select the JDK folder on the select Java VM panel in the installer.
Absolutely. One of the advantages of having a Java based product is that it can run on any OS that supports Java.
Internet Explorer (6+), Safari and Firefox. The Java plugin is required for designers using the Organizer. JavaScript and cookies must be enabled for all users.
First, start Tomcat by navigating to /bin/ and running startup.bat on Windows or startup.sh on Unix/Linux/Mac/etc. Next, open ERES start page in your favorite browser, the default address is http://:8080/ERES, but this can be altered during installation. Finally, click the Start button in the ERES Server section.
The ERES Server requires Sun Java Development Kit (JDK) version 1.5. Any designers using the Organizer will need to have a JRE plugin for their browser. No Java is required to use the QuickDesigner, Map Builder, and Dashboard Builders remotely, and end users do not need Java to view finished reports, charts, maps, and dashboards.
You may find an answer in the User Guide
If you don't find the answer there, don't hesitate to contact us (support@quadbase.com).
The ERES Database stores data critical to the ERES system such as the Organizer file structure, security and permissions, etc. This is not to be confused with the data sources you will use to create reports and charts.
In ERES installation, if you failed to register license, you can go to http://www.quadbase.com/license-registration-1/ to get a new qblicense.jar, remove each original qblicense.jar in /lib/ and /WEB-INF/lib/ and copy the new jar file into these two directories.
It possible to run jnlp file as
$ javaws ERES_Organizer.jnlp
but you may want to run it with simple double click.
The folllwoing steps tell users how to run ERES_Organizer.jnlp by double clicks:
You will need to create a .desktop file like described in the this post for javaws to appear in Open With dialog.
You may need to create a new text file in the folder ~/.local/share/applications. Name this file whatever you want, it has to have the extension .desktop. The content of this file has to be the following:
[Desktop Entry]
Encoding=UTF-8
Name=Java 6 Web Start
Comment=Java 6 Web Start
Exec=/usr/lib/jvm/java-6-oracle/jre/bin/javaws %u
Terminal=false
Type=Application
Icon=javaws
Categories=Application;Network;
MimeType=application/x-java-jnlp-file;
Please pay attention that the path to javaws executable in the Exec parameter may be different on your system. You can find out the path to your javaws executable by typing the following command in terminal:
which javaws
or by listing listing all your JDK/JRE installations with the command:
update-alternatives --display javaws
To turn off the warning for all websites:
In IE7+, click Tools -> Internet Options. Go to the "Security" tab and then click "Custom level". Scroll down to the "Downloads" section. Switch the "Automatic prompting for file downloads" to "Enable". Click OK, Yes, OK.
To add ERES as a trusted website and turn off the warning for all trusted sites:
In IE7+, click Tools -> Internet Options. Go to the "Security" tab, click on the "Trusted sites" icon, and click on the "Sites" button. Type in the host for the ERES Server, (e.g. http://www.quadbase.com) the port number is not necessary. Uncheck the box "Require server verification (https:) for all sites in this zone". Click Close. With "Trusted sites" still selected, click on "Custom level". Scroll down to the "Downloads" section. Switch the "Automatic prompting for file downloads" to "Enable". Click OK, Yes, OK.
You need to copy the correct database driver to the /WEB-INF/lib/ directory and restart the server. If using API, make sure to add the driver to the classpath. See this FAQ for details.
If you are copying the ERES to a new machine, you need to have a separate license key. The second license key can be used during installation or after the installation using the registration website. The registration site will generate a new qblicense.jar file specific to your machine.
If you are moving to another machine, the license key will be released when you uninstall ERES from the previous machine, so you can use the same license key during the installation on the new machine. You can also use the same key on the the registration website to generate the qblicense.jar file after installation.
If you use the website to generate the qblicense.jar file, make sure to copy and paste it into /lib/ and /WEB-INF/lib/ directories overwriting the files there and then restart the server.
Go to /register.jsp to generate a new qblicense.jar and copy and paste it into /lib/ and /WEB-INF/lib/ directories.
Export from browser (Menu Page, Dashboard, generated URL) is done on the server side. Export from Report Designer is done on the client side. So if you export large report from Report Designer, you should also increase the memory on the client. But server side is still used for getting the data, so server side memory should be increased as well. You can quite easily recognize, where you have insufficient memory. If the OutOfMemory error is reported in the Tomcat log, it is a server side memory. If it is in the Java Console, it is client side memory. Therefore,
if the errors happen in the server:
Increase the memory allocation to the application server. For Tomcat, go to /bin/ and edit catalina.bat (catalina.sh for non-Windows). Find the line:
set JAVA_OPTS=%JAVA_OPTS% -Xmx512M
Increase the 512 to a larger number. ERES also provides virtual memory and paging options to reduce memory usage for large reports. Please see the user guide.
if the error happens in the client:
On Windows 7 or 8, increase client side java memory by double clicking the java lcon from control panel / Programs, select the ‘Java’ tab and click ‘view…’ button, ‘Java Runtime Environment Settings’ window pops up, under ‘user’ tab, double click on the ‘Runtime Parameters’ and add, for example, “-Xmx512M” (Set Java maximum heap size to 512 MB).
If you are using .bat file, make sure that the ERES server is running. You might need to check your firewall settings as well and ensure that your machine is able to access the server host and the server port. If running from the web page, please make sure you have a JRE plugin installed on your browser.
Java8 has stopped supporting jdbc-odbc bridge connection. The ODBC Datasource connection in DataRegistry is still working with lower versions of java such as Java7 but not Java8. Available workaround must be used for ODBC connection to Access database if Java8 were used.
Use the "Dashboard and Map" Packages feature described here (navigate to section 2.1.4.4). It allows you to pack all files that are connected with the dashboard into a single file which can be easily moved elsewhere.
Make sure to set the "Font Mapping" correctly.
Documentation for Reports
Documentation for Charts
Obtain Google maps API key. Please, keep in mind that you have to fill in the host name or IP address that will be used for connecting to ERES Maps. For example: If you fill in your domain name, Google maps will not work when you connect to ERES using IP address.
Make sure that you are using correct coordinates file.
When you want to add a file that is not currently accessible via your web server (Tomcat...), you have to manually add an URL that points to a folder that contains the file.
Make sure to add your SMTP settings in the Admin Console. After you do so, restart the ERES server and try it again.
Did you use "back" button in your browser? Please, don't use browser back and forward buttons when working in ERES.
Moving components of a report can become cumbersome, we recommend that you create PAK file for the report and simply move the PAK file.
The data source in the report is not linked with the data source in the data registry. You can either modify the data source in the report, or use the update option described here.
Please note that there are certain requirements before you can use the update option.
Please restart the ERES Server. In order to shut the ERES Server down, you need to be logged in as an administrator.
Files are saved into the ReportFiles/ChartFiles/DashboardFiles directory by default. You can open the Organizer, click "Insert new file to current folder" button and insert the file.
It’s a common practice for users to integrate ERES into an existing application. This implementation requires single sign-on and to embed reports, charts, dashboards in custom web pages.
Integrate Users/Groups/Relationships into ERES
To do single sign-on, first, users need to integrate their existing users, groups, and relationships into ERES system. The details can be found in Section 8.2 - Integrating Existing Users and Groups
If existing user information are stored in LDAP, please find details in Section 1.4.1.4 - LDAP Settings.
Extension class UserSecurityProvider provides a flexible way to retrieve/implement users and groups from any source, please find details in Section 8.2.2 - Implementing UserSeurityProvider
Pass login information into ERES to load Chart/Report/Dashboard
After users login their application, and then click ERES links, the login information can be passed to ERES internally, so users don’t have to login one more time for ERES.
Single Sign-On details and example are in Section 7.3.3 - Single Sign-On
User login information can also be included in a URL of a chart image, a report, or a dashboard. It’s straightforward to generate a URL from ERES Organizer. To do so, select a chart, report, or dashboard, right click to find Generate URL in popup menu, make sure to check “For Current User” option. The menu details is in Section 2.1.2.1.3 - Publish Menu
URL Examples
The values of USERNAME and PASS can be encrypted or not.
Chart
http://ServerName:8080/ERES/servlet/LookupServlet?USERNAME=qEJAY5c24h&PASS=qEJAY5c24h&URLTYPE=FORCHART&ChartPathEN=http%3A%2F%2FServerName%3A8080%2FERES%2Fhelp%2Fexamples%2Fdashboard2%2FAlerts+Dashboard%2F*m-47-46-32-4bmx-53-3b-51O-50zxsT-46mL-4ey-48M-56aa2eg&DisplayType=JPG&ExportMethod=B&JPEGQuality=99
Report
http://ServerName:8080/ERES/servlet/LookupServlet?USERNAME=qEJAY5c24h&PASS=qEJAY5c24h&URLTYPE=FORREPORT&TemplatePathEN=http%3A%2F%2FServerName%3A8080%2FERES%2Fhelp%2Fexamples%2Fdashboard2%2F*-06JIoN-74xEtOw-58-1ar-59-07P-02-1eL-12Q-20Qd32fh&ExportFormat=DHTML&OptimizeMemory=false&MultiPageExport=false&QueryParamName=category&QueryParamSize=1&QueryParamValue=Arm Chairs
Dashboard
http://ServerName:8080/ERES/Dashboard/Dashboard.jsp?OpenFile=http%3A%2F%2F ServerName%3A8080%2FERES%2Fhelp%2Fexamples%2Fdashboard2%2FCampaigns.dsb&USERNAME=qEJAY5c24h&PASS=qEJAY5c24h&USESESSION=FALSE
Embed Report/Dashboard using iframe
Report/Dashboard can be included in web pages using iframe, for example:
Some users may find ERES Organizer loads cached jars, especially when working on two or more ERES servers. It's because ERES Organizer(Web Start) only download jars with newer modified date. So the newer modified jars are cached in the client machine, only when "Keep temporary files on my computer" option is turned on in Java Control Panel.
To force ERES Organizer to always download jars, you need to turn off "Keep temporary files on my computer" option.
To clear the Java web cache, please go to Java Control Panel > General tab> “Settings…” button > “Delete Files…“, ensure the “Cached Applications and Applets” option is selected. Press “OK“.
Below are a collection of URL and Driver for common database connection and drivers.
Hsql (Hypersonic sql) database server (EspressReport example database datasource)
Hsql JDBC Driver (in-process or standalone mode)
jdbc classes: hsqldb.jar under $espressreport_install_dir$/help/examples/DataSources/database/hsqldb.jar
database url (relative path): hsqldb:help/examples/DataSources/database/woodview
database url (absolute path | windows): hsqldb:C:/espress-report/help/examples/DataSources/database/woodview
database url (absolute path | unix): hsqldb:/usr/espress-report/help/examples/DataSources/database/woodview
jdbc driver: org.hsqldb.jdbcDriver
Hsql JDBC Driver (server mode)
jdbc classes: hsqldb.jar under $espressreport_install_dir$/help/examples/DataSources/database/hsqldb.jar
database url (1 db on 1 machine): jdbc:hsqldb:hsql://machineName
database url (> 1 db on 1 machine): jdbc:hsqldb:hsql://machineName:port
jdbc driver: org.hsqldb.jdbcDriver
documentation: frame | no frame
IBM's DB2 v8
JDBC Type 2 driver implementation: the legacy/CLI JDBC driver
jdbc driver: COM.ibm.db2.jdbc.net.DB2Driver | COM.ibm.db2.jdbc.app.DB2Driver
jdbc classes: db2java.zip
database url: jdbc:db2://machine/database | jdbc:db2:database
download: Find it in $(db2-install)/java/db2java.zip
Universal JDBC driver
jdbc driver: com.ibm.db2.jcc.DB2Driver
jdbc classes: db2jcc.jar, jd2jcc_license_cu.jar (license)
database url: jdbc:db2://host:port/database (ex. jdbc:db2://server1:50000/phonedb)
download: http://www.ibm.com or find it in $(db2-install)/java/db2jcc.jar and jd2jcc_license_cu.jar
MS SQL Server 2000
JDBC Drivers from Microsoft
jdbc classes: msbase.jar, mssqlserver.jar, msutil.jar
database url: jdbc:microsoft:sqlserver://host:port
jdbc driver: com.microsoft.jdbc.sqlserver.SQLServerDriver
JSQLConnect from JDBC Drivers from Microsoft
jdbc classes: msbase.jar, mssqlserver.jar, msutil.jar
database url: jdbc:microsoft:sqlserver://host:port
jdbc driver: com.microsoft.jdbc.sqlserver.SQLServerDriver
download: Net Direct
MS SQL Server 2005
JDBC Driver from Microsoft
jdbc class: sqljdbc.jar
database url: jdbc:sqlserver://host:port
jdbc driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
Link:
MS SQL Server 2005 JDBC Driver Download
http://msdn.microsoft.com/en-us/data/aa937724.aspx
MySql
MySQL Connector/J from MySql (www.mysql.com)
jdbc classes: mysql-connector-java-2.0.14-bin.jar (download from www.mysql.com)
dtabase url: jdbc:mysql://host/database
jdbc driver: com.mysql.jdbc.Driver
OpenBase
JDBC Driver from OpenBase
jdbc classes: OpenBaseJDBC.jar (download from www.openbase.com)
dtabase url: jdbc:openbase://host/database
jdbc driver: com.openbase.jdbc.ObDriver
Oracle
JDBC Thin Driver
database url: jdbc:oracle:thin:@host:port:sid
jdbc driver: oracle.jdbc.driver.OracleDriver
jdbc classes: ojdbc14.jar (download from www.oracle.com)
OCI Driver
database url: jdbc:oracle:oci8:@{your-tns-name}
jdbc driver : oracle.jdbc.driver.OracleDriver
jdbc classes: ojdbc14.jar (download from www.oracle.com)
Links:
Oracle11g JDBC Developer's Guide and Reference
http://download.oracle.com/docs/cd/E11882_01/appdev.112/e12137/toc.htm
Oracle JDBC Driver download
http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
Sybase
JConn2 driver from Sybase
jdbc classes: jconnect2.jar
database url: jdbc:sybase:Tds:host:port
jdbc driver: com.sybase.jdbc2.SybDriver
PostgreSQL
database url: jdbc:postgresql://:/
jdbc driver: org.postgresql.Driver
jdbc classes: postgresql-8.4-701.jdbc4.jar (download from http://jdbc.postgresql.org/download.html)
Informix
database url: jdbc:informix-sqli://:/:informixserver=
jdbc driver: com.informix.jdbc.IfxDriver
jdbc classes: ifxjdbc.jar (download from http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc)
Add correct version of POI library to your classpath, it can be found under /WEB-INF/lib/.
Add at least ERESOrganizer.jar, ERESServer.jar and qblicence.jar. You might also need to add certain 3rd party jars like poi-30.jar (for Excel export), axercesImpl.jar and xml-apis.jar (for working with XML), FlashExport.jar (exporting to Flash), ExportLib.jar (PNG and other image formats), and database drivers (depend on the database you will be using).
If you are running an evaluation copy, please contact our sales office (sales@quadbase.com) to get a release license key. Otherwise, make sure that you have added the correct qblicence.jar file into your classpath.
It's up to you. Your application can be fully independent, or you can connect to the ERES Server. Pros and cons of both approaches are described in manual.
Yes, after starting the ERES server, click on the Quick Start API Examples link on the front page. There are some examples in the User's Guide and in the ERES installation directory.
© Quadbase Systems inc. Sitemap
