•  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 volume
      • Replacing the .data file in a file system
    • Maintaining a data object
  •  Providing data security
    •  About data security
      • Using security IDs
      • Access control lists and data security rules
    •  Using data protected by data security rules
      • Comparing the design and deployment environments
      • Comparing data security using live and cached data
    •  Designing and managing data security rules
      • Structure of a data security rule
      • Data security rule creation and assignment
      • Understanding implicit join behavior
      • Viewing data security rule assignments
      • Editing a data security rule
      • Deleting a data security rule
    •  Designing a data security rule policy
      • Granularity design considerations
      • Implicit join considerations
      • Combining rule conditions
•  Accessing data from BIRT iHub
  •  Connecting to data sources from BIRT iHub
    •  About data source connections on BIRT iHub
      • Understanding AC_SERVER_HOME
      • Understanding acserverconfig.xml
      • About drivers
      • About information object connections
    •  Using a connection configuration file
      • Changing a configuration file
      • Specifying the location of the connection configuration file
    • Defining environment variables for BIRT iHub
    •  Connecting BIRT iHub 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

Accessing data basics

Setting the Encyclopedia engine connection pool reap interval