Docs‎ > ‎Reactive Logic Tutorial‎ > ‎

Sample Projects


You would use a similar procedure for your own projects.

Sample Databases

API Creator provides 3 sample databases:
  • Northwind - located on the New API Menu is created as part of the 'Tour' when you first start the API Creator in a browser (you can skip the 'Tour' using the link on the first dialog or pressing shift-click on the right help menu window for each tour item).

  • Demo - a simple database of 6 tables (customer, orders, items, products), used to illustrate basic concepts

  • Sample - a database of few dozen tables, used in the Logic Tutorial to illustrate advanced rules and database concepts

Account Types

There are a number of different Account Types, summarized in the table below.  Your account type determines whether the Demo and Sample Databases are available, or require installation

 Account Type  How can I tell
Demo DB & API Project
 Sample 
DB and API Project
Sample Project
On-premise    Not created - use the procedures on this page
download here
  Not created - use the procedures on this page
download here
 Not created - use the procedures on this page
Jetty  Automatically installed  Automatically installed  Automatically installed


Create or Verify Demo and Sample Databases

The first step is to create the 2 sample databases for war file installations, or otherwise verify them.

War File accounts - Create databases

If you are using the war file, you must create the Logic Demo and Logic Sample databases.

We recommend naming these as shown below:
  1. Download and unpack the project export file.  These contain, for both Logic Demo and Logic Sample:
    1. json Project export files, created using the project export procedure.
    2. sql files, to initialize the schema and data

  2. Create the dblocal_demo and dblocal_sample schemas, as shown here.

    Use the  same procedures you used to create the admin_db Database

  3. Load the schema and sample data from the supplied .sql file
You can verify the database is created by using MySqlWorkbench to query the customer table as shown below:



Other Accounts - verify

In other cases, the Sample Database was already created while building your server. 

You can verify it in your favorite database tools.

Create Sample Projects

Projects are the definitions you create for your Data Sources, your API (Custom Resources, etc), your logic and your security.  Just like projects you create, the sample projects have been exported into a json export file.  Import them as shown below.
  1. Perform the procedures below once for Logic Sample, and once (as required) for Logic Demo.

Create Project from Import

Download the export, and import it to create a new project, as follows:
  1. If your have not already done so, download and unpack the project export file.  These contain, for both Logic Demo and Logic Sample:
    1. Json Project export files, created using the project export procedure.
    2. sql files, to initialize the schema and data

  2. Click Import

  3. Select Choose File, and select the unpacked file json from above

Project Fixup

The json export file does not include passwords and other key security information.  You will therefore need to make a few small updates to your project, as described below.

  1. You will need to uncheck Short Menu [x]

Database Definition

You must first update the Database URL and Catalog as shown below.  The proper credentials depend on your Account Type:
  1. War Install - use the defaults, and specify the Password as password!
  2. Otherwise - obtain the values from your registration email (see screen shot above)

Project URL and Authorization Provider

The import defaults several project properties as shown below - fix them as shown below:
      1. Access API Properties on the left navigation var
      2. You will have to correct the Authorization Provider.  
      3. For your own projects, you will also need to fix:
        1. Project Name
      4. Project Name
        1. URL Fragment
      5. URL Fragment

User Passwords

If you are using the Default Authentication Manager, you will need to update your Passwords.  
    1. For the sample databases, specify Password1


Verify Operation

Go to REST Lab or Data Explorer and see if your tables, views, and resources are working.