Business Objects back end data tables
Hello experts -
Is it possible to edit the data directly through SQL server rather than have to go through the CMC on the Business Objects server? I am about to undergo a seriously labor intensive instance duplication project and was hoping there might be an easier way. I would love to be able to edit the tables directly through SSMS.
Does anybody know if this is possible or does SAP have it locked down?
Thank you.
Lisa
Is it possible to edit the data directly through SQL server rather than have to go through the CMC on the Business Objects server? I am about to undergo a seriously labor intensive instance duplication project and was hoping there might be an easier way. I would love to be able to edit the tables directly through SSMS.
Does anybody know if this is possible or does SAP have it locked down?
Thank you.
Lisa
Lowfatspread
if its a SAP system you go via the SAP interface FULLSTOP PERIOD.
Most of the data in the CMS database is binary, so there's not much you can read, much less modify directly. Also, it's a really, really bad idea to mess with your CMS database directly. You run the chance of severely corrupting it.
That being said, you may be able to accomplish what you're looking for through either the Java or .NET SDK or through some sort of third party tool. You might check out APOS. Also, what version of Enterprise are you running? The instance manager in 3.X + is far superior to the one in XIR2 and lower and is much easier to use.
That being said, you may be able to accomplish what you're looking for through either the Java or .NET SDK or through some sort of third party tool. You might check out APOS. Also, what version of Enterprise are you running? The instance manager in 3.X + is far superior to the one in XIR2 and lower and is much easier to use.
ASKER
I am on Business Objects version 12.
I was afraid that would be my answer and that going through the gui was the only way to get there. I was hoping there was a better solution than manually entering the destination path for every report instance I am about to create.
I tried to create a new destination server with the intention of defaulting the new report paths to that server, but I couldn't find a way to choose which destination server I want to use nor could I find a way to use default settings for the destination server when creating the instance.
I was afraid that would be my answer and that going through the gui was the only way to get there. I was hoping there was a better solution than manually entering the destination path for every report instance I am about to create.
I tried to create a new destination server with the intention of defaulting the new report paths to that server, but I couldn't find a way to choose which destination server I want to use nor could I find a way to use default settings for the destination server when creating the instance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I did explore Server Groups, but you are correct in that I would need to upgrade before this is a viable option.
Sigh...looks like I need to get my data entry skill set ready...
Sigh...looks like I need to get my data entry skill set ready...