Cognos and SPSS

Advanced Analytics to Boost Business Intelligence (BI)

It has been almost a year that IBM acquired SPSS. Still many business users ask how to get more out of BI tools such as Cognos. Quoting IBM:

The combination of C8 BI and SPSS predictive analytics gives IBM customers more power and accuracy in answering the question of What should I be doing in the future? The combination of the powerful C8 BI analysis of current and historical data with the predictive analytic capability of the SPSS portfolio provides IBM customers with the predictive ‘brains’ for the next generation of decision making and business optimization.
The addition of the SPSS portfolio allows customers to leverage and extend their C8 BI investment by enhancing their analysis capabilities with predictive analytics. More specifically, the addition of SPSS predictive analytics helps analyze patterns found in historical and current transaction data as well as attitudinal survey data to predict potential future outcomes and proactively act upon that insight to drive better business outcomes.
Together with the market leading reporting and dashboarding capabilities of C8 BI, this predictive intelligence can be broadly distributed ensuring that decision makers across the organization gain those insights to drive business performance.

This may sound abstract, but in practical terms, with the ability to build sophisticated data models, SPSS enables extracting the essence of the heaps of data available today, and as a result dramatically reducing the time to present actionable information to decision makers. Still too abstract? By deploying models built with SPSS, decision makers can get answers to questions that otherwise might have required massive IT investment in more infrastructure, such as storage, memory and processing power. Want to know more? Don’t hesitate to contact us at +1-303-423-4500 or 888-642-7874.


Lotus Protector for Mail Security

Enterprise Class Email Protection

If you need to go beyond classic SPAM and Virus filtering for your IBM Domino environment, we recommend you take a look at Lotus Protector for Mail Security. Starting at only $29.50 one time license fee per user, it is easy to see how the ROI over 1 year beats most commercially available solutions, and the ROI the 2nd year can mean as much as 75% savings over comparable solutions. A 90 day trial is available to test drive the product.


Migrating Data to DB2 9.7 LUW

Problem

You reached the limit or your unhappy with the performance or features of your database server, and you want to move to DB2. The transition can be simple with respect to your code, as it may be just a matter of changing a few lines of code for the connection string, and setting the correct compatibility mode in DB2. But how do you move your data?

Solution

IBM has published a data migration toolkit, that has been updated to work best with DB2 9.7. Make sure you have service pack 2 installed, which is the latest service pack available as of this writing.

If you are migrating from MySQL or PostgreSQL, enable the ability to do limits and offsets in the where clause with:
db2stop force
echo Set compatibility to 01 or 0F
db2set DB2_COMPATIBILITY_VECTOR=01
db2start

References