How can I retrieve Ms Access data from my OneWorld application in real-time
You can create a business function to make the ODBC connection, and retrieve data from Access tables as long as you know how to write the code.
Also, there is a starightforward way through JDE Table conversion tool, you can manage the data transfer to and from OneWorld. There is a complete documentation for TC at Oneworld documentation/Technical section.
I’ve created an ODBC to point to an SQL database, and Used the Data Conversion program to look at Foreign Tables. Works like a charm.
*Questions excerpted from ITToolBox.com*
Disclaimer: Contents are not reviewed for correctness and are not endorsed or recommended by PeopleSoft-Planet.com.