Skip to main content

Introduction to Pipeline Dataset

What is Pipeline?

  • The pipeline is a new type of dataset added to the OPNBI Application. Users can Define relationships between different data sets and as well as tables with user-friendly UI. With Pipeline, no SQL knowledge is needed to provide join between tables and datasets available in OPNBI. Earlier, joining Tables to get combined data from various table users has to write SQL Queries and it requires a good understanding of SQL Queries to do so. One who knows how to write SQL Queries can only able to get data from sources so Business users are dependent on a person who knows SQL. It is no longer the case when you use Pipeline to fetch data and apply joins between tables with the drag and drop facility provided in Pipeline.

  • User can also provide joins between datasets that are already created in OPNBI

info

It is not advisable to use a single dataset or table to create a pipeline. There must be at least 2 nodes with at least 1 join between them.

Prerequisites

To create a Pipeline, you need working Datasets (JDBC) and a list of tables and views.

info

With Initial release, the user can join only the dataset which is created JDBC source

A Sample Pipeline view is as shown in the below image,

Docusaurus Slash Introduction

Let's Understand Basic Terminologies of Pipeline;

Create Pipeline

The pipeline can be created from the dataset section itself. In the dataset section, you can see create pipeline option in the footer menu as shown in the image below,

Docusaurus Slash Introduction

When you click on create Pipeline option, a new blank grid window will open. You can see the view as in the below image;

Docusaurus Slash Introduction

1. Pipeline Name

  • Users can provide a unique name for the pipeline in the Name Text field

2. Detail Tab

  • The detail tab contains information on the list of datasets created or tables available for logged-in users.
info

By Default, the detail tab shows a list of datasets(.ds) available in the dataset section. To get the list of tables available you need to change the type from Dataset to Tables and views which will be described later in this document.

  • User can find the required dataset, tables, or views by searching through this search box

4. Parameter

  • Created parameters are listed here, You can see here language parameters also.
info

In the Initial release, language parameters as not supported. It will be available in subsequent releases.

5. Add Parameter

  • User can add parameters to the pipeline dataset by creating parameters from here. This is the first step of using parameters in the pipeline Dataset. once the parameter is created from here, the user can use this parameter in the pipeline later on.
info

In the initial release, the use of parameters was not supported. It will be available in subsequent releases.

6. Source

Docusaurus Slash Introduction

  • By clicking on this Source drop-down, you can see a list of data sources available for logged-in users. Users can select data sources to get the list of tables & views from that data source.

Docusaurus Slash Introduction

  • On the left-hand side, you can see a list of tables and views are displayed in detail list as shown in the image below,

Docusaurus Slash Introduction

7. Add Language Parameter

In OPNBI user can add Language Parameter by clicking on the checkbox of Add Language Parameter, In Language, parameter user has to use Parameter dataset.

In the initial release, this feature is not functioning, It will be available in subsequent releases.

8. Add Condition

  • User can apply one or more conditions to the Results of the data. Conditions can be applied in case output data has to be filtered by one or a group of conditions. It is a way to get selected data in the output.

  • Just like Parameters, Conditions need to be created first from Add Condition button and then will be used inside the join condition.

  • Once we click on add condition, it will show create condition window as in the below image,

Docusaurus Slash Introduction

info

Join conditions can be seen when the user will apply joins between nodes. This point will be described later on in this document.

9. List View

  • List view shows a total list of datasets when selected Type Dataset and shows List of tables and views if Type is Tables & Views

-From here user can drag and drop the required dataset, tables, or views into the Pipeline Grid window.

10. Pipeline Grid Playground

  • All the join and logic building operations on tables, views, or datasets will be performed in this Playground.

  • User just needs to select the dataset, table, or view and drag it into this playground to proceed further.

Node

  • When users drag and drop datasets or tables or views inside this playground, you can see a list of columns available in the selected dataset, table or view will be displayed. Just select the required fields and click on Submit.

Docusaurus Slash Introduction

info

By default, All the columns will be selected in this window. But, users can add a selected column by deselecting them from the list

  • You can see the table or dataset name on the top left side of the column list window

Docusaurus Slash Introduction

  • After clicking on submit button, Box will be added to Playground which is what we call a Node.

  • Similarly, the user can add as many nodes as he wants in this playground by just the drag and drop function.

info

Users can not add the same node more than once in the playground

danger

Make sure that number of nodes added should be interconnected with each other in any manner. Otherwise, it will not give you the output.

11. Zoom in and Out

  • Zoom in and out operations in the pipeline playground can be performed with this slider. By default zoom value is 100 % and by dragging it to the left side zoom out operation will be performed and the node view gets smaller.

  • A slider can be useful in case there are many nodes added to the playground and the user need to check linking with different nodes in a single view.

12. Submit and Cancel

  • Created pipeline and settings applied can be saved by clicking on Submit button given at the bottom-most of the window.
  • By clicking on the cancel button, changes made will be discarded 2918/600 Your text was partially checked. Go Premium to correct longer texts. Rephrase