Actuate BIRT Designer supports all the types of data sources that open-source BIRT Report Designer supports, and more.
Table 1-1 lists the types of data sources that each product supports.
Actuate data objects, Actuate information objects, and BIRT report documents are data files that report developers or data architects create with Actuate BIRT Designer. These files contain the information to connect to and retrieve data from enterprise data sources, such as databases and web applications.
The Amazon RDS (Relational Database Service) data source enables a connection to Amazon’s web service, which provides access to a relational database in the cloud.
The Hive data source enables a connection to Hadoop through Hive, an open-source data warehouse infrastructure for facilitating data summarization, queries, and analysis.
Like the JDBC data source, the JDBC connection for Query Builder data source supports the retrieval of data from JDBC databases. However, instead of typing a SQL query to select the data to retrieve, you use a graphical query builder to construct the SQL query.
A static data source is a set of data that you create in Actuate BIRT Designer. This type of data is useful when you need to create sample data quickly for testing purposes.
