BusinessObjects Board

How can I descrypt the CMS_Infoobjects7 BOE140 metadata

Hello, i need your helps.
I want decode the CMS_Infoobjects7 from BOE140 into a new relational Table.
We work with Java-Eclipse. It´s there any way to descrypt the datas from the CMS_Infoobjects7 ? How can i do that ?
Because there a lots of a row of numbers that i dont know, what are these.
Maybe LastModiyfiyTimes oder Type Id.

I want descrypt the data with Java and take the important data that desrypted into a new Table…

Please Help me


veltron (BOB member since 2014-11-12)

can someone help us :slight_smile:


veltron (BOB member since 2014-11-12)

Very much doubt this is possible without the decryption algorithm.


Mak 1 :uk: (BOB member since 2005-01-06)

Welcome to B:bob:B!

Moderator note:
Please do not bump your post until at least one business day has passed.


Marek Chladny :slovakia: (BOB member since 2003-11-27)

How can i do that ?


veltron (BOB member since 2014-11-12)

As I was trying to suggest you can’t do it.

http://scn.sap.com/thread/3497415


Mak 1 :uk: (BOB member since 2005-01-06)

Hi,

As far as I know, the decryption algorithm is not widely known information. Those who know how to decrypt CMS database data set their business model based on that. Meaning, there are 3rd party tools (paid tools) that can extract and decrypt CMS data for you.


Marek Chladny :slovakia: (BOB member since 2003-11-27)

So i have no chance to know which and what data these are ?
I can do nothing with the whole numbers :frowning:


veltron (BOB member since 2014-11-12)

The only chance you have is to invest in a paid for tool.


Mak 1 :uk: (BOB member since 2005-01-06)

I have query that does this, am I allowed to post it here?


craiggsmith (BOB member since 2009-06-01)

Hi,

I believe, that if it’s a result of your own analysis / investigation then why not if you want to share your work here. However, if it’s not yours and you took from somewhere then please take into consideration possible copyright infringement. Please read also these part of the BOB rules and guidelines:
https://bobj-board.org/tos#heading--copyright

Thanks.


Marek Chladny :slovakia: (BOB member since 2003-11-27)

It’s a sql query I found in either this forum or another or somewhere on the web, and then modified a little. There was no mention of copyright, but I wish I could find where I got it from so I could at least give credit. And of course I don’t know where they got it from. I had found it while searching for ways to restore deleted reports; it helped me find the wid files in the filestore backup.


craiggsmith (BOB member since 2009-06-01)

Hi Craig,

I’m interested in how this handles the encryption.

Cheers,

Mark.


Mak 1 :uk: (BOB member since 2005-01-06)

also have a look here :


bernard timbal :fr: (BOB member since 2003-05-26)

Well done Benard, that must be the script.
Its is worrying that it can be done, god knows how the guy worked it out :mrgreen: .


Mak 1 :uk: (BOB member since 2005-01-06)

That isn’t the exact one that I had found but looks the same.


craiggsmith (BOB member since 2009-06-01)