About Provisioning Data
Accessing data basics
Understanding data sources
How a report accesses data
Supported data sources
Creating reusable data sources
Creating a connection profile
Using a connection profile
Setting connection properties when a report runs
Setting the folder path for text files at run time
Setting the database user name and password at run time
Troubleshooting data source problems
Understanding data sets
About data sets
Viewing and changing output columns
Adding a computed field to a data set
Verifying the data returned by a data set
Specifying the data to retrieve at run time
About the Query Text property
Specifying a value for the Query Text property
Combining data from multiple data sources
Combining data from multiple data sources in BIRT Designer Professional
Creating a union data set
Creating a joined data set
Getting information about query execution
Reviewing where sorts, groups, and filters are executed
Reviewing the query that is sent to the database
Binding data
About binding data
Understanding column bindings
Descriptive names
Dynamic updates of calculated data
Creating column bindings
Editing and deleting column bindings
Copying data elements
More about column-binding expressions
Accessing data in supported data sources
Accessing data in a data object
Using data object data in a report
Connecting to a data object
Using a data set in a data object
Using a data model in a data object
Using a cube in a data object
Accessing data in a JDBC database
About JDBC databases
Accessing data using a textual query or stored procedure
Creating a JDBC data source
Managing JDBC drivers
Using a SQL query to retrieve data from a JDBC data source
Using a stored procedure to retrieve data from a JDBC data source
Accessing data using a graphical query
Connecting to a database
Specifying the data to retrieve
Accessing data in a NoSQL database
About NoSQL databases
Accessing data in Amazon DynamoDB
Connecting to Amazon DynamoDB
Specifying the data to retrieve from Amazon DynamoDB
Accessing data in Amazon Relational Database Service
Connecting to Amazon RDS
Specifying the data to retrieve from Amazon RDS
Accessing data in Cassandra
Connecting to a Cassandra scripted data source
Specifying the data to retrieve from a Cassandra scripted data source
Accessing data in Cloudera
Connecting to a Cloudera database
Specifying the data to retrieve from a Cloudera system
Accessing data in Hadoop
Connecting to a Hadoop system
Specifying the data to retrieve from a Hadoop system
Accessing data in HBase
Connecting to an HBase database
Specifying the data to retrieve from an HBase system
Accessing data in MongoDB
Connecting to MongoDB
Specifying the data to retrieve from MongoDB
Setting runtime connection properties
Accessing data in Salesforce.com
Connecting to Salesforce.com
Specifying the data to retrieve from Salesforce.com
Accessing data in files
About file data sources
Accessing data in an Excel spreadsheet
Supported data types
Connecting to an Excel workbook
Specifying the data to retrieve from an Excel workbook
Accessing data in a text file
Text file structure
Text file data types
Creating a flat file data source
Specifying what data to retrieve from a text file
Accessing data in an XML file
Creating an XML data source
Specifying what data to retrieve from an XML data source
Accessing data in a BIRT report document
Creating a report document
Connecting to a report document
Specifying the data to retrieve from a report document
Accessing data in an e.report
About ActuateOne for e.Reports Data Connector functionality
Accessing an e.report using Page Level Security
Accessing an e.report having multiple sections
Connecting to an e.report
Specifying the data to retrieve from an e.report
Accessing data from a web service
Using web services data in a report
Connecting to a web service
Specifying what data to retrieve from a web service
Creating a web services data source using a custom connection class
Accessing data in a POJO
Using POJO data in a report
Connecting to a POJO
Specifying the data to retrieve from a POJO
Modeling data
Creating data objects
About data objects
Design considerations
Designing data objects for dashboards
Designing data objects for reports created with Report Studio
Designing data objects for reports created with BIRT Designer Professional
Building a data object
Creating new items for a data object
Exporting items to a data object
Creating a shared dimension for cubes
Configuring data set columns for summary tables
Creating hyperlinks to provide drill-down capability
Hiding data sets from users
Building a data model
Defining joins in a data model
Materializing the data sets in a data model
Filtering data in charts
Enhancing the usability of a data model
Providing cached data
Publishing a data object
Enabling incremental updates
Replacing the .data file in an iHub Encyclopedia volume
Replacing the .data file in a file system
Managing user access
Maintaining a data object
Connecting to data sources
About data source connections
About drivers
About information object connections
Using a connection configuration file
Changing a configuration file
Specifying the location of the connection configuration file
Configuring a cluster to use a connection configuration file
Defining environment variables
Connecting to data sources
Connecting to a DB2 data source
Connecting to an Informix data source
Connecting to an Oracle data source
Connecting to custom data sources
Using a connection pool
ODBC/JDBC connection pooling
Configuring BIRT JDBC connection pooling
Setting the Encyclopedia engine connection pool reap interval
About Provisioning Data
Setting the Encyclopedia engine connection pool reap interval