We have this issue. We have JDE E920 on Oracle database running on AIX and need to make select to some tables on SQL server.
My idea is to make a DB view and fake E1 table. But I don´t know, how to make connection to SQL server from Oracle database...
Thanks for help.
Someone else has done this - so I'm looking for feedback and insight....
File Structure looks like this:
A - Header Table
1 - Detail 1 Table
b - Detail of Detail 1 Table
We have several Applications and Reports - that summarize the Detail and the 'Detail of Detail' - and due to the...