Creating APIs‎ > ‎

Database Creation

You can connect to an existing database or create a new database. In Live API Creator, new databases are called managed databases. This page describes how to create a new managed database.

For more information about connecting to an existing database, see Database Connectivity.

Watch it

The following video illustrates how to create a new database:

Include gadget (iframe)

Create a New Database

You can create a new managed database within a managed data server or, if you want to control schema creation (its name, location, etc.), create a new database and use managed data within your own schema. The following procedure creates a new managed database within the managed data server. To use managed data with your own schema, see Manage Existing Schema.

After you create your new database and the new schema within the managed data server, you can open your API, start Data Explorer in a new tab and access Author Mode, and then create tables, fields, and relationships in your managed data source.

Prerequisite: You have defined a managed data server. For more information about adding a managed data server connection, see Managed Server Administration.

  1. On the Home page, click Create New API. (If the Welcome Window is displayed, close this window.)
    The connection wizard opens.
  2. Select New empty database as the target database.
    The following image shows this option on the wizard:

    The connection parameters for your new empty database display in the wizard.
  3. Click Select next to the managed data server you want to use for your new database.
The API is created. A new empty database and new schema with a randomized user, schema, and password within the managed data server is created.

The Core Idea: Your App is your IDE

To offer the simplification of creating a database, the premise cannot be to teach database syntax and concepts to those who have other priorities. Rather, the approach must be to take well-known concepts that are already understood and create databases from these. That is, the application itself.

Virtually all business users can immediately recognize a Master/Detail form. The following image shows Data Explorer:

For more information about the Data Explorer functions, see Data Explorer.

The idea is to build on this familiar and visual paradigm:

  • Create a table. Enter a name for the table and Data Explorer builds and runs the SQL to create the table.
  • Add a field. Enter a name and type for the field and Data Explorer builds and runs the SQL to add the field.

Note: Fields represent the columns in your database. The term field is used to stay within the metaphor of applications and screens, and not database terminology.

  • Create a related table. You can build tables that are related:
    • Create a child table. Creating a child table creates a managed child table and a relationship between the child and the parent table. This is, for example, how the LineItem table was built.
    • Create a parent table. Creating a related parent table relates a row to a specific parent record. This is, for example, how the Product table was built, by way of the Name field, where you pick a Product for a LineItem.

For more information about how to create a new managed database, see Managed Data Servers.