Jaspersoft is designed for direct reporting and analysis of numerous data sources. In some cases you will need to install database drivers for in order to connect to your source data.
If you do not have access to a JDBC database driver, you can download from the following locations:
Data Source | Download Location |
Microsoft SQL Server | http://www.microsoft.com/en-us/download/details.aspx?id=11774 |
Oracle RDBMS | http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html |
IBM DB2 | http://www-01.ibm.com/software/data/db2/linux-unix-windows/downloads.html |
Vertica | |
Ingres | |
Informix | |
Sybase |
Installing with JaserReports Server (JRS)
Via the Create Data Source Web UI:
- The desired JDBC driver must be copied to the local file system from where the browser is run.
- Create a new Data source from the JRS web UI.
- From the JDBC Driver drop-list, select the desired driver that is shown as NOT INSTALLED. The Add Driver... button appears.
- Select the Add Driver... button. The Select Driver dialog appears.
- Select the Browse... button.
- Locate and select the file.
- Select the Upload button.
You should then be able to provide the relevant connection information and use the Test Connection button to verify connectivity.
For more information, refer to Chapter 4 of the JasperReports-Server-Admin-Guide.
Also note that Jaspersoft® Product Suite will no longer include Simba Drivers after April 30, 2023. Please refer below wiki article for more details:
Recommended Comments
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now