/
Andi Sample Database

Andi Sample Database

Overview

Andi comes with a school themed sample database that lets you try out all of the examples provided on the Andi Help Center. When creating the tables, you can choose to create them in:

  • Derby - A free database which comes with Andi. By default, the database will be created and can be used.

  • In a database which is currently connected. This would allow you to run the samples using a much larger sized database

Create Sample Tables

  1. Either close all connection panels to use the derby database or connect to the target database where the tables will be created, and have that query panel in the foreground.

  2. Open the Getting Started dialog using the Help->Getting Started menu and the click Next.

image-20250913-094907.png

 

 

NOTE: Andi will automatically use the connection for the visible Query Panel if available. If you want to use the derby database be sure to close your other query panels first.

Choose the database size, either size will work with the derby or your database, both finish quickly. Once you click Load Sample Tables you will be presented with a status bar which will update as the tables load. 

image-20250913-094915.png

Once all tables are loaded you will be presented with the finish panel, which will give  you the derby url that will show up on the Connection Panel.

image-20250913-094920.png

Open the Derby Database

To open the database, click on the "jdbc:derby:andi_db;create=true" url in the Connection Panel and click the Connect button.

To view the tables, you will first have to select the database schema which is APP for the derby database. Choose by clicking on the drop down list as shown and select APP.

image-20250913-094926.png

To Verify your database, open the schema browser and verify the school and chart themed sample tables. You can now use the sample database to learn Andi features. Follow along in Help Center, Database Explorer or Integration Scripting .

image-20250913-094932.png

 

Recreate the Sample Database

In the case where you must recreate your sample database.

  1. Delete the andi_db database by closing Andi and removing the <Andi root Directory>\andi\andi_db\ directory using the file explorer.

  2. Start Andi and delete the "jdbc:derby:andi_db;create=true" url from the Connection panel.

  3. Follow the steps in Create Sample Tables above.