Product Information: Accessing XML Data Sources

InetSoft's dashboard platform can access XML data source, mash them up with any other data source, and render interactive web-based dashboards in real-time.

InetSoft's cloud flexible business intelligence solution delivers the benefit of cloud computing and software-as-a-Service while giving you maximum level of control. In terms of software-as-a-service, BI software is unique because it inherently depends on the data not being embedded in the application.

 
 

When Using the API

The data source URL can be dynamically specified by replacing the URL with a parameter, e.g., $(filename), when creating a new XML data source. The value for this ‘filename’ parameter can be specified using script or the programming API, just like with any other report parameters. If the parameter value is not provided to the report engine via script or the programming API, then the user will be prompted for it.

Every XML data source must contain at least one request. For more complex XML data sources, it is often necessary to create multiple requests. Each request can have different parameters and a different XML output type. If the URL is not HTTP based or does not need to have any parameters, simply create a request without specifying any parameters.

XML Element Types

The XML Element Types can be specified as any one of the following pre¬defined types:

String	Integer	Short	Boolean
Float	TimeInstant - Date and time	Long	Double
Char	Time - Time of day	Date - Date only	Byte

For date and time data types, a date format can be supplied to create a date parser. The format string should be constructed according to the format specified by java.text.SimpleDateFormat class. For example, to parse the date ‘01/30/2000 01:30:59’, use the format ‘MM/dd/yyyy hh:mm:ss’. The ‘double’ element type requires that the decimal format be specified. The format string should be constructed according to the pattern defined by the java.text.Decimal class. For example, to add commas to a number, use ‘#, ###, ###. ##’.

XML element types do not normally need to be specified. This is only necessary if the element is used in the query selection conditions as a non-string type. For example, if the birthday is compared in a conditional expression with another date value, the type must be specified for the XML element, otherwise it will be treated as a string and the comparison will be meaningless.

Since only one schema is defined for each request, a request can only generate XML data in the specified schema. A separate request must be defined in the data source for each different XML output type.

Scenarios of Using the API to Create Dashboards from XML Data Sources

Using InetSoft's API to create dashboards from XML data sources opens up a range of possibilities. Here are some scenarios illustrating how this can be beneficial:

1. Dynamic Data Integration:
   • Scenario: Your organization receives XML data from various sources, and you want to dynamically integrate this data into dashboards.
   • Use Case: Utilize the API to programmatically fetch XML data, transform it as needed, and populate dashboards in real-time, ensuring that the information is always up-to-date.
2. Automated Dashboard Generation:
   • Scenario: You have a system that generates XML reports regularly, and you want to automate the creation of dashboards based on these reports.
   • Use Case: Develop a script using the API to automatically generate dashboards from incoming XML reports, saving time and ensuring consistency in dashboard creation.
3. Custom XML Schema Support:
   • Scenario: Your XML data follows a specific schema, and you want to create dashboards that adhere to this custom schema.
   • Use Case: Leverage the API to map the XML data to the dashboard components, ensuring that the visualizations and analytics reflect the structure of your custom XML schema.
4. Cross-Platform Integration:
   • Scenario: You need to integrate XML data from a variety of platforms into a centralized dashboard system.
   • Use Case: Use the API to connect to different XML data sources, standardize the data, and present it in a unified dashboard. This is particularly useful for organizations dealing with diverse data formats.
5. Real-time Monitoring of XML Feeds:
   • Scenario: Your business relies on real-time data updates from XML feeds, and you want to monitor and analyze this data continuously.
   • Use Case: Implement the API to fetch real-time XML updates and reflect these changes instantly on dashboards, providing decision-makers with live insights into critical data.
6. Parameterized Dashboards:
   • Scenario: You have XML data with parameters that influence the displayed information, and you want to create parameterized dashboards.
   • Use Case: Develop a solution using the API to enable dynamic parameter handling, allowing users to interactively adjust parameters and see the corresponding changes in the dashboard visuals.
7. Data Transformation and Enrichment:
   • Scenario: The XML data needs transformation or enrichment before being presented in a dashboard.
   • Use Case: Utilize the API to preprocess XML data, apply necessary transformations or enrichments, and then feed the refined data into the dashboard, ensuring data accuracy and relevance.
8. Scheduled Dashboard Updates:
   • Scenario: You want to schedule updates for XML-based dashboards to ensure that they always display the latest information during specific time intervals.
   • Use Case: Use the API to schedule automatic updates for dashboards, fetching and incorporating the latest XML data at predefined intervals without manual intervention.

More Articles for XML Data Source Developers

Build Mashups of Your Off-line Data and Other Enterprise Data - A key strength of InetSoft's business intelligence software is its depth of support for data mashups. Data from that spreadsheet sitting on your laptop, or the spreadmart on your LAN drive can be combined with almost any other data source found in your enterprise including: relational databases (via JDBC), multidimensional databases, XML, SOAP, Java...

Build Virtual Data Models - Building virtual data models with InetSoft involves creating a representation of data from various sources that can be manipulated and analyzed in a unified manner. While InetSoft is primarily a business intelligence tool, it can be utilized to create virtual data models by leveraging its data integration, transformation, and visualization capabilities...

Cloud Dashboards With Easier Analytics - Looking for a convenient way to access and analyze your data wherever, whenever? Want to connect to multiple data sources, including those on premise, to a customized BI platform in the cloud? Whether you are looking to build dashboards in the cloud yourself, or have them built by seasoned BI professionals, InetSoft's BI solution is perfect for real-time business dashboards and reporting in the cloud...

This Year's Best Monthly Report Tool - Are you looking for the best monthly report tools? InetSoft's pioneering dashboard reporting application produces great-looking web-based or paginated reports. The software has been top rated by customers for personalized support on G2. View a demo and try interactive examples...

Tree Transformation Rules - If a path in the schema tree is selected without any query conditions, the query will simply parse the XML output and return the selected subtrees as the result. The result tree is interpreted by the report engine based on the binding of the query. If tabular data is expected by the element the query is associated with, a tree is transformed into a table using the following rules...

When You Need to Combine Data Sets for Reporting - Data mashup is a key feature of InetSoft's products that allows you to quickly combine data from different sources together to create dashboards and reports that easily convey powerful insights. With InetSoft's data mashup, data sources of almost any type can be worked with and combined, allowing the ease of using a single data source without the labor of constructing a data warehouse...