1. Table Conversion Guide
  2. Table Conversions

Table Conversions

Table conversion is a type of batch process that enables you to rapidly manipulate the data in tables. This table describes the conversion types that the Oracle's JD Edwards EnterpriseOne Table Conversion tool uses to manipulate data:

Conversion Type

Description

Data Conversion

Enables you to transfer or copy data from an input table or business view into output tables using the logic that is necessary to perform the transfer. You can also use Data Conversion to update records in a table or business view.

Data Copy

Enables you to copy tables from one data source or environment to another data source or environment when the tables are identical.

Data Copy with Table Input

Enables you to copy tables based on information from an input table. For example, the input table might provide information about which tables are copied, where they are copied, and so on.

Batch Delete

Enables you to delete records from a table or business view.

The JD Edwards EnterpriseOne Table Conversion tool uses Oracle's JD Edwards EnterpriseOne tables, business views, and text files. The tool can also use non-JD Edwards EnterpriseOne tables, also referred to as foreign tables, as long as they reside in a database that is supported by JD Edwards EnterpriseOne software, such as:

  • Oracle

  • Access

  • IBM i

  • SQL Server

When creating a table conversion, you:

  • Set up a table conversion template.

  • Review the template.

  • Create versions of the template.

    Like batch applications, table conversions include a template and versions. You can override some of the properties within a version at runtime.

  • Process the table conversion.

    Table conversions can be saved and run multiple times. You can test the table conversion by running it in proof mode.

Oracle's JD Edwards EnterpriseOne Table Conversion Design Aid enables you to access any available environment for both input and output. The environments that you select determine which tables and business views are available for the conversion and where the tables reside. The environments that you select also determine the specifications, or descriptions, of tables and business views.