Hi Shahban.
I only saw this email now. We started using GG here at UniSA for some replication/integration from Campus Solutions to other systems around 2012. I'll pass on your questions to our DBAs since they were the ones doing most of the work & dealing with any issues that we had. I will get back to you as soon as I've heard back.
Regards,
Stephanie.
From: Shahban Riaz [
mailto:anz.heug@list.heug.org]Sent: Monday, 21 September 2015 9:11 AM
To:
anz.heug@list.heug.orgSubject: [anz.heug] - Oracle Golden Gate as Integration Tool
Hi All,
We are currently weighing up if Oracle Golden Gate can be used for real time integration between PeopleSoft and other applications (e.g. black board etc.). I would really appreciate if anyone who have used Oracle Golden Gate as an integration platform between PeopleSoft and other systems can provide feedback on following questions.
1. What is level of complexity involved in using golden gate as real time integration tool in comparison to trigger/push based a sync services?
2. Does golden gate provide data transformation abilities? What type of data transformation abilities does it provide?
3. Can golden gate be used for integration independently or any other products are also required (e.g. Java Message Service, ETL tools etc)?
4. Any additional information that you can share regarding usage of Oracle Golden Gate as integration tool.
Thanks
Regards,
----------------
Shahban Riaz
Team Leader, Student Systems Development
Business Applications,
Technology Services
The University of Adelaide, Australia 5005,
Tel: +61 8 8313 3310
-----End Original Message-----