After connecting to an OpenEdge database as a regular tenant, accessing data is unchanged.

Connect to an OpenEdge database as a regular tenant, regular_tenant, using the SQL explorer tool:

sqlexp  -user regular_tenant@DomainOne  -password abcd -db sports3000 -S  1234  -H  localhost

Access data from a multi-tenant table, mtcustomer, as shown:

SELECT * FROM Pub.mtcustomer;

The above select statement returns the column values only from the rows in the regular_tenant partition.