Accessing Data
 
Accessing Data
Enterprise report data is frequently stored in a variety of systems and formats. BIRT Report Designer provides wizards to set up access to the following types of data sources:
*Cassandra scripted data sources
*Excel data sources
*Flat file data sources
*Hive data sources
*JDBC database connection for Query Builder data sources
*JDBC data sources
*MongoDB data sources
*POJO data sources
*Scripted data sources
*Web services data sources
*XML data sources
A report, however, is not limited to using data from these data sources. Developers can write JavaScript or Java scripts to get data from Java objects, such as Enterprise JavaBeans. Developers can also use BIRT’s Open Data Access (ODA) framework to write custom data drivers to access data from any source, including data stored in proprietary systems.
This section discusses how to use the wizards in BIRT Report Designer to set up access to a data source without programming. For information about writing scripts and developing custom data drivers, see Integrating and Extending BIRT (Addison-Wesley, 2011).
After creating a BIRT data source, you specify what data to retrieve. Data sources, especially databases, typically contain more data fields than are needed for a report. Retrieving excess data fields slows report generation. This section also discusses how to create data sets to retrieve data from the different data source types.