by XTIVIA | Mar 31, 2014 | Blog, Data Management, Databases
So I just wanted to share this quick write up on how to stop and start your Oracle database and listener automatically on a Linux server. I use this approach for 10g, 11g, and 12c and so far I haven’t had any issues. Oracle provides the means to do this using scripts...
by XTIVIA | Mar 28, 2014 | Blog, Data Management, Databases
In cases when a database change needs to be made there are some good rules that when used can save you a lot of time down the road. Run changes via scripts – Scripts add for precise execution and help remove human error when it comes to typos. When creating scripts...
by XTIVIA | Mar 27, 2014 | Blog, Business Intelligence
To pass parameters from the Main report to the datasets, the parameters have to have the same name. That is, if the name of the parameter in the main report is ‘Region’, then the Datasets which need this parameter will have to have a parameter with an identical name....
by XTIVIA | Mar 23, 2014 | Blog, Portals
Clustering Solr 4.x Summary The recommended method for clustering Solr versions 4 and above is by leveraging the product’s new SolrCloud distributed capabilities to manage horizontal instance scaling. SolrCloud provides the following advanced features: Automatic...
by XTIVIA | Feb 14, 2014 | Blog, Customer Relationship Management
Need updating time Units in ticket activities Entity? Recently I was asked to customize the add/edit ticket activities form in SalesLogix (now known as InforCRM) so that when users click the save button it will auto populate the Completed Date field with the current...
by XTIVIA | Feb 14, 2014 | Blog, Data Management, Databases
I was working with a customer the other day and they were asking for some help setting up dbconsole for their 12c database. It seems that it wasn’t working out of the box and they needed some help configuring it. So of course I said sure no problem! I have done...
by XTIVIA | Feb 11, 2014 | Blog, Business Intelligence, Data Warehousing, Databases, Perspectives
This is an important question that anyone responsible for a data warehouse should ask periodically and with some frequency as well. The following table will give you some concrete ideas on what to look for and how to use the metrics. The details of how you collect...
by XTIVIA | Feb 11, 2014 | Blog, Business Intelligence
Sometimes customers want to view more detail on a transaction or a field in a report. A convenient way to do this is to create a more detailed report which accepts parameters which are present in the summary report. To create a drill through right click on the field...
by XTIVIA | Feb 7, 2014 | Blog, Business Intelligence, Data Warehousing, Enterprise Java
Occasionally JasperServer throws of errors in the Domain usually because of change in the Data Model. The actual error may not be obvious at first: Scroll down to the bottom of the page to see the actual error: Sometimes you only get a message saying ‘There was an...
by XTIVIA | Feb 6, 2014 | Blog, Business Intelligence
Building on the Scrum thoughts I shared in December, I’d like to discuss how we should focus on what we are trying to deliver vs the “how” of delivery. It is entirely natural and easy to focus on the tasks, but the team needs to focus on the...
by XTIVIA | Jan 31, 2014 | Blog, Databases
I have been working with Informix for just over 15 years. This has caused me to stop, pause and think about all the changes in the industry that have happened in that time. Back when I started, databases were still small. Databases were maintained to...
by XTIVIA | Jan 31, 2014 | Blog, Data Management, Databases
If you have ever tried to install a Linux distro on XenServer you have probably run into the installation showing the non-GUI version. Which is perfectly useable, but sometimes it’s just faster and easier to click through the install. So how I get around this issue is...
by XTIVIA | Jan 30, 2014 | Blog, Data Management, Databases
So at one time or another most of us have run into an issue where no matter what we install or try we just can’t get a unix system to throw an x window for anything. Well I personally have run into this issue often enough that I thought I would throw together a...
by XTIVIA | Jan 15, 2014 | Blog, Data Management, Databases
What you need to know about Database Mirroring In recent months I have set up database mirroring for a number of clients. Why you may ask? It is a great option for disaster recovery and even gives the organization additional options when it comes to maintenance...
