Sunday, January 11, 2009

Connecting to the Business Objects CMS with .NET

Here is some sample code to connect to the Business Objects CMS (Central Management Server) with .NET

Tip:
Please note that the QueryBuilder SQL will return a maximum of 1000 records even if there are more to be returned. So logic should be included that if 1000 sorted records are returned, you should requery to retrieve missed records or until a recordset with less than 1000 returned records occurs.

This sample is a .NET 3.5 application.

Create a simple project and add references to
CrystalDecisions.Enterprise
CrystalDecisions.Enterprise.Framework
CrystalDecisions.Enterprise.InfoStore

Sample Code:

using System;
using CrystalDecisions.Enterprise;

namespace ConsoleAConnection
{

class Program
{
static void Main(string[] args)
{
string query = "Select SI_ID,SI_KIND,SI_NAME,SI_PARENT_FOLDER FROM CI_INFOOBJECTS WHERE SI_KIND IN ('Folder','FavoritesFolder')";

InfoObjects infoObjects = getCMCConnection().Query(query);
if (infoObjects.Count > 0)
{
foreach (InfoObject infoObject in infoObjects)
{
string siId = "" + infoObject.Properties["SI_ID"] + ":" + infoObject.Properties.Count;
Console.WriteLine("SI_ID=" + siId);
}
}
else
{
Console.WriteLine("No results found for " + query);
}
}

static InfoStore getCMCConnection()
{
SessionMgr sessionMgr = new SessionMgr();
EnterpriseSession enterpriseSession = sessionMgr.Logon("UserName", "Password", "ServerName", "secEnterprise");
EnterpriseService enterpriseService = enterpriseSession.GetService("InfoStore");
InfoStore infoStore = new InfoStore(enterpriseService);
return infoStore;
}
}
}

25 comments:

CMS DESIGN said...

Thanks for the posts we are the professional web design and development company offering an array of services like template customization,web designing, CMS solutions, eCommerce solutions, Search engine optimization and Internet marketing.
CMS DESIGN

Anonymous said...

Howdy superb website! Does running a blog like this take a lot of work?
I've absolutely no knowledge of programming but I had been hoping to start my own blog in the near future. Anyways, should you have any ideas or tips for new blog owners please share. I know this is off topic nevertheless I simply wanted to ask. Kudos!

Also visit my web-site: graphic Design

Anonymous said...

I have been browsing online greater than 3 hours as of late,
but I by no means found any interesting article like yours.

It's pretty worth sufficient for me. In my view, if all web owners and bloggers made just right content as you did, the internet shall be a lot more useful than ever before.

my homepage interior Designs Johannesburg building renovations Johannesburg

Anonymous said...

Keep on writing, great job!

My page - ppe Johannesburg

Anonymous said...

Hi there, I found your site by way of Google at the same time as searching for a comparable topic, your
web site got here up, it seems good. I have bookmarked it
in my google bookmarks.
Hi there, just was alert to your weblog through Google, and
found that it's truly informative. I'm gonna be careful for brussels.
I'll appreciate for those who proceed this in future. Lots of other folks will likely be benefited out of your writing. Cheers!

Here is my site ... pc repairs Johannesburg

Anonymous said...

Usually I do not read post on blogs, but I wish to say that this write-up very
compelled me to take a look at and do so! Your writing taste has been amazed me.
Thanks, very nice post.

Here is my web blog :: Residential Property Auctions

Anonymous said...

I'm not sure where you're getting your information, but great topic.
I needs to spend some time learning much more or understanding more.
Thanks for magnificent information I was looking for this information for my mission.


My weblog ... professional accounting

Anonymous said...

Hello everyone, it's my first pay a quick visit at this website, and paragraph is actually fruitful designed for me, keep up posting these articles.

My webpage acoustic guitar chord

Anonymous said...

Hey there outstanding blog! Does running a blog
similar to this take a great deal of work? I've no understanding of programming however I was hoping to start my own blog in the near future. Anyway, if you have any ideas or tips for new blog owners please share. I know this is off topic but I just needed to ask. Thank you!

Here is my webpage: click the site

Anonymous said...

Link exchange is nothing else except it is just placing the other person's web site link on your page at appropriate place and other person will also do similar in support of you.

Also visit my web-site :: click this site

Anonymous said...

Great post. I am going through many of these
issues as well..

Also visit my web-site :: More information

Anonymous said...

This blog was... how do I say it? Relevant!! Finally I've found something which helped me. Cheers!

my blog post :: Visit here

Anonymous said...

Thanks for finally writing about > "Connecting to the Business Objects CMS with .NET" < Liked it!

my site - visit this site

Anonymous said...

Thanks for ones marvelous posting! I really enjoyed reading it, you might be a great author.
I will be sure to bookmark your blog and may come back in the
future. I want to encourage one to continue your great work,
have a nice morning!

My site; click the site

Anonymous said...

Wonderful article! This is the type of information that are meant to be shared around the web.

Disgrace on the search engines for not positioning this submit upper!

Come on over and discuss with my site . Thanks =)

Also visit my page; click the site

Anonymous said...

Heya i'm for the primary time here. I came across this board and I to find It truly helpful & it helped me out a lot. I hope to offer something back and aid others such as you helped me.

Take a look at my page: http://www.thenailguru.co.za

Anonymous said...

I have read your blog and i got a very useful and knowledgeable information from your blog.Its really a very nice article.You have done a great job .Thank you so much for sharing.
website design

Anonymous said...

There might be situations where you might feel that it won't be difficult in choosing a cheap dentist in plano tx here. You see, when there is a chance for a mess up in your procedure as well. All these procedures are completed in just a couple of days post-whitening. How good is the smile on the faces of thousands! In these consultations with parents, it's apparent that
they are affixeded to the tooth, which can affect their look.


my site - plano dentist in west

Anonymous said...

Good post. I learn new things and challenging on sites I stumbleupon on a daily basis.

It's always exciting to learn content from other writers and use something due to their websites.


my homepage - password hacker

Anonymous said...

gucci belts
Hello, I think your website may be having web browser compatibility problems.
When I look at your web site in Safari, it looks fine however,
when opening in Internet Explorer, it's got some overlapping issues.
I merely wanted to give you a quick heads up! Aside from that, excellent site!

Anonymous said...

I am not sure where you're getting your info, but great topic.
I needs to spend some time learning much more or understanding more.
Thanks for wonderful info I was looking for this info for my mission.

My blog post; Virility EX Enhancement (faziiie.blogspot.co.il)

Anonymous said...

Excellent blog you have here.. It's hard to find high-quality writing like yours these
days. I seriously appreciate individuals like you! Take care!!


Stop by my webpage Stress Relief Techniques

Anonymous said...

Hi there! This blog post could not be written any better!
Going through this post reminds me of my previous roommate!
He continually kept talking about this. I'll forward this
information to him. Pretty sure he's going to have a great read.
Many thanks for sharing!

Here is my webpage; guillermo valls

Unknown said...


Nice Posting! because there are a lot of informative postings so, thanks a lot for sharing the information. Ecommerce website Designing in Mumbai || Ecommerce Solution || Ecommerce Solution in Mumbai

Desain Interior Kamar Mandi Minimalis said...

Thanks so much with this fantastic new web site. I’m very fired up to show it to anyone. It makes me so satisfied your vast understanding and wisdom have a new channel for trying into the world.