Datasets contain information that can be viewed and modified in a grid. While queries return the most current information in the database, a dataset displays the same information until it is modified manually. For example, you might use a dataset to store information from an external system so that the data can referenced or used to create graphs in Meridium Enterprise APM.
When a dataset is created, a data type is defined for each column to indicate the type of data that can be stored in cells in that column. When you create or modify a dataset, if you attempt to enter data that conflicts with the data type defined for that column, the data will not be retained. The following types of data can be stored in a dataset:
- Character Stores alphanumeric data. Cells in columns of this data type will appear as text boxes in which you can enter letters, numbers, and symbols.
- Numeric Stores numeric data. Cells in columns of this data type will appear as text boxes in which you can enter numbers.
- Date Stores date and time data in the format MM/DD/YYYY. Cells in columns of this data type will display the button, which can be selected to access a calendar from which a date can be selected. You can also enter dates directly into cells.
- Logical Stores the value True or False. Cells in columns of this data type will appear as text boxes in which you can enter the value True or False.
You can create new datasets manually within Meridium Enterprise APM, or by importing a Microsoft Excel file (.xls or .xlsx), an XML file (.xml), or a text file (.txt or .csv).
After you create a dataset, you can access it, modify it, use it to create graphs, and export it as a Microsoft Excel file, an XML file, or a text file.
