Apache&Tomcat vs. IIS

Hi there,

I'm going to test BO E6 and I'm wondering wich http/aplication server would be better  :confused: . We are currently using BO5.1.3/2.6.3 in a W2000 environment with IIS, and the only good reason I've found to change to Apache&Tomcat is that Auditor is not supported with our current web server.

Are there any other advantages / disadvantages of using apache&tomcat and IIS, in terms of functionality, performance and scalability? Any comments would be greatly apreciated.

Thanks in advance


AGRodeja (BOB member since 2002-09-03)

If your a Windows shop, you may have more in-house experience with IIS… being that is a Microsoft product. It takes less fuss to get IIS set-up. Plus both the app and web server are all in one product.

Whereas, Tomcat/Apache is open source…having to rely on the open source community for support(documentation). You need to set up the bridge between the two products (mod_jk.dll) This can be a little tricky.

BO does a good job of supporting either stack… I just had a support call on my Sun OS Apache.Tomcat stack with V6.1 and the lady was able to solve my problem in 15 minutes…

Which one is better? who knows… its like picking chevy or a ford… they both get the job done. :slight_smile:


David Smith :us: (BOB member since 2002-07-10)

If you are a COM shop use IIS if you are a java shop use Apache (assuming you are on Windows servers).

When we upgrade from 5 to 6 we will migrate from IIS to Apache. Not because IIS is not a good platform, because we are a J2EE shop and we will want to incorporate Webi into our in-house development at some point. It also gives me the opportunity for an easy move to a ux machine if our usage begins to raise faster than anticipated.

In the test lab we spun up the IIS and Apache versions and found them to be similar in performance (on the same class of machine) and stability.

Scott


scottpat (BOB member since 2002-08-15)

You are missing a HUGE point here. WebI 6 has more functionality in JSP mode. The whole interactive InfoView is terrific and only works via JSP.

Also, don’t forget that App Foundation is JSP only. The Reporting SDK has a ton more functionality via JSP.

So, if it’s a draw, go via JSP


Steve Krandel :us: (BOB member since 2002-06-25)

:blue: We’re running v6.1 in a Windows 2000 environment with IIS and we just ordered Auditor. Will Auditor not be supported with our setup? Am I reading this right?


Erin Aasted :us: (BOB member since 2002-08-15)

From what I’ve read in the PAR (Product Availability Report), Auditor only works with JSP (Apache and Tomcat) on Windows 2000. Keep in mind that we’re talking just about the GUI interface for Auditor. The reports and universes would still work without using the JSP-based GUI.

The GUI is pretty nice. You can build some nice dashboards.


Steve Krandel :us: (BOB member since 2002-06-25)

We asked our sales rep about Auditor and they said things changed with v6.1. Through v6.0 it was only available in a JSP version, so you were forced to use Apache/Tomcat, but now it can work with IIS. Our system admin is very relieved to hear this. (-:


Erin Aasted :us: (BOB member since 2002-08-15)

Steve, what functionality is not able in Infoview with the IIS platform? I talked to BO people and they told me that functionality was the same in both platforms. Can you give me some examples?

We are not using the SDK at the moment, but I’ll take that into my mind for the future :slight_smile:

Business Objects recommended us using JSP, they said it would be more scalable.

There is something that I found very interesting: we tested BO E6 with apache&tomcat and we noticed that wiqt processes consumed less CPU than in 2.7.x, but tomcat processes were sometimes very active… BO said that this behaviour is normal since now part of the process is done in the application server. Any comments?

Thanks for all the replies!!!


AGRodeja (BOB member since 2002-09-03)

With JSP, you get interactive HTML viewing of a WebI report. You can replace/add/filter columns without ever going to the query panel.

In the Options dialog you set your ā€œviewā€ mode to HTML (interactive). This option is not available in ASP. Other than that, it’s the same.


Steve Krandel :us: (BOB member since 2002-06-25)

I can’t edit, so instead I will quote myself. :lol:

Our sales rep recanted what he told us earlier. He checked into it further and found out that ASP is not currently available for Auditor. Apparently IIS is supported with v6.1, but we would need to use WebLogic 6.1 as the JSP engine. Alternatively, we can switch to an Apache configuration with Tomcat as the JSP engine. :reallymad:

Steve: When you talk about interactive HTML viewing does that only work for reports which were created with Webi? Do you get the same functionality if your reports are created in Full Client and accessed through Webi?


Erin Aasted :us: (BOB member since 2002-08-15)

Only WebI reports have the interactive functionality.

I feel much better now. Not that you won’t be able to use Auditor on ASP, but that I could read the PAR correctly. There are so many products now that the PAR is pretty complex. It’s nice to know I can figure it out.

However, the PAR is pretty clear that Auditor needs Tomat and Apache. It probably works fine with IIS and something else, but BO the supported stack is via Tomcat and Apache.


Steve Krandel :us: (BOB member since 2002-06-25)

Seems we keep beating a dead horse on this Interactive HTML issue. However, I am using W2K SP4 with IIS and I am able to Add/Sort/Filter columns without returning to the query panel screen.

Sure would be nice to have a more definitive answer from BusObj on JSP vs. ASP.


ChadwickHicks :us: (BOB member since 2003-09-22)

What more definitive answer do you need?

Interactive HTML viewing requires JSP.


Steve Krandel :us: (BOB member since 2002-06-25)

Another advantage of JSP is HTML Report Panel.

I like ASP but since the Auditor and AF need JSP i move to JSP. When i moved to JSP i have a problem with togle draft/page mode, so i switch back to ASP and wait whether minor release e6.1a have solved that problem or not.


Hary (BOB member since 2003-03-19)

Steve K,
Is it ill-advised to install Tomcat alongside our IIS6 ASP pages on the same Win2003 server?
We want to turn on Auditor, but since it is only JSP, will we be risking it if we run Infoview & Webi as ASP and Auditor as JSP from the same primary node server?
Steve H.


shic1103 :us: (BOB member since 2003-10-31)

Don’t think that this is a problem.

We bought some products and can download the installation medie for all available platforms, so this shouldn’t be a problem.

Additinal the WIN version should support both, Apache/Tomcat and IIS.

Give it a try.


haupto :de: (BOB member since 2004-04-16)

So, let’s understand what Auditor really does.

Auditor has some terrific universe and some very nice reports. These universes and reports will work just fine with IIS and ASP. If you want the fancy GUI that goes with Auditor, then you need JSP.

I believe that, over time, you’ll grow tired of the fancy interface and simply run the Audit reports and use the universes for ad-hoc. We’ve been running Auditor for years and have never even configured the GUI.

Also, there’s nothing preventing you from implementing Auditor using Tomcat on the exact same server that you have running WebI with IIS/ASP.

Personally, I would run IIS with Tomcat and just use ASP for everything.

We run Apache with Tomcat and are very happy.


Steve Krandel :us: (BOB member since 2002-06-25)

According to the PAR 6.1.3 is not supported with IIS as a web server only 6.5.1, it would be interesting to hear what tech support say about 6.1.3,
Again as an app server you would have to use tomcat or another bridged piece of software. Like you said!

I have a nice doc on bridging IIS6 and tomcat 5 if anyone wants it


komoshon :uk: (BOB member since 2003-07-14)

It would be great if you could email me the doc or post the doc as attachment on BOB.

Thanks


shamit (BOB member since 2004-07-01)

check my posts in this thread :wink:


komoshon :uk: (BOB member since 2003-07-14)