About object-relational mapping (ORM) data types
Object-relational mapping (ORM) data types communicate with a database. The data in the data type is mapped to the data in the database so that the two sets of data have the same value. This mapping is accomplished through exchanges in SymQ.
You can create an ORM data type with the User-Defined Type with Database Mapping component generator.
See About the User Defined Type with Database Mapping generator.
The benefits of using an ORM data type are as follows:
Helps preserve data
By using an ORM data type, your process data is periodically saved in a database. During run-time, if your process loses its data, the data is still preserved in the database.
Lets you avoid using database upload components
ORM data types automatically upload process data to a database. Therefore, you do not need to use uploading components.
Guarantees that your process and your database use the same data type
ORM data types do not constantly store their data to a database. Constant communication with the database would significantly slow down the process. ORM data types store data to a database in various places in your process.
ORM data types store data in a process as follows:
In your process, when you want the ORM data type to store its data to the database, use a Save External Data component. You do not need to configure this component. When this component is invoked in a process, it causes all of the existing ORM types to store their data.
Thanks for your feedback. Let us know if you have additional comments below. (requires login)