Using different db vendors for CLM applications
Is it possible to use different db vendor for the different CLM applications?
Specifically, we have the "core" applications (JTS, CCM, QM, DNG) using SQL Server databases; now we are going to install and set up the data warehouse applications (JRS, DCC, LQE), and we'd prefer use Oracle for them.
In addition to being supported, is this scenario also recommended? Or are there any caveats concerning the performances?
Does this configuration work if core and dwh applications run on the same server (and WAS profile), or only if dwh applications are deployed on a different and dedicated application server?
The installed CLM version is 5.0.2.
Specifically, we have the "core" applications (JTS, CCM, QM, DNG) using SQL Server databases; now we are going to install and set up the data warehouse applications (JRS, DCC, LQE), and we'd prefer use Oracle for them.
In addition to being supported, is this scenario also recommended? Or are there any caveats concerning the performances?
Does this configuration work if core and dwh applications run on the same server (and WAS profile), or only if dwh applications are deployed on a different and dedicated application server?
The installed CLM version is 5.0.2.
Accepted answer
I don't see why you couldn't do that. I can't tell if it is supported. It would potentially be an intermediate step if you wanted to switch from one DB vendor to an other.
Is this recommended? I don't think we would recommend to do that. Our recommendation usually is to pick the DB that is supported and you know best.
Each application has its own connection to its DB, as far as I know, so you should be able to individually configure them, regardless of the topology.
However, if you want definitive answers, you should contact support.
Is this recommended? I don't think we would recommend to do that. Our recommendation usually is to pick the DB that is supported and you know best.
Each application has its own connection to its DB, as far as I know, so you should be able to individually configure them, regardless of the topology.
However, if you want definitive answers, you should contact support.