The Data Source step allows you to bring data into the Query Object from various sources:

You can include multiple Data Source steps in a Query Object. Each step requires you to set specific properties.

Property	Description

Property	Description
New Source/Existing Query Object	Choose whether to create a new SQL or file source or use an existing Query Object.
Connection	Select a connection from the available list or choose Parent. If Parent is selected, the Data Source fetches data from the connection specified in the Connections option at the top left of the screen or defaults to the user’s configured connection. If a connection name is selected, the Data Source fetches data only from that connection, regardless of other connections in the Query Object.
SQL	Create a complete SQL statement using the SQL Wizard. This option is available when the selected connection points to an RDBMS. Open the SQL Designer window to write or edit SQL queries.
File/Stream Source	Specify the file name, file type, and parsing details using the File Selector Wizard. This option is available when the selected connection points to a file system.
Web Service	Specify the web service name, port, method, and record pattern using the Web Service Selector Wizard. This option is available when the selected connection points to a web service.
Existing Query Object	Use an existing Query Object. The output of the selected Query Object becomes the input for this Data Source.
Fields	View and configure all fields available in the Data Source, including field properties (discussed in Field Properties below).

File as a Data Source

The File Selector wizard allows you to fetch records from a file by specifying the file name, file type, and parsing properties.

Steps:

Web Service as a Data Source

The Web Service Selector wizard allows you to fetch data from a connected web service.

Steps:

On the Query Object Editor, select a connection or web source.
Click Select under Web Service.
Specify the web service name, port, method, and record pattern in the displayed wizard.

Note

Kyvos Reporting supports JSON as a file type for File and Web Service data sources.

When using Kyvos Reporting as a provider:

Select the required connection.
Click Design to open the SQL Editor.
In the SQL Editor, select a Semantic Model.
- Search for and select the desired model from the available categories.
View the dimensions and measures for the selected semantic model in the bottom-left pane.
Write the required query using the listed dimensions and measures.
Click Result to view the output.

Note

Property	Description

Property	Description
Data Type	Select the data type of the incoming data: CHAR, NUMBER, DATE, or BINARY.
Data Format	Specify the format of the incoming data. Useful for converting CHAR fields to Date or Number types.
Database Time Zone	Specify the time zone in which the incoming date data is stored. Useful for converting data (e.g., from GMT to EDT) based on reporting requirements.
Length/Precision	Set the field length for CHAR types or precision for NUMBER types.
Scale	Define the number of digits after the decimal point for numeric data.
Locale	Specify the language or country in which the incoming date data is stored.
Sort Priority	Specify the sort priority for the field (lower numbers indicate higher priority).
Sort Criteria	Choose whether to sort the data in ascending or descending order.
Qualified Name	Provide a custom name to resolve field name ambiguity when the same field is fetched from multiple tables or expressions.