1 Introduction to JD Edwards EnterpriseOne Data Access Tools

This chapter contains the following topics:

1.1 JD Edwards EnterpriseOne Data Access Tools Overview

Oracle's JD Edwards EnterpriseOne Data Access Tools addresses four tools from the Oracle's JD Edwards EnterpriseOne toolset:

  • Oracle's JD Edwards EnterpriseOne Table Design Aid is used to create and modify tables

  • Oracle's JD Edwards EnterpriseOne Cross Reference Facility is used to determine where objects are used in the system

  • Oracle's JD Edwards EnterpriseOne Business View Design Aid is used to create and modify business views

  • Oracle's JD Edwards EnterpriseOne Table Conversion is used to convert tables and copy data between tables

1.2 JD Edwards EnterpriseOne Data Access Tools Implementation Steps

In the planning phase of the implementation, take advantage of all JD Edwards EnterpriseOne sources of information, including the installation guides and troubleshooting information.

The following implementation steps need to be performed before working with JD Edwards EnterpriseOne Data Access Tools:

  1. Set up permissions to access and use Oracle's JD Edwards EnterpriseOne Object Management Workbench (OMW) using Oracle's JD Edwards EnterpriseOne Security Workbench.

    See "Managing Application Security" in the JD Edwards EnterpriseOne Tools Security Administration Guide.

  2. Add yourself to the system in a developer role so that you have permissions to create Oracle's JD Edwards EnterpriseOne objects.

    See "Setting Up User Roles" in the JD Edwards EnterpriseOne Tools Object Management Workbench Guide.

  3. Set up permissions to create OMW projects.

    See "Setting Up Allowed User Actions" in the JD Edwards EnterpriseOne Tools Object Management Workbench Guide.

  4. Set up the appropriate database permissions so that you can add tables to the database, drop tables, and add and modify data.

    Work with the database administrator to set up these permissions.