Forum Post: RE: ODBC and Multi tenant databases

  • Thread starter Thread starter Bill Wood
  • Start date Start date
Status
Not open for further replies.
B

Bill Wood

Guest
The short answer is YES. Data Access via SQL (both ODBC and JDBC) follow the ‘visibility’ rules for the owner of the connection. There is more on this in the documentation: Look at the book on “OpenEdge Data Management: SQL Development” at http://documentation.progress.com/output/OpenEdge114/pdfs/dmsdv/dmsdv.pdf See Chapter 6: Using Data Manipulation Language statements Under SELECT. There are examples that include doing joins across tables with multi-tenancy and how to do this as a DBA or super-tenant. But generally, to get the data for a single tenant you just run the SQL statement with a user from that tenant.

Continue reading...
 
Status
Not open for further replies.
Back
Top