You can connect to an existing database or create a database. In
CA Live API Creator, the databases that you create are called managed databases. This article describes how to create a managed database.
For more information about how to connect to an existing database, see Database Connectivity.
In this article:
Create a Database
You can create a managed database within a managed data server or, if you want to control schema creation (such as its name and location), create a database and use managed data within your own schema. After you create your database and the schema within the managed data server, you can open your API, start Data Explorer (in Author Mode), and then create tables, fields, and relationships in your data source for a managed database.
For more information about how to create a managed database and how to manage the content in a data source for a managed database using Data Explorer, see Managed Data Servers.
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.
Fields represent the columns in your database. The term
fieldis 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 theLineItemtable was built.
- Create a parent table.Creating a related parent table relates a row to a specific parent record. This is, for example, how theProducttable was built, by way of theNamefield, where you pick a Product for a LineItem.
Roles for Creating Databases
The system administrator (
sa) user can authorize admin users to create and use managed databases by assigning one of the following predefined roles:
Create, update, and delete access to managed data servers.
Create and delete access to managed databases and create, modify, and delete access to tables, fields, and relationships in those managed databases.
For more information about how to add an administrator user and assign this user these roles, see Manage Admin Users.