XTIVIA BLOG
Have enough DBAs?
How do you know if you have the right number of database administrators (DBAs) on staff to properly take care of your environment? All your organization's databases need to be kept operational and properly tuned, which probably requires around the clock operations....
A Different Perspective on ETL needs
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 have to break...
BI Makes National News
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 pleased...
Adding Custom Mobile Device Rule Handlers in Liferay 6.1
Adding custom mobile device rule handlers in Liferay 6.1 enhances mobile support and customization. This guide walks you through creating a custom rule handler, starting with setting up a liferay-hook.xml file and configuring the portal properties. By following these steps, you...
The Power of Set Operations in SQL Server
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 at once....
Liferay, LDAP, Groups and empty AttributeDescription
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, implemented at...
Calling Methods in the Internal Liferay API
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 class. Caveat: Use of...
Using Pentaho Data Integration for migrating data from DB2 to SQL Server
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, building the...
DBA Insurance?
Insurance: what you need is generally a balance between type, amount, cost, and where you can find it. Everyone of course has different advice on what is optimal. Best bet is to always get that which will keep you safe, you can afford, and from someone you can...
Challenges of Deploying WARs on Liferay Running on Amazon’s AWS
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 successfully,...