第23章 Data sets authoring
A data set is a collection of related sets of information. It can be stored in many ways, such as in a database, in a Microsoft Excel file, or in memory. A data set definition instructs Business Central methods to access, read, and parse a data set. Business Central does not store data. It enables you to define access to a data set regardless of where the data is stored.
For example, if data is stored in a database, a valid data set could contain the entire database or a subset of the database as a result of an SQL query. In both cases, the data is used as input for the reporting components of Business Central which then displays the information.
To access a data set, you must create and register a data set definition. This data set definition specifies the location of the data set, the ways to access it, read it, and parse it, and the columns that it contains.
The Data Sets page is visible only to users with the admin role.
23.1. Adding data sets リンクのコピーリンクがクリップボードにコピーされました!
You can create a data set to fetch data from an external data source and use that data for the reporting components.
Procedure
-
In Business Central, go to Admin
Data Sets. The Data Set Explorer page opens. Click New Data Set and select one of the following provider types:
- Bean: Use to generate a data set from a Java class
- CSV: Use to generate a data set from a remote or local CSV file
- SQL: Use to generate a data set from an ANSI-SQL compliant database
- Elastic Search: Use to generate a data set from Elastic Search nodes
Execution Server: Use to generate a data set using the custom query feature of an Execution Server
注記KIE Server must be configured with this option.
Complete the Data Set Creation Wizard and click Test.
注記The configuration steps differ based on the provider you chose.
- Click Save.