Reading from and Writing to Tables

There are several types of objects that can read data from and/or write data to an Oracle Life Sciences Data Hub Table instance, as follows.

Each type contains a Table Descriptor for each Table instance they either read from or write to. The Table Descriptor and Table instance must be mapped. For further information, see Defining and Mapping Table Descriptors.

• Programs. Programs can read from and/or write to installed Oracle LSH Table instances. Report Sets and Workflows contain Programs, and therefore they can indirectly read from and/or write to Table instances. Only one Program instance can write to a particular Table instance.
• Load Sets. A Load Set loads data from an external system into one or more installed Oracle LSH Table instances (see Defining Load Sets).
• Data Marts. A Data Mart reads data from an installed Oracle LSH Table instance and copies the data into a file (see Defining Data Marts).
• Business Areas. A Business Area contains Table Descriptors that allow a data visualization tool to read data from Oracle LSH Table instances.