OpenEdge RDBMS provides two Data tools to perform database administration tasks:

  • Data Administration (for Windows)
  • Data Dictionary (for UNIX)
  • With these tools, you can perform the following database administration tasks:
  • Perform schema changes.
  • Dump and load data definitions, table contents, sequences, and sequence values.
  • Dump and load user table contents, security domains, security permissions, and database identification properties.
  • Dump and load audit policies and audit data, if OpenEdge auditing is used.
  • Dump and load definitions and data for table partitions, partition policies, and partition policy details, if OpenEdge Table Partitioning is used.
  • Dump and load definitions and data for tenants and tenant groups, if OpenEdge Multi-tenancy is used.
  • Dump and load SQL objects and data, if OpenEdge SQL is used.
  • Edit data security.
  • Configure user security, domains, and authentication systems.
  • Configure encryption policies for objects in an encryption-enabled database.
Note: Data Administration and Data Dictionary are an integral part of OpenEdge RDBMS; they do not require a separate license.

Next, you will learn how to launch and then navigate within each of these tools.