One of the most important new capabilities in OpenEdge 11 is direct support for multi-tenancy in the OpenEdge RDBMS and in the OpenEdge 4GL. In this hands-on workshop we will show you how easy it is to take advantage of this powerful capability. You will see how to use it for your application.

We will show how to use the new and improved CLIENT-PRINCIPAL in a multitenant environment, programming for regular tenants, and programming for supertenants.

This workshop is mostly about programming and only a little about multi-tenant databases.We will focus on basic programming techniques using the 4GL to retrieve and manipulate data in multi-tenant OpenEdge 11 databases. We assume you have a basic knowledge of 4GL programming and at least some ability to use the 4GL to access and modify data in an OpenEdge database.

Note: This workshop was originally created for use in an alrready configured Amazon EC2 image. However, you can use the workshop materials on your own machine as well, if you have the required software installed and the workshop files provided here.

The workshop took about 4 hours, depending on how much the instructor talked, how many students there were, and how many questions there were. Doing it as a self-study exercise should take around half that. The workshop has lecture segments followed by lab exercises and covers the following topics:

  • OpenEdge Multi-tenant Concepts
  • Tenant Data Storage
  • Domains, Tenants, Users
  • 4GL Queries and Data Access
  • Identity Management
  • Supertenants
  • Migrating Data From Existing Databases

To use the materials (lecture slides, student handouts, and lab artifacts zip file), you will need the following:

0) An OpenEdge 11 installation that includes at least

  • Enterprise database
  • Database Multi-tenancy
  • 4GL developent
  • Progress Developer Studio for OpenEdge
  • OpenEdge AppServer Enterprise
  • OpenEdge Management

In our case, we installed OpenEdge on Windows Server 2008 SP2 in EC2. Each student got a machine that was already set up and ready to use.

1) In C:\OpenEdge\WRK\, unpack the attached zip file provided here. You should now have a "workshop" directory with the 4 required files in it. The directions handout tells you which files to use for each lab exercise and to where you will have to copy them.

2) You will need a modern web browser of some sort to use the Database Administration Console (aka DBAC). We have used Chrome.

3) You will need a program text editor of some sort. We used vim. All the programs are fairly short.

The workshop instructions in the student handout are quite detailed and explicit. You should have no trouble following them, apart from doing the setup differently. Have fun.