•  Accessing Data
  • About BIRT data sources
  • About data sets
  •  Accessing Cassandra data
    •  Connecting to a Cassandra data source
      • How to create a Cassandra data source
    •  Specifying the data to retrieve from a Cassandra data source
      • How to specify what data to retrieve from a Cassandra data source
  •  Accessing Excel data
    •  Connecting to an Excel workbook
      • How to create an Excel data source
    •  Specifying the data to retrieve from an Excel workbook
      • How to specify what 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
      • How to specify the connection information for accessing a text file
    •  Specifying what data to retrieve from a text file
      • How to create a data set to retrieve data from a text file
  •  Accessing Hadoop data in a report
    •  Connecting to a Hadoop system
      • How to create a Hive data source
    •  Specifying the data to retrieve from a Hadoop system
      • How to specify what data to retrieve from a Hadoop system
  •  Accessing database data using the query builder
    •  Connecting to a database
      • How to connect to a database
    •  Specifying the data to retrieve
      • How to create a query using the query builder
      • Creating computed columns and complex expressions
      • How to create a computed column
      • Filtering data rows
      • How to filter data rows
      • Grouping data
      • How to group data
      • Filtering groups
      • How to filter groups
  •  Accessing database data using a textual query
    •  Creating a JDBC data source
      • How to specify the connection information for a database or other JDBC data source
    •  Managing JDBC drivers
      • Adding a JDBC driver
      • How to add a JDBC driver
      • Deleting a JDBC driver
      • How to delete JDBC drivers in a JAR file
      • Restoring a JDBC driver
      • How to restore a JDBC driver
    •  Using a SQL query to retrieve data from a JDBC data source
      • Writing a basic SQL query
      • Combining data from multiple tables
      • How to create a SQL query to retrieve data from a JDBC data source
    •  Using a stored procedure to retrieve data from a JDBC data source
      • How to use a stored procedure to retrieve data from a JDBC data source
  •  Accessing MongoDB data
    •  Connecting to MongoDB
      • How to create a MongoDB data source
    •  Specifying the data to retrieve from MongoDB
      • How to specify what data to retrieve from a MongoDB database
      • Mapping selected fields
      • Writing expressions
    • Setting runtime connection properties
  •  Using POJO data in a report
    •  Connecting to a POJO
      • How to create a POJO data source
    •  Specifying the data to retrieve from a POJO
      • How to create a POJO data set
  •  Connecting to a web service
    • How to specify the connection information for accessing a web service
    •  Specifying what data to retrieve from a web service
      • How to create a data set to retrieve data from a web service
      • How to enable a user to provide parameter values to a web service
  •  Connecting to an XML file
    • How to specify the connection information for accessing an XML file
    •  Specifying what data to retrieve from an XML data source
      • How to create a data set to retrieve data from an XML document
  •  Creating reusable data sources
    •  Creating a connection profile
      • How to create a connection profile
    •  Using a connection profile
      • How to create a data source that uses a connection profile
  •  Setting connection properties when a report runs
    •  Setting the folder path for text files at run time
      • How to set the folder path for text files at run time
    •  Setting the database user name and password at run time
      • How to enable a user to provide a database user name and password when a report runs
  • Troubleshooting data source problems
  •  Viewing and changing output columns
    • How to view and change output columns
  •  Adding a computed field to a data set
    • How to add a computed field to a data set
  •  Joining data sets
    • How to join data sets
  •  Verifying the data returned by a data set
    • How to change the number of rows that appear in Preview Results
  •  Specifying the data to retrieve at run time
    • About the Query Text property
    • Specifying a value for the Query Text property

Accessing Data

Specifying a value for the Query Text property