English
Español
UTL0002 - Data Source
This screen aims to configure the Data Source where SQL queries will be registered, to feed the dashboard objects in the Simple Viewer system. The registration on this screen depends on the settings with the database connection.
What can you do?
Initial Data Source Registration
- To register a new data source, access SimpleFarm > Utilities Menu > Common > Data Source (UTL0002).
- Start the registration by clicking the Add button, located at the bottom of the screen, and fill in the following fields:
- Code;
- Name: data source name;
- Comment : optional;
- Group ;
- Type;
- Connection String;
- Query ;
- If necessary, insert the Variables in brackets [NOMEVARIAVEL];
- If necessary, check Available for:
- Chart ;
- Cube ;
- List ;
- Map ;
- Integration ;
- Click on Save to register the data source.
In this tab, the titles that will be displayed for each field are configured, as well as translations to other languages, when necessary. For value fields, it is possible to define aggregators, as applicable. In addition, this tab allows the creation of calculated fields, whose logic follows the same principles of SQL language.
Important
Ensure that the SQL query is well-structured to guarantee that the data is correctly extracted and presented. Proper aggregation and adequate syntax are essential for the good functioning of the generated objects.
The SQL query must be optimized to ensure system performance. Inadequate performance can negatively affect data loading. Check the attention points:
- Comments in the middle of the query are not allowed;
- For queries that return values, aggregation must be configured (e.g.: sum, avg, min, max);
- The field should only be changed if additional formulas need to be applied.
In the Filters tab, it is possible to define whether each filter will be mandatory or optional. By clicking on a filter, a window will be opened with the option to check the mandatory requirement. If checked, the filter must be filled in for the dashboard to work correctly, and this setting will be visible in the filter list itself. In addition, there is the possibility of using fixed filters and dynamic filters, with dynamic filters being configured through variables, accessed on the Variable screen, in common.
English
Español
