5.2.3 Creating JSON Blueprints

Create Blueprints using the Create Tables Blueprint wizard by clicking the Create Blueprint button.

  • Creating a Blueprint from Existing Tables
    Select existing tables from your schema to quickly build a blueprint that enables fast inserts of generated data into them.
  • Creating a Blueprint from Scratch
    Create a new blueprint from scratch based on a sample table with provided columns that enables you to quickly generate sample data. Use Blueprint Designer to add tables to the blueprint after creation.
  • Importing a Blueprint
    Upload a valid blueprint from a JSON file or copy-paste your JSON data into the required fields.

Parent topic: Using Data Generator

5.2.3.1 Creating a Blueprint from Existing Tables

Select existing tables from your schema to quickly build a blueprint that enables fast inserts of generated data into them.

  1. On the Data Generator home page, click the Create Blueprint button.
    The Create Tables Blueprint wizard appears.
  2. Click Use Existing Tables.
  3. Do one of the following:
    • Select from list - (Default) Choose an existing table in your workspace schema to base the blueprint on.
      1. Blueprint Name - Name the blueprint.
      2. List of tables - Click the checkboxes of the tables to include in the blueprint. Use the search bar to filter the list of tables by name. Use the Reset button to remove all search filters applied to the list of tables.
      3. (Optional) Rows Column - Double-click a cell in the Rows column or toggle the Edit button to change the number of rows to include from the table (default 50).
      4. (Optional) Excluded Columns - Input a list of column names to exclude from the auto column generation in the format column1,column2,column3. The Excluded Columns parameter applies to all selected tables.
    • Copy and Paste - Use copy and paste to insert a large amount of tables more easily than selecting from the Select from list option.
      1. Blueprint Name - Name the blueprint.
      2. Tables - Input a comma-separated list of tables and the number of records to generate by default. The format for each table is TABLE_NAME:ROWS_TO_GENERATE (for example: PRODUCTS:10,CUSTOMERS:50,SALES:1000).
      3. (Optional) Excluded Columns - Input a list of column names to exclude from the auto column generation in the format column1,column2,column3. The Excluded Columns parameter applies to all selected tables.
  4. Click Create Blueprint.
The wizard generates the blueprint. Oracle APEX navigates to the blueprint in Blueprint Designer.

Parent topic: Creating JSON Blueprints

5.2.3.2 Creating a Blueprint from Scratch

Create a new blueprint from scratch based on a sample table with provided columns that enables you to quickly generate sample data. Use Blueprint Designer to add tables to the blueprint after creation.

  1. On the Data Generator home page, click the Create Blueprint button.
    The Create Tables Blueprint wizard appears.
  2. Click From Scratch.
  3. Name - Name the blueprint.
  4. (Optional) Description - Enter a description for the blueprint.
  5. Add Starter Table - (Enabled by default) Enable to add both a sample table populated with sample data and a Custom Data Source object. You can view these in Blueprint Designer.
  6. Click Create Blueprint.
The wizard generates the blueprint. Oracle APEX navigates to the blueprint in Blueprint Designer.

Parent topic: Creating JSON Blueprints

5.2.3.3 Importing a Blueprint

Upload a valid blueprint from a JSON file or copy-paste your JSON data into the required fields.

  1. On the Data Generator home page, click the Create Blueprint button.
    The Create Tables Blueprint wizard appears.
  2. Click Import JSON File.
  3. Do one of the following:
    • Upload a File - (Default) Upload a valid JSON blueprint file.
      1. Drag and drop your blueprint (must be a valid JSON file) into the field, or click Choose File to browse your system for the file.
      2. (Optional) Override Name - Enter a blueprint name to override the value set in the JSON. You must also enable the Replace switch to override the name.
    • Copy and Paste - Input a valid JSON object that you want to generate into a blueprint. This option is useful for iterating between blueprints where you adjust some values in the JSON before creating a blueprint from it.
      1. Enter the Blueprint JSON text.
      2. (Optional) Override Name - Enter a blueprint name to override the value set in the JSON. You must also enable the Replace switch to override the name.
  4. Click Import Blueprint.
The wizard generates the blueprint. Oracle APEX navigates to the blueprint in Blueprint Designer.

Parent topic: Creating JSON Blueprints