After creating a connection to the data storage, you need to get data from it (as tables, views, stored procedures, etc.). Data can be obtained from any created sources, as well as from data files. Files from which data import is possible are:

strel11 XML files with attached XSD files.

strel11 JSON files.

strel11 Excel files (xls, xlsx).

strel11 CSV, DBF.

 

 

Import Data

You can get data from the storage using the Import Data command. Select the data connection and click the Import Data button on the server toolbar.

 

 

 

As you can see in the picture, in the item list of the server, the OLE DB data source is selected. When you choose the Import Data command, Stimulsoft Server will check the data storage for the presence of tables, views, stored procedures, etc. The result will be displayed as the Import Data:

 

 

 

In this window, the data to be added to the data source should be checked. As can be seen from the picture above:

strel11 Selected data tables Categories, Products, and Suppliers. If there are multiple items, but not all, chosen in the category, this category will be marked with .

strel11 Selected Views. Checking this category (in this example, in the category of views) entails the installation of flags all sub-items.

strel11 No stored procedures are checked.

 

Once the necessary tables, views, stored procedures, and other elements of the data storage are selected, press the button Ok. All data from the storage will be converted into a data table and displayed in the list of the server:

 

 

 

Now the data tables can be attached to the report. All attached tables will be displayed in the data dictionary of a report. It is also possible to attach a data source to the report. In this case, the data dictionary will have all the attached tables of the data source.

 

 

Editing data tables

You can modify data tables. For example, change the type and number of data columns. To do this, select a data table and click Edit.

 

 

img_1 A name of the table that is displayed to the user in the item tree of the navigator;

img_2 A short description and annotations to the table can be specified in this field;

img_3 Using the Refresh Frequency parameter, you can set the length of time after which reconnection to the data storage will be done. The following options are available:

strel11 Once - retrieving data is carried out once when you create a data source;

strel11 Every 10 Minutes - in this case, data will be carried out every 10 minutes;

strel11 Every 30 Minutes - every half hour, the data will be updated;

strel11 Every Hour - updates go every hour;

strel11 Every 4 Hour - retrieving data will be every 4 hours;

strel11 Every Half Day - data will be updated every 12 hours;

strel11 Every Day - once a day the data will be updated;

strel11 Always - this option means that whenever you build a report, the data will be updated.

 

img_4 Query Type: Query of Stored Procedure.

img_5 Field of Query Text.

img_6 The control panel contains the following buttons:

strel11 Add Column. With this button, you can add a data column to the data source. It should be considered that this column will contain a description. It does not contain actual data.

strel11 The Add Parameter command. Using this command, you can add an option to the category of Parameters. In this case, this parameter must be specified manually in the query.

strel11 Delete Column. Clicking this button will delete the selected columns from the data source.

strel11 The command Retrieve Columns. Once the query is created, press this button to get a column with the data from the data storage.

 

img_7 This panel displays a data column in the data source.

img_8 The settings panel of selected columns.

 

 

Import Data from Files

The command Import Data provides the ability to retrieve data from files (XML, CSV, JSON, Excel, DBF) and convert them into tables. This command can be found on the Toolbar of the file from which it is possible to import.

 

 

 

Sample Import Data from File

Consider the example of retrieving data from the XML file.

 

Step 1: You need to add XML and XSD files to the list of the server item:

strel11 XML and XSD files can simply be dragged and dropped from anywhere into the tree of items;

strel11 Create the item File and load in it XML and XSD files.

 

 

 

Step 2:  You need to attach the XSD file to the XML file:

strel11 Hover the cursor on the XSD file, hold down the left mouse button, and, without releasing the mouse button, move the cursor to an XML file;

strel11 Call the form for editing XML files. Select an XML file in the tree, and click Edit on the Toolbar. Attach the XSD file in the form of editing XML files.

 

Step 3: You should select the XML file and call the command Import Data. The report server will extract the data from the file, converts them into a tabular form. The result will be displayed in the window New Table.

 

 

 

Step 4: In this window, you can select data tables. In the example above, the selected tables are Categories, Products, GlobalGrowth.

 

Step 5: You need to click the Ok button.

 

After you click the Ok button, the selected tables will be displayed in the item list. Now, based on these tables, you can generate reports and dashboards.