Dear All,
I am working in a project, where we have multiple systems for different departments. For HR it is Peoplesoft with SQL Server DB and for facilities it is Oracle DB, we both are in the same network in the organization.
I am the developer in the Oracle DB system and we have couple of Interfaces(procedures) running over the night by Jobs to pull the data from Peoplesoft HR system into our Oracle DB.
My Question is, in the interfaces we selecting the data from the Peoplesoft db tables through oracle db( Normally, I use SQL Developer to run the queries).
1) What are the privileges / access /steps to be given to the Oracle DB user in order to access the other db tables and what are the steps.
2) If Peoplesoft (SQL SERVER) wants the data from our system(Oracle DB), what are the required steps or procedure to follow to give the access.
3) And the main, how Oracle is communicating / selecting the data from the SQL Server DB and vice a versa.
Requesting you all to clarify, Apologies if am not clear in explanation.
Thank you all in advance.
I am on Oracle 11g(11.2.0.2) - 64Bit.