JReport Designer can access data from an external data source, such as a text file, or Excel file, which is not stored in a database, or when there is no JDBC driver available. This feature uses the user data source API provided by JReport. In addition, due to the unique nature of Oracle and Enterprise DB stored procedures, you will not be able to add them into a JReport catalog directly. As a substitute, JReport has developed a user data source class that can use stored procedures in Oracle and EnterpriseDB.
A user defined data source itself can be used to create page reports directly, and in this sense it functions the same as a query. Therefore, you can use the Data Manager to control the data retrieval of user defined data sources and create cached result files for user defined data sources the same as you do for queries. User defined data sources can also be used to build queries and business views.
This section contains the following topics about working with user defined data sources in a catalog: