by XTIVIA | Aug 21, 2012 | Blog, Business Intelligence, Data Warehousing, Portals
A requirement that is often found in enterprise IT environments is the need for “dashboards” that provide integrated, highly visual (e.g., chart-driven) representations of key data to executives, analysts and key decision makers. In addition to the data...
by XTIVIA | Aug 6, 2012 | Blog, Databases
While creating a linked server from SQL Server 2005 to SQL Server 2000, I got the following error when I tried to query the remote server. OLE DB provider “SQLNCLI10” for linked server “XXXXXX” returned message “The stored procedure...
by XTIVIA | Aug 2, 2012 | Blog, Databases
Hello again, I wanted to follow up on my last blog entry about speeding up the DB2 database restore on an AIX machine. We did some more testing last night by enabling the jfs2 logging back to how it should be. The restore took only 5 minutes when it used...
by XTIVIA | Jul 31, 2012 | Blog, Databases
Hello, I wanted to share some lessons learned with AIX kernel parameters and DB2 database restore performance. We have a client with a 21 GB database on AIX version 6.1 and DB2 9.7 fixpack 6. The server has 8 quad-core CPU and 32 GB of memory. This is a...
by XTIVIA | Jul 30, 2012 | Blog, Business Intelligence, Data Warehousing
We get quite a few questions around Dashboards and Scorecards. I think it is good to enumerate the differences between the two so that when you are ready to implement you don’t lose sight of the differences. So, without further ado, here are the differences that...
by XTIVIA | Jun 28, 2012 | Blog, Data Warehousing
Changing business condiitions drive changes in business requirements (sometimes like wildfire, utterly unpredicatable) I have been through this situation numerous times, as I am sure you have been as well. So how to respond to these changing conditions? What if we...
by XTIVIA | Jun 28, 2012 | Blog, Business Intelligence, Data Warehousing
Several weeks ago USAToday actually published an article about business intelligence on the front page. The story started with a discussion of a solar panel manufacturer so you had to read a little more to find out that the story really was about BI. I was...
by XTIVIA | Jun 1, 2012 | Blog, Databases
I was presented a problem which entailed removing 100s of millions of records from several tables in order to recover disk space and improve query performance. There were several options to choose from of which I explored: I could do the most basic “DELETE FROM…” all...
by XTIVIA | May 23, 2012 | Blog, Portals
I have been using Liferay EE 6.1 with OpenLDAP the past few days, using different testing scenarios for functionality and determining pitfalls. The goal was to test complete functionality, such as authentication, importing, exporting, and password policies,...
by XTIVIA | May 3, 2012 | Blog, Portals
Liferay has a robust service-layer API for developers to use. However, sometimes there are cases when you need to use methods in the internal Liferay API. You can’t use the internal API directly, but you can invoke it indirectly with the PortalClassInvoker...
by XTIVIA | May 3, 2012 | Blog, Databases
This is a short video on how you can use an open source tool called Pentaho Data Integration to migrate data between tables in DB2 and SQL Server. This video is on youtube and walks through downloading the open source code, setting up database connectivity,...
by XTIVIA | Apr 13, 2012 | Blog, Enterprise Java, Portals
So you have Liferay running merrily up on Amazon’s AWS, things are going well, and you decide you wish to add a new feature, such as perhaps the WSRP portlet. (Because this is a Liferay supported portlet, available from the trusted repository, is known to deploy...
by XTIVIA | Apr 9, 2012 | Blog, Databases
Well, I’m in the final 4 and I made my last presentation on the DB2Night Show’s “DB2’s Got Talent Contest 2012” last week. I wanted to make it a fun and ‘edutaining’ presentation so I chose to do a parody of the American...
by XTIVIA | Apr 3, 2012 | Blog, Enterprise Java, Portals
We are seeing significant interest from our Portal clients in enabling Single Sign-On (SSO) not only within their enterprise, but also with their customers and partners. In some cases, this need is becoming an expectation of our clients’ customers – in...
