Accessing External Data Sources.

paul_gaynor

Member
List,

is it possible to create an application within OW that retrieves
data from a source other than a OW database (ie historical data from a
legacy system). Failing that, what is the best way to give users access to
alternate data sources, preferably without running multiple applications.

Regards
Paul Gaynor

B733 NT, NT, SQL 7
 
Paul :

B7331, B7332 and Xe provide Interoperability tools to process data from
external applications;
If you're on B733 or B732x, you may think on creating a separate SQL
instance containing tables
that you refresh from your legacy system.
That SQL instance may be accessed from a OneWorld Datasource as if it were a
standard one,
of course, you have to create this datasource on OneWorld and all its
related tables as OW
regular objects.
You should also implement a kind of refresh between your legacy system and
this intermediate
SQL database.

Yours, Sebastian Sajaroff
B7321 to Xe, NT, SQL, JAS, Interoperability, Citrix
MCP+I,MCSE,MCDBA,Citrix Admin

-----Mensaje original-----
De: pgaynor [mailto:p[email protected]]
Enviado el: Monday, March 12, 2001 5:51 PM
Para: [email protected]
Asunto: Accessing External Data Sources.



List,

is it possible to create an application within OW that retrieves
data from a source other than a OW database (ie historical data from a
legacy system). Failing that, what is the best way to give users access to
alternate data sources, preferably without running multiple applications.

Regards
Paul Gaynor

B733 NT, NT, SQL 7






--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=
7161
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +



B7321 to Xe, NT/W2K/SQL
JAS, Interoperability
MCDBA,MCP+I,MCSE,Citrix Admin
[email protected]
Grupo ASSA - Application Software SA
 
Applications in OW can retrieve information from any Database at any time.
This does however, require some configuration. What is it that you actually
want to do? Do you want to OW to be able to look up information in another
database or do you want other information frokm a foreign database to exist
in JDE (eg. uploading GL, Sales, AP or AR transactions)?

Just to give an example we have JDE connected to 5 other systems (13
databases). 3 are essentially GL updates from foreign system to JDE, oner is
a link to advanced time and attendance scheduling and the other is a link to
a seperate Assest maintenance and purchase order system.


Colin





Colin Dawes, MSc
City of Guelph
B7332 SP13.1, Oracle 8.1.6, NT 4.0, Fat & WTS
 
Paul,

You might look at using one of the database gateways that are available.

I have worked with the Oracle/AS400-DB2 gateway in the past - it was
initially difficult to configure, but once it was running it cruised!

Any add, delete or mod on a record in either database instantly updated the
other. You could create a file in OW that is gateway'd to your other
database. Then, any adds, deletes or mods your users does are instantly
replicated to the other system.

Yes, there are instances where the record would be locked by users on both
ends - the user that commits first wins. Your programs will have to take
care of letting the 'looser' know - when this takes place.

Daniel Bohner
www.existinglight.net
[email protected]
 
Back
Top