The department works closely with other agencies to drive the State’s research, science, innovation, technology, intellectual property and service delivery.

The Needs / Challenges

• Replicate HR databases in Oracle VM to SQL Server for reporting purposes using MS Power Bi
• Needed to support Oracle 12c for Multitenant Architecture, TDE Encryption and Oracle Containers
• Ran a comparison of Attunity Replicate, Oracle Golden Gate and HVR to see which best met their needs
• Timely full load
• Real time change data capture with minimal impact on production systems
• Replicate DDL changes
• Easily configurable and scalable for other technology use cases in future

The Solution  

• Attunity Replicate – Oracle to SQL Server targets – Replicate supported Oracle TDE Encryption as well as Oracle Containers.

The Results

After testing Oracle Golden Gate, HVR and Attunity Replicate, as well as considering Informatica (as both Informatica and Attunity had been recommended by Gartner), the organisation chose Attunity for its ease of use, timely support and scalability.