1. BI Publisher for JD Edwards EnterpriseOne Guide
  2. JDBC Connection String

JDBC Connection String

Setting up JD Edwards EnterpriseOne data access is accomplished by defining a JDBC driver connection string in Oracle BI Publisher. The connection string has a predefined format, but you can append information to enable these additional features:

  • Specify the JD Edwards EnterpriseOne role when connecting to the database.

  • Retrieve table descriptions along with table IDs.

  • Retrieve column descriptions from the data dictionary.

  • Retrieve the associated user defined code (UDC) description for data fields with associated UDCs.

Providing table descriptions, column descriptions, and UDC descriptions simplifies the process of building queries in BI Publisher. Without these descriptions, a report developer must understand JD Edwards EnterpriseOne table schema when designing reports.

The following example shows how table descriptions and column descriptions appear when you use the BI Publisher Query Builder.

Table descriptions and column descriptions in Query Builder.