Data Sources
  • 15 Jul 2022
  • 2 Minutes to read
  • Contributors

Data Sources


An overview of data sources and its advanced data collection functionalities

A data source simply assembles data stored in data tables and provides a visual summary of the data in the form of rows and columns.

In Quixy, there are two unique concepts in defining a data source, the adoption is same, but the process of collecting the data varies:

  1. You can JOIN two or more Data Tables to create a Data Source, and
  2. You can even MERGE two or more data sources to create a Mammoth Data Source.

image.png

NOTE

Use the above JOIN and MERGE links to understand the respective data assembling processes. However, as we progress in this article, you will learn more about the adoption of both data sources.

Both the concepts share the same responsibility in adoption & standard actions.

Usage/Adoption Types:

  1. Generating Reports (Grids, Charts, Documents)
  2. Views (List screen)
  3. References (fetching data into application) &
  4. Add-ons (Static Columns & Business Rules)

Manage Data source: View Records, Edit Data source, Copy Data source, Rename Data source, and Delete Data source.

image.png

Let’s deep-dive into the details of the data source Adoption Types and Actions:

Data source Adoption Types

1. Report: A report uses the data from a data source to transform it into an infographic or tabular representation that helps users to make informed decisions. Quixy’s report engine is capable of transforming data into 40 distinct representations. Look at Chart Report.

2. Views: A view is an actionable report. It draws data from a data source and represents it in a tabular form providing you the capability of configuring the pre-defined actions that can bridge a process. Learn more about Views.

3. References: References empower the users to fetch the existing data of a database into applications to fulfill the needs of a use case. Learn more about References
4. Add-Ons: There are two items that you can define on top of an existing data source:

A. Static Columns: This provides you the opportunity to add an extra column to a data source with static data. This static column is data source dependent, so it will not get added to any data table
B. Business Rules: This option provides you with the ability to democratize the data collection process. These business rules work the same way it happens in app creation. Learn more about Add-Ons. 

Manage Data sources

Actions allow the admins to maintain/diagnose a data source to ensure its working condition and make changes according to the required manifestations. Below are the various actions available for a data source:

1. View Records: This to preview all your data records on one page.  
2. Edit Data source: This to make changes in the data source. 
3. Copy Data source: This is to produce a duplicate copy of a data source with defined requirements.  
4. Rename Data source: This is to adjust the name of a data source. You also have a straightforward way to rename a data source. Refer to the GIF below. 
5. Delete Data source: This is to delete a data source. However, there is a condition that the data source must be freed from all its relationships before deleting it.


Was this article helpful?