Skip to main content
Hitachi Vantara Lumada and Pentaho Documentation

Add an XML Data Source

You must have a report file open in order to proceed, and your data source must be accessible before you can connect to it in Report Designer. For database connections, you may need to first obtain necessary information from your system administrator, such as the URL, port number, JDBC connection string, database type, and user credentials.

Follow this procedure to add a data source in Report Designer.

  1. Select the Data tab in the upper left pane. By default, Report Designer starts in the Structure tab, which shares a pane with Data.
  2. Click the yellow cylinder icon in the upper left part of the Data pane, or right-click Data Sets. A drop-down menu with a list of supported data source types will appear.
  3. Select XML from the drop-down menu. The XML Datasource Editor window will appear.
  4. Click the round green + icon above the Available Queries field.
  5. Type a concise yet reasonably descriptive name into the Query Name field.
  6. Enter your XQuery into the Query field, then click Preview to ensure that it is valid.
  7. Click OK when your query is in order.