<div>
if its a SAP system you go via the SAP interface FULLSTOP PERIOD.
</div>


<div>
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. &nbsp;You run the chance of severely corrupting it.<br />
<br />
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. &nbsp;You might check out <a href="http://www.apos.com/" rel="ugc">APOS</a>. Also, what version of Enterprise are you running? &nbsp;The instance manager in 3.X + is far superior to the one in XIR2 and lower and is much easier to use.
</div>


<div>
I am on Business Objects version 12.<br />
<br />
I was afraid that would be my answer and that going through the gui was the only way to get there. &nbsp;I was hoping there was a better solution than manually entering the destination path for every report instance I am about to create.<br />
<br />
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.
</div>


<div>
I did explore Server Groups, but you are correct in that I would need to upgrade before this is a viable option. &nbsp;<br />
<br />
Sigh...looks like I need to get my data entry skill set ready...
</div>


<div>
<div class="content wysiwyg-content">
Hello experts - <br />
<br />
Is it possible to edit the data directly through SQL server rather than have to go through the CMC on the Business Objects server? &nbsp;I am about to undergo a seriously labor intensive instance duplication project and was hoping there might be an easier way. &nbsp;I would love to be able to edit the tables directly through SSMS.<br />
<br />
Does anybody know if this is possible or does SAP have it locked down?<br />
<br />
Thank you.<br />
<br />
Lisa
</div>
</div>


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

Business Objects back end data tables

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.