SAP BO 4.3 CMS Repository Driver & universe

[Luke_D]

We recently upgraded from 4.2 SP9 to 4.3 SP2. (LINUX) One of our new efforts involves the use of the CMS driver & Universe to develop reports/schedules to automate some of our manual AdminTool Queries. However, I'm not able to locate the driver nor universe in the install directories mentioned.

To me this implies the component wasn't selected during the upgrade processes. Could there be other alternatives for this?

Could someone point me to a SAP note related to 4.3 or 4.x which covers the component install which provides instructions for the installation/configuration of this feature? I keep getting references to a wiki this is woefully incomplete.

https://wiki.scn.sap.com/wiki/display/BOBJ/Unlock+the+CMS+database+with+new+data+access+driver+for+B... CMS DB Driver Yeah! (coming soon as of 12/13/2016...)

I also found:

https://answers.sap.com/questions/697793/how-to-check-if-the-cms-database-driver-is-install.html which seems to indicate the driver is installed with the product... products installed and working; just missing some expected features... so I'm guessing a full install wasn't done; and now I need to find instructions for adding the missing components...

https://archive.sap.com/documents/docs/DOC-74363 which seems specific to 4.2 SP3 not 4.x or 4.3 and the more details just point back to the wiki..

Notes:

• Universe/Driver not in expected paths (paths don't exist)
• When attempting to create a new universe/connection, the CMS Driver isn't lilsted.

[Luke_D]

I know the CMS driver was released in 4.2 SP03. We did not use the driver (or perhaps not even have it installed) in our 4.2SP9 environment. It was my undersstanding in a 4.3 full install it would be there; but we can't find it.

Universe details found locally on IDT install of 4.3. But not the driver... for selection/configuraiton for the universe.

[Luke_D]

Just a status: We're yet unable to find the driver. I'm not the server admin, have no access to the LINUX box so I'm working with the Admin group to try and "Add/Remove" programs to see if we can get the CMS Driver from the SAP install package as a component we are able to find drivers from an IDT install; but I'm not sure if I should move those from a windows machine to LINUX or use the "Add/Remove" programs in linux as mentioned by Denis. I'm thinking the latter, but I'm having trouble

Thanks for the help on the universe and pointers on where to get the driver; but I want to ensure the presented solutions solve the problem before accepting answers.

[Luke_D]

I'd like to say we have this addressed but so far we have the universe; but I can't direct the Admin to the needed driver. So no "Accepted" answer yet...

[arno_huerlimann]

Is there a solution now?

[denis_konovalov]

This feature is not installed by upgrades automatically.
If it wasn't enabled in your 4.2 install it won't be in 4.3.
You need to run AddOrRemoveProduct.sh, select modify and then select CMS DB driver and all related options. (do not unselect anything already selected as it will remove them and take snapshot of the server before running).

[Luke_D]

Just confirming: Even on a full install of 4.3? I could understand if it wasn't a full install but, I would have thought a full install as outlined https://help.sap.com/doc/46b1602a6e041014910aba7db0e91070/4.3/en-US/sbo43_bip_inst_unix_en.pdf would have included all components and features. (page 51, section 5.4.1 "FULL"

Ahh.. I see "Installs all required server components" since it wasn't "Required" since it wasn't there before, it doesn't install it.

[denis_konovalov]

full install should have it by default, as far as I know. But I haven't tested that.

[Luke_D]

I suppose I'll know in a bit. This was very insightful and helpful. Thank you. I'll come back and accept answers once I've been able to prove them out.

[Luke_D]

Our upgrade to 4.3 put this on the back burner; I'll be looking closer at this in the next few weeks.

[omacoder]

This doesn't address your question, but it addresses your business issue.

We gave up on the CMS Universe/driver as it was still difficult to manipulate the data the way we needed to, and some properties aren't (or were not, at the time) exposed that we required.

We just wrote a simple .NET utility that pulls changes from the CMS database and persists them to a table on SQL Server. We do delta's every 15 minutes to get info on scheduled reports, and then do a full load at night to catch any deletes. There's lots of code online if you have any dev experience.

[Luke_D]

Do you know if the driver has remained the same from 4.2SP3 to 4.3SP2? I was hoping to see some enhancements in that area and not go down the path you've mentioned. I'm just starting this path and needed to see/use the driver 1st hand to know if it will have what we need. Logically if I can find it though AdminTools, I'd expect to be able to do it through the universe; but maybe that's not the case.

[omacoder]

I'm not sure if they've added functionality to the driver.

[Luke_D]

Fair enough, I need to see what's available to make a decision still. I just hope it's what I can get from AdminTools.

[TJe]

You should find the universe in the BOE installation:
Sample Universe BI Platform CMS System Database Sample.lcmbiar imported from <BOE folder>\SAP BusinessObjects Enterprise XI 4.0\Samples\bionbi\

[Luke_D]

Locally yes I can find that file for the universe thanks. I have yet to find out how to get the driver for the CMS database.

[TJe]

Hopefully this information from the wiki helps:
https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=452559631

2405568 - When install the BI 4.2 SP03 by “Custom/Expand”, there is no SAP BI platform CMS system da...

(Installing a patch on SP03 may uninstall the CMS DB driver, this note describes the behaviour and the solution to reinstall the CMS DB Driver)

[Luke_D]

Sadly no. KB article 2405568 is for windows and 4.2SP3 install: and thus not applicable to our current 4.3SP2 enviornment unless I don't understand the install processes.

It was my understanding in the 4.3 install "Full install" type, the install would include the CMS driver; but we're unable to see it when attempting to add a connection to the universe found in the IDT install path you mentioned in other response.