Setting Up Data Sources

This chapter provides an overview of data sources and logic data sources and discusses how to:

• Set up data source

• Add or modify a data source

• Set processing options for database and logical data sources

• Add or modify the Release/Data Source Map table

Understanding Data Source Set Up

The data sources are the building blocks of your configuration, therefore, the proper identification of all required data sources is critical to having a correct configuration to support your business needs.

The database data sources and logical data sources applications enable you add or modify a database data source or logic data source, respectively. After you add a new data source, you must update the Release/Data Source Map table (F00948) using the Release/Data Source Map application.

Understanding Planning for Data Sources

It is important for you to plan for data sources. The proper identification of all required data sources is critical to having a correct configuration that supports the needs of the business. Be sure to include all machines and all databases in your enterprise.

To plan your data sources:

1. Evaluate the location of the system data.

2. Identify all of the enterprise servers in the configuration that will host logic:

   1. Set up one distributed processing data source for each enterprise logic server.

   2. Set up one Server Map data source for each distributed processing data source.

3. Evaluate how many groups of Oracle's JD Edwards EnterpriseOne objects you require to support the business environment, such as production, pristine, and development. Set up one Central Objects data source for each group of objects.

4. Evaluate the various locations of the business data:

   1. Set up one Business Data data source for each database and library that contains Business Data tables that JD Edwards EnterpriseOne applications use.

   2. Set up one Control Table data source for production and one for testing.

Understanding Setting Up Data Source Definitions

These data source types require just one data source definition for each release:

• Object Librarian

• System

• Data Dictionary

• Local

These data source types might require you to define multiple data sources for each type to support the business requirements:

• Business Data (production, test, CRP, and PS900 demo data)

• Distributed Processing (one per logic server)

• Server Map (one per logic server)

• Central Objects (one per path code)

• Control Tables

Understanding Data Source Naming Conventions

When you add data sources, observe these naming conventions:

• Limit to 30 characters

• Text is case sensitive

• Text is space sensitive

Specific exceptions for the Client Access data source are listed in the Client Access Data Source Name section.

Understanding Client Access Data Source Names

The names of Client Access data sources must conform to these standards:

• Limit to 32 characters

• Begin with an alphabetic character

• Do not use these characters: { } [ ] ( ) ? * = ! @ ;

  Note. You must type the data source name before you can use the Client Access ODBC driver to access iSeries data.

Understanding Table Owner (Object Owner ID)

Oracle and SQL Server database management systems have unique table owner IDs for each group of tables. For example, the database that contains the system tables might have an owner such as E900SYS. You must identify the table owner ID for Oracle and SQL Server database management systems.

Adding or Modifying a Database or Logical Data Source

This section lists the prerequisites and discusses how to modify an existing database data source.

Prerequisites

Before you complete the tasks in this section, you should plan for the data sources.

Forms Used to Add or Modify a Database or Logical Data Source

Adding or Modifying a Database Data Source

Access the Data Source Revisions form.

Data Source Revisions Form Fields

Use these processing options to set up the form fields for your data source.

SQL ODBC

Use these processing options to set up parameters for a SQL ODBC database.

SQL OLEDB

Use these processing options to set up parameters for a SQLOLEDB database.

Oracle

Use these processing options to set up parameters for an Oracle database.

DB2 OS400

Use these options to set up parameters for a DB2 OS400 database.

DB2 UDB

Use these options to set up parameters for a DB2 UDB database.

Access

Use these options to set up parameters for an Access database.

Logical

Setting Processing Options for Database or Logical Data Sources

These options enable you to specify the default processing for programs and reports.

Defaults

Use these options to specify a local (database) data source or a server data source and to indicate whether you want to create an ODBC data source when the Workstation Installation program (P986115) runs.

Modifying the Release/Data Source Map Table

This sections provides an overview of the Release/Data Source Map table and discusses how to modify the Release/Data Source Map table.

Understanding the Release/Data Source Map Table

The Release/Data Source Map program (P00948) enables you to define the release level for a data source for a data source type. When you add a new data source, you need to update the Release/Data Source Map table (F00948). This table contains entries for the data dictionary, Object Librarian, versions lists, and workflow, and organizes the entries according to release.

When you copy or transfer objects between data sources, the software checks the release of each data source and then determines whether the source data source and the target data source reside in compatible releases. If Unicode conversion is needed (for example, transfer from an Xe version to a JD Edwards EnterpriseOne 8.10 version), the software converts the data for you when you are using a release of JD Edwards EnterpriseOne 8.10 or greater.

The software does not allow you to move or copy objects between data sources with incompatible releases. When you add a data source, if a record is already found in the Release/Data Source Map table for the data structure and data type entered, the system displays an error. You can only have one release level defined for a data source per data type.

Form Used to Modify the Release/Data Source Map Table

Adding or Modifying the Release/Data Source Map Table

Access the Database Object Sizing form.

Data Source Type	Specify this is the type of object contained in the indicated data source.
Data Source	Specify the name that identifies the data source
Release	Specify the release number identified in the Release Master.
UserID	Identify the user profile.
WorkstationID	Identify the workstation ID that executed a particular job.
ProgramID	Identify the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210 and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to structured syntax in the form TSXXX, where: T = The first character of the number is alphabetic and identifies the type, such as P for Program, R for report, and so on. For example, the value P in the number P4210 indicated that the object is a program. SS = The second and third characters of the number is numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX = The remaining characters of the number are numeric and identify a unique program or report. fFor example, the value 10 in the number P4210 indicates that this is the Sales Order Entry Program.
Date Updated	The date that specifies the last update to the file record.
Time Updated	The time the object was last checked in.

Important! If you want to view the data sources without adding or changing one, ensure that you exit from the Data Source Revisions form and click Cancel instead of OK. When you click OK, the system assumes that you have added or changed a data source, and the existing ODBC drivers might not work correctly. You will have to modify them using the ODBC Data Source Administrator applet accessible from the Control Panel.

Setting Advanced Options for Release/Data Source Map Revisions

The Advanced form displays options that are related to the data source type being configured.

Advanced

Use these form exit options to set up additional options.