Database Creation

Database Creation
lac32
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: CA Technologies  
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 
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.
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:
Role
Authorizes
Data admin
Create, update, and delete access to managed data servers.
Data designer
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.