JDE OneWorld ODA Information?

msuters

msuters

Active Member
Hi all,

Can anybody direct me to a "good" explanation of the JDE OneWorld ODA
data source? I'm interested in using the JDE OneWorld ODA data source to
allow end users to access the tables in Peoplesoft, so they can use
Excel to do ad-hoc reporting.

So far, I have identified the following information or features:

1. JDE OneWorld ODA is an ODBC data source, installed with the
Peoplesoft client, which allows access to the Peoplesoft tables.
2. As part of the access process, the user's account is authenticated.
3. Data access is managed by the PSE security tables.
4. Data is accessed through the views which exist in PSE (which are
usually created for report writing)

One negative is that views and tables don't always match up. However,
custom views could be created for the tables people are actually
interested in accessing.

The information above has been gathered through trial and error, and I
haven't been able to find a comprehensive explanation of the JDE
OneWorld ODA connector. Before encouraging widespread use of this item,
I'd like to be standing on a slightly firmer base. Can anybody point me
in the right direction?

Thanks,
Mark Suters

PSE 8, Update 1, SP22_S1, Windows 2000, SQL Server 2000, Citrix
Metaframe XP, Formscape
#####################################################################################
Note:
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege
is waived or lost by any mistransmission. If you receive this message in error,
please immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender. You must not, directly or indirectly,
use, disclose, distribute, print, or copy any part of this message if you are not
the intended recipient. Stockland and any of its subsidiaries each reserve
the right to monitor all e-mail communications through its networks.

Any views expressed in this message are those of the individual sender, except where
the message states otherwise and the sender is authorized to state them to be the
views of any such entity.

Thank You.
#####################################################################################
 
Hi There

Let me add some info..

1. (negative) It is not possible to create "Parameter queries" using ODA i.e queries where the selection criteria is entered by user on runtime in a dialog box. All queries must be "hardcoded" in the query design
PeopleSoft stated (last year) that this is not likely to be fixed in near future as the problem is "architectural" and hard to fix.

2. Date columns are translated from Julian to "Normal" dates

3. When a column with UDC validation is shown, the UDC description can also be shown in the query (without user having to create a join to F0004/5)

4. Long column names (DD descriptions) are shown in the column headers
in stead of just the aliases (as with ODBC)

5. It is possible to show the tables using table descriptions, rather than just the names ("Item Ledger table" in stead of "F4111") when queries are constructed and tables are added to it.

6. Numeric columns are correctly formatted, based on the "display decimals" data dictionary setting


Regards...
 
Re: RE: JDE OneWorld ODA Information?

Andy, I would like a copy also. We have been trying to use ODA but continually have problems. Thanks again

Tim Mackin [email protected]
 
Re: RE: JDE OneWorld ODA Information?

Andy, could you send me that article on ODA? TIA
 
Re: RE: JDE OneWorld ODA Information?

Hi Andy,

If you still have access to this paper, I would really find it useful!!

Joe
 
Re: RE: JDE OneWorld ODA Information?

Hi, Andy.

Appreciate if you can send me the tips too. Thanks.

Regards
WWS
 
Another positive, it gives read-only access to the data vs. the other odbc's which would allow update. If you are contemplating any ODBC access to the database other than ODA, make sure the data is secured properly through the backend database tools.
 
Back
Top