Versions Compared

Version Old Version 2 New Version Current
Changes made by

sunny.gupta

sunny.gupta

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

  • RDBMS

...

  • : Using SQL or stored

...

  • procedures.

  • File/IOT Stream: From a file system or IoT stream source.

  • Web Service: By accessing web service data.

  • Another Query Object: Using an existing Query Object as input.

  • Big Data/Non-

...

Kyvos

...

  • Relational Databases: For large-scale or unstructured data.

  • Kyvos Reporting: Integrating with Kyvos Reporting to fetch data.

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

Property

Value

Comment

Description

New Source

-

/Existing

QO

New Source -Existing QO

You choose whether

Query Object

Choose whether to create a new SQL or file source

is to be created

or

you can

use an existing Query Object.

Connection

  • Select a connection from the available list or

Select (

  • choose Parent

)

  • .

When selected (Parent), then this

  • If Parent is selected, the Data Source fetches data from the connection specified in the Connections option

present

  • at the top left

options bar (Refer Figure 2) or falls back to default connection configured for the user.When

  • of the screen or defaults to the user’s configured connection.

  • If a connection name is selected,

then this

  • the Data Source fetches data only from that connection,

irrespective of Query Object connection or connection of other Data Source in this

  • regardless of other connections in the Query Object.

SQL

A Complete

Create a complete SQL statement

designed with

using the

help of

SQL Wizard

. This

property

option is

visible when you select a connection that

available when the selected connection points to an RDBMS.

The

Open the SQL Designer window

opens for you to design an SQL or procedure. See the below section for SQL Designer details

to write or edit SQL queries.

File/Stream Source

File name, File Type

Specify the file name, file type, and parsing details

designed with help of

using the File Selector Wizard

. This

property

option is

visible when you select a connection that

available when the selected connection points to a file system

.The File Selector window opens to specify file name, file type and parsing details

.

Web Service

Web Service Name, Port, Method and Record Pattern details designed with help of

Specify the web service name, port, method, and record pattern using the Web Service Selector

Wizard. This

property

option is

visible when you select a connection that

available when the selected connection points to a

Web Service.The Web Service Selector window opens to specify

web service

, port, method and record pattern

.

Existing

QO

Query Object

Select

Use an existing Query Object

. The output of the

select

selected Query Object becomes the input

of

for this Data Source.

Fields

Lists

View and configure all fields available in

this

the Data Source

The fields along with Field Properties can be set as discussed later

, including field properties (discussed in Field Properties below).

File as a Data Source

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

Steps:

  1. On the Query Object Editor

...

Figure 6: File as a data source

...

  1. , select a connection or file

...

  1. source.

  2. Click Select next to File/Stream Source

...

  1. .

  2. Configure the required file details in the displayed wizard.

Web Service as a Data Source

This The Web Service Selector wizard allows you to select fetch data from a connected web service available from the connected Web Service provider and provides method, record pattern details.On the .

Steps:

  1. On the Query Object Editor

...

Figure 7: Web Service as a Data Source

...

  1. , select a connection or web source

...

  1. .

  2. Click Select under Web Service.

...

By reading the WSDL, it also prompts for parameters required to request the Web Service.

...

  2. Specify the web service name, port, method, and record pattern in the displayed wizard.

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

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

...

.

...

Figure 8: Field Level Properties

...

Kyvos Reporting as a Data Source

When you select the connection created using Kyvos Reporting as a provider, you can write/edit :

  1. Select the required

...

  1. connection.

  2. Click

...

  1. Design to open the SQL Editor

...

  1. .

...

  1. In the SQL Editor, select a Semantic Model

...

  1. .

    • Search for and select the desired model from the available categories.

  2. View the dimensions and measures for the selected semantic

...

  1. model in the bottom-left pane.

  2. Write the required query using the listed dimensions and measures

...

  1. .

  2. Click Result to view the

...

Note

...

You will only view the folders and underlying semantic models you have access to in Kyvos viz.

...

  1. output.

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

  • Only folders and semantic models that you have permissions for will be visible.

  • Data security is applied based on the selected semantic model.

Field Properties

...

for Data Source

...

Steps

Property

Values

Comments

Description

Data Type

CHAR,NUMBER,

DATE,

BINARY

Select the data type of the incoming data: CHAR, NUMBER, DATE, or BINARY.

Data Format

Format String

Specify the format of the incoming data.

This is useful only if Date or IP Address type data are incoming in CHAR fields but needs to be converted to Date and Number types for further use

Useful for converting CHAR fields to Date or Number types.

Database Time Zone

Select Time zone from the list

Specify the time zone in which the incoming date data is stored.

This is useful only if date time data needs to be converted to other time zone data based on reporting requirement.For example, when incoming GMT data need to show EDT (or any requested TZ) value in report, specify that the incoming data is GMT. The output format is generally specified in Format step or in user preference

Scale

Enter

Scale or

Useful for converting data (e.g., from GMT to EDT) based on reporting requirements.

Length/Precision

Enter

Length of field for Char data typePrecision or length of field for Number data type

Select

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

Select from the list

Specify the language

/

Sort Criteria

Ascending/Descending

Specify sort as either

or country in which the incoming date data is stored.

Sort Priority

Number 0-N

If the data is sorted on multiple fields then specify sort priority number of this field.Primary sort field should be the lowest number

This name can be used as the field name

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

Enter

Provide a custom name to resolve field name ambiguity when the same field is fetched from

two

multiple tables or expressions.