1. How to connect tables from SQL server to Oracle database

    Hi All, 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. Petr
  2. SQL Summary Views (Virtual Tables) and System Impact

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