Infrastructure at your Service

 
Daniel Westermann

Real time replication from Oracle to PostgreSQL using Data Replicator from DBPLUS

By | Database Administration & Monitoring | No Comments

I’ve done quite some real time logical replication projects in the past, either using Oracle Golden Gate or EDB replication server. Build in logical replication in PostgreSQL (which is available since PostgreSQL 10) can be used as well when both, the source and the target are PostgreSQL instances. While being at the DOAG conference and exhibition 2019 I got in contact with people from DBPLUS and they provide a product which is called “Data Replicator”….

Read More
Morgan Patou

AEM Forms – FIPS 140-2 Support

By | Application integration & Middleware | No Comments

Around summer last year, one of the project I was working on started a new integration with AEM Forms for Digital Signatures and Reader Extension components. It was already using AEM Forms before but for other purposes. With this new requirement came new problems (obviously). This project was still using AEM Forms 6.4 JEE on WebLogic Server 12.2.1.3. As mentioned a few times already, our policy is always security by default, unless the customer has…

Read More
Morgan Patou

Documentum – FQDN Validation on RCS/CFS

By | Application integration & Middleware, Entreprise content management | No Comments

In a previous blog, I talked about the possible usage of K8s Services in place of the default headless/pod name and the issues that it brings. This one can be seen as a continuation since it is also related to the usage of K8s Services to install Documentum but this time with another issue that is specific to a RCS/CFS. This issue & solution might be interesting for you, even if you aren’t using K8s….

Read More
Morgan Patou

Documentum – Usage of K8s Services to install Documentum?

By | Application integration & Middleware, Entreprise content management | No Comments

In the past several months, we have been extensively working on setting up a CI/CD pipeline for Documentum at one of our customer. As part of this project, we are using Kubernetes pods for Documentum components. In this blog, I will talk about an issue caused by what seemed like a good idea but finally, not so much… The goal of this project is to migrate dozens of Documentum environments and several hundred of VMs…

Read More
Morgan Patou

Documentum – Database password validation rule in 16.4

By | Application integration & Middleware, Entreprise content management | No Comments

A few months ago, I started working with the CS 16.4 (always using silent installation) and I had the pleasant surprise to see a new error message in the installation log. It’s always such a pleasure to lose time on pretty stupid things like the one I will talk about in this blog. So what’s the issue? Well upon installing a new repository, I saw an error message around the start of the silent installation….

Read More
Jérôme Dubar

Focus on 19c NOW!

By | Database Administration & Monitoring, Database management, Oracle | No Comments

Introduction For years, Oracle used the same mechanism for database versioning. A major version, represented by the first number. And then a release number, 1 for the very first edition, and a mature and reliable release 2 for production databases. Both of them having patchsets (the last number) and regular patchset updates (the date optionally displayed at the end) to remove bugs and to increase security. Jumping from release 1 to release 2 required a…

Read More
Daniel Westermann

Enabling, disabling, and validating foreign key constraints in PostgreSQL

By | Database Administration & Monitoring | No Comments

Constraints are in important concept in every realtional database system and they guarantee the correctness of your data. While constraints are essentials there are situations when it is required to disable or drop them temporarily. The reason could be performance related because it is faster to validate the constraints at once after a data load. The reason could also be, that you need to load data and you do not know if the data is…

Read More