Results 1 to 3 of 3

Thread: using JDBJ to connect application data

  1. #1

    Question using JDBJ to connect application data

    Hi , i am a not a JDE specialist, and work as an architect to build data integration solutions. We are building a solution by using JDBJ to read data from JDE. Our solution will be used by many customers who may have different types of database (Oracle, SQL Server, UDB, AS400 etc).

    since we use JDBJ, will my solution work seamlessly across all environments independent of the type of backend database used. provided that we configure the JDBJ related ini files appropriately pointing to the right database drivers.

  2. #2
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,247
    That really depends on how good your solution ends up being.
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  3. #3
    Member
    Join Date
    Dec 2000
    Location
    Australia
    Posts
    584
    I suggest you use the Data Access Driver (DAD) instead of trying to use JDBJ calls directly.

    See: https://docs.oracle.com/cd/E53430_01...htm#EOTIN00457

    Since your requirement is read-only the DAD should meet your needs, i.e. a read-only view of JDE data with all the conversion such as decimals and Julian date conversion done for you. It ultimately uses JDBJ but I feel it is a more supported route than using JDBJ directly.

    You should be able to query JDE data on the platforms/database versions support by the tools release for the DAD and associate JARs that you make use of.
    Justin Miller

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.