Add a Datasource to Business Analytics to Connect to the Database
If you do not already have a datasource defined in Business Analytics for the database containing the data you want to work with, have your Business Analytics administrator add one.
The example shown in this topic is from a MySQL database with machine sensor data. Every half second various readings are added to this database for different devices. The dataset, shown below in XML format, includes the value (data_value) for a reading, a code (data_item_id) for the type of reading, a code for the device (device_id) and both a timestamp and a date/time in milliseconds when the reading was taken.