Possible Source Classes for a Cube

Possible Source Classes for a Cube

In the Architect, if you click New and then Browse next to Source Class, the system displays a dialog box like the following:

Here you can select any class that can be used as the source of a cube in this namespace. There are three types of classes you can use this way:

• Persistent classes — Classes that extend %Library.PersistentOpens in a new tab.

• Data connector classes — Classes that extend %DeepSee.DataConnectorOpens in a new tab. A data connector maps the results of an arbitrary SQL query into an object that can be used as the source of a cube. Typically, a data connector accesses data in a non-InterSystems database, but you can also use it to specify an SQL query against an InterSystems database, including an SQL query on a view.

  If you have a cube based on a data connector and listings in that cube that are also based on data connectors, all of these data connectors must have the same property marked as idkey="true", because the underlying mechanism uses the same ID values in all cases.

  See Defining and Using Data Connectors.

• Collection classes.