Ever wondered how you are going to go live with your JDE upgrade and have 0 downtime. Ever wondered how you are going to go live with an upgrade and only have a weekend of downtime? GoldenGate might be the solution that you are looking for.
GoldenGate will give you the ability to code real time data conversions into your “pre-upgrade” environment so that they appear in real-time in your upgraded environment. How I hear you asking? Golden gate will give you the ability to code the same “Table Conversion” TC logic into it’s real-time replication scripts. Therefore, when a transaction is inserted into F0911, F4201, F4211 etc. in your XE environment, GoldenGate will execute the equivalent TC logic for each of these tables to ensure that your E9 environment has the committed data also – in real-time. So your XE environment will be kept in synch with your E9 environment… How can you test? Run any integrity you want – one in Xe and one in E9 – it’s that simple!
This gives your ultimate flexibility in how and when you are going to upgrade. Take your time, module at a time or big bang!
from http://www.oracle.com/us/products/middleware/data-integration/059240.html
Oracle GoldenGate moves committed transactions with transaction integrity and minimal overhead on your existing infrastructure. Its wide variety of use cases includes real-time business intelligence; query offloading; zero-downtime upgrades and migrations; disaster recovery; and active-active databases for data distribution, data synchronization and high availability.
The flexibility does not end with the upgrade options, because you can lease the software for the time that you need it.
GoldenGate can be leased yearly at 20% of retail. Myriad have been told that the software can be purchased for $17,500.00 yearly per CPU. This is a super low cost for a no downtime upgrade. Note that there will be costs for consulting to program the TC logic into GoldenGate.
If you want a no downtime upgrade of JDE you need GoldenGate. Currently this product is not certified for AS/400 databases, but it’s on the roadmap.
Of course, GoldenGate is not just limited to JDE upgrades, it could suit ANY scenario that requires real-time replication with complicated logic involvement.
Please contact us for more information.
2 comments:
Hello
I'm having to migrate our JDE8.12 oracle database (10.2.0.4) to new server and storage, we think to use GG, but it seems that GG need that all tables to have a primary key, I don't know if this is mandatory ?
Thank you
I believe that you need a non null, unique identifier - if not a primary key. There are very limited tables in the JDE suite that do not comply to these rules. Perhaps you don't need GG for these limited non-unique tables?
Post a Comment