Re: PeopleSoft DBA Forum Peoplesoft HR (Oracle 11g) --> Peoplesoft Finance (Oracle 9i) [SEC=UNCLASSIFIED]
- Another option is Materialized Views.I have a split CS 9.0 and HR 9.0 environment with all sorts of data sharing between the two databases:Integration Broker for tables with delivered messagesMaterialized Views for tables with CLOBsDB Linked Synonyms for tables without CLOBsThere are lots of ways to skin this cat!From: "BANKS, Richard" <BanksR@...>
Date: Wed, 14 Nov 2012 05:35:30 +0000
To: "firstname.lastname@example.org" <email@example.com>
Subject: RE: PeopleSoft DBA Forum Peoplesoft HR (Oracle 11g) --> Peoplesoft Finance (Oracle 9i) [SEC=UNCLASSIFIED]
Have you considered PeopleTools Integration Broker, using the delivered enterprise integration point?
I hope you are doing fine today.
We have Peoplesoft HR 9.1 on Oracle database 11g. It is hosted by 3rd party.
We have Peoplesoft Finance 8.4 on Oracle database 9i. This is in house application.
For the Payroll to GL interface we want to bring one table data from Oracle database 11g to Oracle database 9i. This has to happen on regular basis. Both databases are in different network/domain.
Has anyone done this? We need some ideas, ways and approach. Please reply.
Thanks in advance.
Have a nice day and great week.
ashish underscore bhatt at the rate hotmail dot com
This e-mail message (along with any attachments) is intended only for the named addressee and could contain information that is confidential or privileged. If you are not the intended recipient you are notified that any dissemination, copying or use of any of the information is prohibited. Please notify us immediately by return e-mail if you are not the intended recipient and delete all copies of the original message and attachments.
This footnote also confirms that this message has been checked for computer viruses.