Creating APIs‎ > ‎Database Creation‎ > ‎

Managed Server Administration

As an administrator of managed data servers, you can set up managed databases. The managed database is the database itself. You can have many managed databases in a managed data server.

How to Set up a Managed Database

Setting up a managed database involves setting up the managed data server. Setting up a managed data server is not a requirement for using managed data, but it is a requirement for managing the content in a data source for a managed database. You can designate that any schema of any supported server can be changed.

Prerequisites:

  • You have dba permissions to the data source you are going to add and super user privileges to the managed database to which you have access.
  • You are logged in to API Creator with a user assigned to the data-management role.

Use the following process to set up your managed data server:

  1. Add a managed data server connection.
  2. Add a managed data source in the managed data server to which you added a connection.
  3. Authorize users to create managed databases within the managed data server.

Repeat this process for each managed data server you want to use.

Add a Managed Data Server Connection

You can add as many managed data server connections as you require.
    1. From the Home page, click the Managed Data Servers tab. The following image shows this tab:
    2. Click Add.
    3. Complete the fields on the page;
      For local servers, the URL is typically jdbc:mysql://localhost:3306
      Note: All of the fields except Catalog are required.
    4. Click the Active checkbox and save your changes.

Your managed data server connection is added.

Add a Managed Data Source in the Managed Data Server

Add a managed data source in the managed data server to which you added a connection. You can have many managed databases in a managed data server.

You can add the managed data source in the managed data server in the following ways:

  • From your existing API project.
  • When you create a new API.

To add a managed data source from your existing API project:

    1. Open your API project and go to Integrate, Data Sources.
    2. Click the down arrow next to Add and select the managed data server connection you added.

Your managed data source is added in the managed data server and is added to the list of API data sources.

To add a managed data source when you create a new API:

  1. From the Home page, click Create New API.
    The Create API wizard opens.
  2. Click New empty database.
    The Connection window opens. The following image shows the Connection window:
  3. Select the managed data server for your new database by clicking Select and then click Continue.

An API for a new managed database is created, your managed data source is added in the managed data server, and the managed data source is added to the list of API data sources.

Authorize Users to Create a Managed Database within the Managed Data Server

You can authorize users to create managed databases within the managed data server using the following methods:

  • Define the users manually.
  • Define the users and their roles using a custom authentication provider based on your existing corporate security stores, such as Lightweight Directory Access Protocol (LDAP) and Active Directory (AD).

You authorize users to create and use managed databases and managed data servers in your organization by defining admin authentication providers.

For more information:

More Information

For more information:
  • About managed data sources, including how to manage the content in your managed data source, see Managed Data Servers.
  • About how to designate that any schema of any supported server can be changed, see Manage Existing Schema.