Tuesday, March 26, 2013

ODBC_CONNECT Fatal Error in PHP on Apache running on RHEL

Sometimes you might encounter a fatal error on your attempt to connect to Netezza database from your PHP application. Here are the things to check

  1. Check if a driver manager like unixODBC is installed
  2. Check if the odbc.ini and odbcinst.ini files are placed in their right location
  3. Check if a user or system DSN has been created
  4. Check if you can connect to the database using isql
  5. Check if the php-odbc package is installed, if not then install it by executing yum install php-odbc

Monday, March 11, 2013

Big Data: Check Under the Hood

Data is a commodity in business. To become useful information, data must be put into a specific business context. Without information, today’s businesses can’t function. Without the right information, available to the right people at the right time, an organization cannot make the right decisions nor take the right actions, nor compete effectively and prosper.

Read More: Big Data: Check Under the Hood - Information Management Blogs Article

Streamlining Business Intelligence Projects

Saturday, March 09, 2013

PHP test page with phpinfo showing blank page

One of the most common ways to test a successful PHP install is to place a test PHP file in the following location on your RHEL server


Only the following lines need to be put in the file

<?php phpinfo(); ?>

Once that is done, open a web browser and type the url : http://yourdomain.com/phptest.php or http://localhost/phptest.php where phptest.php is the filename you gave.

If the result comes back with a page full of information then PHP is successfully installed and running. If it comes with a blank page then among other things check the permissions on the file. File should have 755 for it to show up in the browser. A quick chmod 755 will solve the problem in most cases.

Wednesday, March 06, 2013

Agile BI: How to Turn Vague Ideas into Tangible Deliverables

Business intelligence has become a catch-all term used within IT to refer to the tools that drive business value and deliver on IT's promise of being innovative and improving an enterprise's top line, rather than IT being simply a cost center.

The majority of BI programs begin with an information or data strategy and a 3-5 year road map for implementing the strategy. The road map, usually built at a high level, categorizes the plan into major groups, such as enterprise data warehouse and business intelligence, data governance and quality, operational reporting, and advanced analytics. When it comes to executing these programs (especially BI), many people struggle with the high-level outline and tight timeline. How do you move towards shaping something concrete? How do you deliver value with some quick wins and maintain the momentum throughout the life of the program?

Read More: Agile BI: How to Turn Vague Ideas into Tangible Deliverables -- TDWI -The Data Warehousing Institute

The latest #BigData #Analytics Daily! https://t.co/IvIGAevVLn Thanks to @mauriciogarciar @hivemaster @EnvironicsA #bigdata #analytics

The latest #BigData #Analytics Daily! https://t.co/IvIGAevVLn Thanks to @mauriciogarciar @hivemaster @EnvironicsA #bigdata #analytics Source...