User Entered Data Storage

I am very new to Planatir so forgive me if this question has an obvious answer that I have missed.

I wish to use Planitir to store user data and then blend the data with externally provided oracle data. As Planitir is a business intelligence tool, I can understand how that aspect of the requirement would work.

I however am trying understand whether Planitir has a standard format for storing user data that someone enters via a form or via something built in workshop. I looked at forms but it appeared to be depreciated.

Questions

  • What tool in Planitir would you use to define a table of data and the fields in that table in Planitir that is not sourced externally to Planitir?
  • Does Planitir have a native data storage format? Is so, what is it?
  • If there is no native format, if you load a excel dataset or Apache Parquet file, can Planitir write new records to this file?
  • Where would I find a tutorial on how to build something to store local data?

Thanks for any guidance you can provide. Cheers Matt

In Ontology Manager, you can create a new Object type and select the option to “Continue without datasource”. That would allow you to define properties as needed.

Another option is that you can use the Manual Data Entry option in Pipeline Builder to create the underlying schema for the data that you want to store, and then connect that to your object. You can also define it in code in code repositories.

Datasets in Foundry in the data layer are typically stored in Parquet files once transformed in the platform. Though you can choose a different format if desired.

Data transformations in Foundry don’t directly modify your input file. Transformations will produce a new output.

Start with the Speedrun: Your First End-to-End Workflow. The “Making your Workshop Application Operational” section will allow user inputs using Actions. You can use those concepts to create your own Application that takes user inputs and uses Actions to capture inputs in the Ontology.

Hi Yix, Thanks for the awesome response. Really helpful. Cheers Matt :slight_smile:

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.