top of page
Writer's pictureRajesh S Nair

Features in OpenEdgeE11 and Above

1.OpenEdge Transparent Data Encryption (TDE)

By providing application transparent data encryption, TDE provides both security and performance needs using standard encryption libraries and encryption key management for secure, encrypted data supporting several encryption ciphers (AES, DES, DES-3 & RC4). 


Major Encryption features are as below : >Encrypted backup/restore>Optionally encrypt binary data dump>Encrypt data over time or immediately>No application changes>Full index capabilities on encrypted data Supporting utilities:>Enable/disable>Epolicy manage <area | table> rekey | update | encrypt>Epolicy scanTable/index move w/possible re-encryptionWe can also change encryption policies online.

2.Multi-Tenant Database

A multi-tenant OpenEdge database is a shared database with a shared schema and logically and physically isolated data storage on a per tenant or group basis. Each object (table, index, LOB) is stored in a partition. Partitions keep data physically separate for each tenant. Partitions can exist in the same storage area or different storage areas.  It enables to develop multi-tenant applications by building multi tenant tables into the database. The tenants would share the same schema definition.The data in the database is physically partitioned by tenant identity. For tables that are defined to be multi-tenant, each tenant has its own instance of the multi-tenant table (unless a partition for that table has not been allocated for that tenant). Tenants have access only to the data in the instances designated for that specific tenant as well as to tables that are shared. To enable an OpenEdge database for multi-tenancy from the command line, use the proutil command with the ENABLEMULTITENANCY qualifier.  For example: proutil <dbname> -C enablemultitenancy To programmatically enable an OpenEdge database for multi-tenancy, use OS-COMMAND statement.  For example: DEFINE VARIABLE cCommandLine AS CHARACTER   NO-UNDO.

ASSIGN     cCommandLine = "proutil sportsmt -C enablemultitenancy".

OS-COMMAND SILENT VALUE(cCommandLine).  To check whether an OpenEdge database is enabled for multi-tenancy or not, use the IS-DB-MULTI-TENANT function.  For example: MESSAGE IS-DB-MULTI-TENANT("sportsmt")       VIEW-AS ALERT-BOX INFO BUTTONS OK. To check whether an OpenEdge database table is multi-tenant table, use the IS-MULTI-TENANT attribute of its buffer object handle.  For example: MESSAGE BUFFER Customer:HANDLE:IS-MULTI-TENANT     VIEW-AS ALERT-BOX INFO BUTTONS OK.

3.Utility Enhancements

Roll forwardrfutil <db> -C roll forward  –ailist <ailist- name>Can now specify a list of files to roll forward rather than individual onesAvoids redo on each restartAlso per file completion status info provided dbrestrictRestricts access to the database for processes other than thespecified operation proutil <db> -C dbrestrict [ datamove | rollforward ]                                             [ enable | disable | status] Unlike “oplock”, allows access by certain read-only activities andprostrct addFor “datamove” allows DB Broker, promon & proshut Prorest can enable –dbrestrict too!

172 views0 comments

Recent Posts

See All

Comments


bottom of page