Before you begin using Live API Creator, review the following videos and reading material. These materials give you a basic introduction to the components and features of Live API Creator

CA Live API Creator Product Components

Live API Creator accelerates and simplifies the creation, execution and monitoring database-oriented APIs. The resultant APIs integrate, manage, and secure multiple databases.

Live API Creator includes the following components:
  • Client applications that you access from your browser:
    • API Creator - API Creator is a Web Console you can use to specify your API, your logic (rules and JavaScript), database location, and your security settings. It is an HTML5/JavaScript interface, so it runs in your browser.
      Note: We recommend using Chrome and Firefox.

    • Data Explorer - Data Explorer is a self-contained service you can use for API testing, prototyping, and back-office data maintenance. Data Explorer uses the REST API's for your base tables to create a fully executable and running HTML5/JavaScript multi-table user interface to the underlying data. It runs on desktop and tablet browsers.
  • API Server - A backend service and web app that stores the security settings in the admin database and enforces them in the course of processing REST retrieval/update requests. Typical clients are Web/Mobile Apps or other systems. API Server operates as a WAR file. You deploy it into standard containers on-premises or in the cloud.

  • The Admin Database - The Admin database (meta repository) stores your API definitions, logic, and security settings. It is transparent for cloud/appliance users, and must be configured for WAR users. Access the admin database by way of the API Creator REST API. You can use (MySQL or Apache Derby/JavaDB) as your database. For WAR users, you must configure it. You access this database using Live API Creator's REST API. 
    • You can export admin contents into a file for maintenance in a source control system.  
    • You can script the creation of APIs into an API server using the Admin command-line interface (CLI).

  • Identity Management - In typical deployments, API Creator calls out to your security system (Active Directory (AD), LDAP, OAuth) for authentication, or pluggable authentication. To facilitate development, you can use the default authentication provider.

Training Guide

API Creator is designed to get you up and running fast, yet provide the depth to deploy Enterprise-class APIs.  We recommend the following training program, provided by the web-based resources described below.

LevelLearningsResourcesCertified By
BasicConnect database, build multi-table API, use API
  • Videos. You can also access these videos in Live API Creator, on the Welcome Window.
  • The Welcome Tour. You can also access the tour from Live API Creator. 
  • Quick Reference.
  • You have watched the videos.
  • You have completed the Start-up Tour ("Graduation cap" icons in Live API Creator that open the tour.)
  • You have completed the Welcome Tour.
IntermediateAPIs, Logic, Integration, OperationsB2B Advanced Sample
Logic Demo

Understand the Architecture

API Usage Examples: 
FullUse All Design Patterns
Comfortable using Javascript for events, formulas, and validations
Logic Tutorial

Logic Patterns
  • Build Logic Sample DB
AdvancedBuild new Rule Types
Build Security Provider

Custom Auth Provider in B2B Advanced Sample

We anticipate most folks with a moderate database background can achieve 
  • Intermediate within a day or so (the key skill is to Think Spreadsheet)
  • Full within several days  
  • Advanced requires experience with APIs, so will take a week or two.

Usage Overview

Live API Creator basic usage overview, based on the components:

1. Install an API Server

For more information about installing API Server, see Install Requirements.

2. Log on to Live API Creator

For more information about logging on to Live API Creator, see Log on to Live API Creator.

3. Get an Overview

User the API Creator Welcome Window to get an overview of Live API Creator.

4. Create an API

The API Server needs access to your database, whether it be stored in the cloud or within your firewall. Create an API, or API project, using the pre-supplied Northwind database oconnect to one of your own databases. The Northwind database is part of the CA Live API Creator Tour and is an easy way to start. Supply your database credentials and the system builds the default API, the JavaScript Object Model, and the Data Explorer UI. Your default API includes end points for each table, view, and stored procedure. Important! Refresh the schema if you change your REST API.

5. Explore your REST API

You can test your REST API in the REST Lab or in the Data Explorer.
Manage and test data using the 

6. Secure Access to your APIs

Authentication (also known as Identity Management) controls who can see and use your APIs. Access Control is a role-based service that determines what a specific user can see and do with the api. You can secure individual resources and protect both row and column on base table endpoints.

7. Add Reactive Logic

One of the most important features of API Server is the Reactive Logic engine used to enforce business policies and rules.  Like a spreadsheet, rules are invoked (i.e. react) to changes in the data from PUT, POST, and DELETE on base tables. Your database design may require changes to support some of these new features (like sums and counts) or you can use the validations to enforce transaction integrity.  The entire engine supports extensible libraries in Java and JavaScript.

8. Analyze REST Services

The results of every REST call can be seen our browser based log display. We also capture the metrics of the SQL queries and the performance of each rule execution.

Subpages (26): View All