Creating an IDO in App Builder

There are two basic ways in which IDOs can be found in the App Builder Repository: IDOs are available in the Repository from any stock Mongoose IDO you might employ as part of a data service; and you can create your own App Builder-based IDOs, using the Table & IDO Wizard.

This topic is for the creation of your own IDOs and their associated tables, using the Table & IDO Wizard.

Access the App Builder Repository and select the IDOs tab.
Click Create from Wizard.
In the Table & IDO Wizard, provide a Name for your IDO.
We recommend using a name that will help you and other users be able to identify its purpose.
In the Table Alias field, provide an alias for the IDO table.
This alias is a unique, valid SQL identifier for this table. It is used to reference the table in join specifications and in generated SQL.
From the Project drop-down list, select the IDO project with which the IDO and table are to be associated or included.

Note: This value refers to "IDO Projects" as defined and used in Mongoose, and not to individual App Builder projects.
Optionally, provide a description that you and others can use to identify the IDO and its use.
Click Next.
On the next page of the wizard, define the properties to be included in the IDO and table:
1. To add a property, start by clicking the plus (+) icon.
2. On the left side of the Create Properties page, provide values for these property attributes:
  
  Name
  
  (Required) Provide a name for the property.
  The property name is case-sensitive and cannot contain spaces or most special characters. The rules for special characters are the same as for SQL tables.
  
  Data Type
  
  (Required) From the drop-down list, select the type for the data to be used by this property.
  
  Property Length
  
  Specify the maximum number of characters to be allowed in this field.
  Note: This field is disabled for some data types.
  
  Options
  
  Select the Primary Key, Required, and Read Only options as appropriate for this property.
  
  Repeat these substeps for each additional property you want to define for use.
Click Next.
Use the Summary page of the wizard to review your settings and definitions of the IDO and table
When you are satisfied that it is all correct, click Finish.

App Builder generates the IDO and table and adds it to the App Builder Repository.

Note: When the IDO and table are generated, App Builder also creates additional properties that are required for use by the IDO in Mongoose.