Connecting to Your Data

Connect to your data, no matter where it resides. Learn the three use cases for JasperReports Server data sources, manage database drivers, and troubleshoot connectivity errors.

Date:
24 Sep 2014
Software:
iReport, JasperReports Server, Jaspersoft Studio
Version:
v5.0
Audience:
Database Adminstrators, System Administrators
Phase:
Developing


Premium Subscription

Unlimited access to all Online Learning Portal courses for $200/month or $1200/year.

Subscribe Now

Already have a subscription?

Log In
1. Data Sources Overview Overview See It Try It Print It Quiz
Introduction  
About Data Sources  
8:13
About 'Big Data' Data Sources  
3:02
2. Built-in Data Sources: JDBC and JNDI
About JDBC and JNDI Data Sources  
5:25
Managing Database Drivers  
2:50
   
Setting up a JDBC Data Source  
1:35
   
Setting up a JNDI Data Source  
1:22
   
3. More Built-in Data Sources
Setting up AWS Data Sources  
5:49
   
Setting up a Hadoop-Hive Data Source  
2:14
   
Setting up an Internal Diagnostic Data Source  
1:07
   
Setting up a MongoDB Data Source  
1:06
   
Setting up a Virtual Data Source  
1:17
   
4. Advanced Topics
Setting up a Custom Data Source  
3:01
   
Troubleshooting Data Source Connection Errors  
14:55
5. Resources
Wiki search: data source troubleshooting  
Wiki article: Connecting JasperReports Server to your Database  
Wiki article: Using XML Datasource in JasperReports Server  
jTDS driver for Microsoft SQL Server and Sybase  
Microsoft JDBC Driver for SQL Server  
MySQL Connector/J  
Oracle JDBC Driver Downloads  
Pervasive  
PostgreSQL JDBC Driver  
Video: Connecting JasperReports Server to MS SQL Server  
Apache Tomcat 6.0 JNDI Datasource HOW-TO  
Apache Tomcat 7.0 JNDI Datasource HOW-TO  
JBoss Web JNDI Resources HOW-TO  
Oracle GlassFish 3.1 Administration Guide: Administering JNDI Resources  
Wiki article: Jaspersoft MongoDB Query Language  
Wiki article: Jaspersoft Hive Query Language  
Wiki article: Hadoop Hive Sample Reports  
Community: Jaspersoft BI for Amazon Web Services  
Community: Connect to AWS Data Sources  
Community: Launching Jaspersoft for AWS  
Community: Jaspersoft BI for AWS FAQs  
Wiki: Jaspersoft BI for AWS  
Amazon RDS (Relational Database Service for MySQL, Oracle, SQL Server)  
Amazon Redshift (data warehouse / columnar database)  
Amazon IAM (Identity Access Management)  
Amazon CloudFormation (AWS resources templates)  
Amazon EC2 (Elastic Compute Cloud)  
Tool: Universal SQL Client  
Wiki article: How to create and use a JRDataSource adapter  
Wiki article: How to create and use a JRDataSource adapter  
Wiki article: Data Source Troubleshooting  
Wiki article: Data Source Troubleshooting  
JasperReports Server Administration Guide, Sections 4.1.5 and 4.1.6  
Jaspersoft Tech Talk: Big Data  
Community project: Cassandra Connector  
Community project: Google BigQuery Connector  
Community project: Hadoop Connectors  
Community project: MongoDB Connector  
Community project: Neo4j Connector  
Community project: VoltDB Connector  
Webinar: Using Big Data Analytics with Jaspersoft (requires registration)  
Blog search for Big Data: Right Outer Join (Matt Dahlman)  
JasperReports Server Administration Guide, Sections 4.1.2 and A.61  
JasperReports Server Administration Guide, Sections 4.1.1, A.6.2, A.6.3 and A.6.7  
JasperReports Server Administration Guide, Sections 4.1.3, A.6.1 and A.6.3 - A.6.7  
JasperReports Server Ultimate Guide, Chapter 5 (requires registration)  
Jaspersoft Partners: Systems Integrators  
Jaspersoft Professional Services: Integration Jumpstart  
Jaspersoft Professional Services: Time for Hire  
Jaspersoft Training: Embedding Jaspersoft BI  
Wiki article: Adding a filter to a custom datasource  
Wiki search: custom data source for JasperReports Server  
JasperReports Server Administration Guide, Sections 4.1.7 and 4.1.1 - 4.1.3  
JasperReports Server Administration Guide, Section 4.1 and Chapter 8  
Community: Hadoop Connectors  
JasperReports Server Administration Guide, Section 4.1.6  
Community: MongoDB Connector  
JasperReports Server Administrator Guide, Section A.6  
Wiki article: How to Produce Clean Log Files for Troubleshooting  
Wiki article: Log4j.properties - JasperReports Server  
MySQL: Adding User Accounts (privileges)