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.
#####################################################################################
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.
#####################################################################################