• IBM Consulting

    DBA Consulting can help you with IBM BI and Web related work. Also IBM Linux is our portfolio.

  • Oracle Consulting

    For Oracle related consulting and Database work and support and Migration call DBA Consulting.

  • Novell/RedHat Consulting

    For all Novell Suse Linux and SAP on Suse Linux questions releated to OS and BI solutions. And offcourse also for the great RedHat products like RedHat Enterprise Server and JBoss middelware and BI on RedHat.

  • Microsoft Consulting

    For Microsoft Server 2012 onwards, Microsoft Client Windows 7 and higher, Microsoft Cloud Services (Azure,Office 365, etc.) related consulting services.

  • Citrix Consulting

    Citrix VDI in a box, Desktop Vertualizations and Citrix Netscaler security.

  • Web Development

    Web Development (Static Websites, CMS Websites (Drupal 7/8, WordPress, Joomla, Responsive Websites and Adaptive Websites).

22 December 2013

IBM® Data Studio can help you manage DB2.

IBM DB2 Management Tools

DB2® provides a variety of tools that simplify the tasks that you need to do to manage DB2.

IBM Data Studio
IBM® Data Studio can help you manage DB2.

DB2 Administration Tool
The DB2 Administration Tool simplifies many of the administrative tasks that are required to maintain your DB2 subsystem.

DB2 Interactive
DB2 for z/OS® DB2 provides Interactive System Productivity Facility (ISPF) panels that you can use to perform most DB2 tasks interactively.

DB2 command line processor
You can use the command line processor to issue SQL statements, bind DBRMs that are stored in HFS files, and call stored procedures.

This blog post will deal with the IBM Data Studio tool and how it can help you create stored procedures.

IBM DB2 Data Studio

Use of DB2 Data Studio tool to create a stored procedure

Workstation-based development tools can help you create, install, and test stored procedures for DB2® for z/OS®.

Stored procedures are portable across the entire family of DB2 servers including DB2 for z/OS, DB2 for i, and DB2 for Linux, UNIX, and Windows. If a DB2 subsystem is configured for the creation of SQL and Java™ stored procedures, you can create these stored procedures with the tools that are available in DB2 Data Studio. These tools also provide steps for building and installing DB2 Java stored procedures on distributed systems. These tools also support read-only access to user-defined functions, triggers, tables, and views.

IBM Data Studio

IBM® Data Studio can help you manage DB2®.

IBM Data Studio is a tool that helps you perform a wide range of daily activities. You can use IBM Data Studio to manage DB2 databases on different operating systems.

You can use IBM Data Studio to administer DB2 instances, DB2 for z/OS® subsystems, databases, and database objects. You can also run utilities that reorganize or load your data in your existing DB2 for z/OS databases.

Working with stored procedures

You can use the workbench to create, test, and deploy stored procedures. You can also debug stored procedures.

Stored procedures contain procedural constructs with SQL statements. Stored procedures are stored in databases and run on servers. An application can call a stored procedure by name and run the SQL statements that are included in the stored procedure. The application can be on the client, while the stored procedure executes its logic on the server. Stored procedures and user-defined functions are sometimes referred to collectively as routines.

  • Before you create stored procedures, you must complete some setup steps.
  • Stored procedure development is not supported for every available data source.
  • To create stored procedures, you must have the required authorities and privileges. 

Creating stored procedures

You can create a stored procedure from the Data Project Explorer, either from a data development project, or by using the toolbar buttons. You can also create a stored procedure from a database connection in the Data Source Explorer view or Administration Explorer view.

Developing DB2 for z/OS stored procedures

There are some stored procedure features in the workbench that are designed specifically for DB2 for z/OS® stored procedures. In addition, there are some setup steps that you should complete.

Here is a webinar about this subject that you can watch at your convenience:



If you do not have enough time to watch the whole webinar, here is the presentation of the webinar:


How to migrate to DB@ Data Studio: How do I migrate to DB@ Data Studio

For more detailed information on IBM DB2 Data Studio take a look at:

IBM DB2 Data Studio product page: IBM DB2 Data Studio Product Page

What is new in IBM DB2 Data Studio: What is new in IBM Data Studio

IBM DB2 Data Studio Info Center: IBM DB2 Data Studio Information Center

For more information please contact me at:

Drs. Albert Spijkers
DBA Consulting
web:            http://www.dbaconsulting.nl
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook

email:          info@dbaconsulting.nl 

25 November 2013

DB2 11 is here

DB2 11: The Database for Critical Transactions & Analytics

Speed, Simplicity, Savings

DB2 11 for z/OS delivers new innovations: Save money, save time, reduce cost Enhanced continuous availability, scalability, and security for business-critical information Sophisticated Critical business analytics Simpler, faster migration for faster ROI Deep integration between DB2 and System z

IBM DB2 11 overview video:

 So what’s new in DB2 11 that is causing so much excitement? Here is a quick summary of some of the exciting new features and business benefits of DB2 11, about which this book will give you deeper insight:

• Even more out-of-the-box CPU savings

    10 percent complex OLTP

    10 percent update intensive batch

    40 percent queries

    25 percent uncompressed tables and 40% compressed tables

• Enhanced resiliency

    Fewer planned outages, fewer REORGs, faster recovery

    Cost-effective archiving, access warm/cold data in single query

    Business-critical analytics

    DB2 Analytics Accelerator performance enhancements

    Big data integration

    In-transaction real-time scoring

    Advanced QMF analytic capabilities with mobile support

• Simpler, faster upgrades for faster ROI

    6x faster catalog migration

    Protection from incompatible changes

    Repeatable testing with real workloads and integrated cloning

Big Data, IBM DB2 Accelerators:

Join Dan Wardman, VP of Information Management Mainframe Software, as he discusses Big Data and System z and explains why zEnterprise systems are a key data source for Big Data and Business Critical Analytics.

Big data can address a multitude of problems if you know how to use it. The insights gleaned from big data can help organizations deepen customer engagement, optimize operations, prevent threats and fraud, and capitalize on new sources of revenue. But to be successful, you need a clear understanding of the characteristics of big data and the skills required to manage it.

IBM Business Analytics and Optimization

Delivers extremely fast query results for critical business insight

IBM® DB2® Analytics Accelerator for z/OS is a high-performance appliance that integrates IBM Netezza and zEnterprise technologies. The solution delivers extremely fast results for complex and data-intensive DB2 queries on data warehousing, business intelligence and analytic workloads.

DB2 Analytics Accelerator for z/OS helps you:

  •     Query data at high speeds—to significantly improve response times for unpredictable, complex and long-running query workloads.
  •     Extend the capabilities of DB2 for z/OS—to support a cost-effective analytics solution for data warehousing, business intelligence and predictive analytics.
  •     Lower operating costs—by reducing System z disk requirements and offloading query workloads to a high-performance platform.

Offers improved, broader analytics queries with latest release

IBM® DB2® Analytics Accelerator for z/OS delivers new features to support a broader set of applications and provide acceleration capabilities for most DB2 for z/OS customers. The software includes enhancements to support more data, queries, systems and applications, which can offer greater business benefits and cost savings.

The latest version of DB2 Analytics Accelerator for z/OS provides these features and benefits:

  •     Accelerates a broader spectrum of queries with support for Static SQL, multiple-row FETCH and multiple encodings on the same accelerator.
  •     More robust and scalable for the enterprise through enhanced workload balancing, improved incremental update performance and improved monitoring.
  •     Storage saver performance improvements including built-in restore, better access control for archived partitions and protection of moved partitions.
  •     Supports DB2 11 and PureData Analytics N2001 hardware.

DB2 10.5 with BLU Acceleration:

Accelerating Analytics with BLU:

IBM DB2 10.5 Optimized for SAP Software:

IBM DB2 Analytics Accelerator or IDAA

DB2 for z/OS has a new cool feature: the IBM DB2 Analytics Accelerator or IDAA. The IDAA is a marriage of DB2 for z/OS and Netezza technology to accelerate complex queries in a highly secure and available environment. This 60 minute video will explain what it is exactly, how it works and why you would want such an accelerator. Click on the link below to start the presentation (opens new window). Enjoy! - See more at: http://www.db2-symposium.com/articles/category/the-wall/#sthash.Gz1T3zjm.dpuf

How IDAA Accelerators work and Why would want IBM IDAA Accelerators

Look at this article to get a quick introduction into DB2 UDB trace facility:

DB2 Basics: An introduction to the DB2 UDB trace facility

More information on what's new in DB2 11 can be found here:

DB2 11: The Database for Critical Transactions & Analytics

DB2 Information Management Tools and DB2 11 for z/OS Compatibility

from IBM Champion Craig Mullins

from Robert Catterall

from Willie Favero

IBM Data Management on TUMBLR

Flashbook: DB2 11 for z/OS - The Database for Big Data and Analytics

DBI Smarter Tools for Smarter People

DB2 10.5 with BLU Acceleration New Dynamic In-Memory Analytics for the Era of Big Data

SQL Tips for DB2 LUW by Serge Rielau (瑞赛奇) and Rick Swagerman

Discover DB2 for yourself

For more information please contact me at:

Drs. Albert Spijkers
DBA Consulting
web:            http://www.dbaconsulting.nl
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook

email:          info@dbaconsulting.nl 

20 November 2013

Oracle Database 12c Migration Overview and how to reduce risk

Oracle Database 12c Architecture Overview

Oracle Database 12c Multitenant Architecture Overview

Oracle Database Upgrade
Upgrading to Oracle Database 12c provides the latest in efficient, reliable, secure data management for mission-critical on-line transaction processing applications, query-intensive data warehouses, and cloud applications. The right planning, preparation, and upgrade steps will make the upgrade process simpler, faster, and more predictable from start to finish.  
White Paper: Upgrading to Oracle Database 12c
This white paper outlines the methods and alternatives available for you to upgrade and migrate your database to Oracle Database 12c.  Learn about different use cases and key factors to consider when choosing the method that best fits your requirements.

Upgrade Compatibility Matrix
Wondering which versions are supported for direct upgrade to Oracle Database 12c? Here is the support note with that information.

Mike Dietrich's Upgrade Blog
Database Upgrade Team member Mike Dietrich maintains a BLOG relating to Database Upgrade presentation, events and topics.

Upgrade and Migration to Oracle Database 12c - Workshop Presentation   
This presentation covers a full day database upgrade and migration workshop with plenty of background information from installation and patching to various upgrade and migration techniques covering also fallback strategies, performance managements and application upgrades.

Manual Upgrades
This document provides a checklist to review prior to performing a manual Upgrade.

DBUA Upgrades
If you plan on using the Database Upgrade Assistant to perform your upgrade, this document provides a check-list you should review first.

Upgrade Migrate & Consolidate to Oracle Database 12c

Different Ways to Upgrade, Migrate & Consolidate with Oracle Database 12c

Oracle Database 12c : What's new in Database Upgrade?

Oracle Database 11g Release 2 information
 Much of this information applies to Oracle Database 12c as well, but the white papers and documents below were produced for Oracle Database 11g Release 2.
Upgrade Methods
Get an overview of various Upgrade Methods that may be used to upgrade to Oracle Database 11g Release 2.

Best Practices
Review Oracle's Best Practices for upgrading your Oracle Database.

Customer Migration: Fujitsu SPARC Enterprise
Read about using Oracle Real Application Testing as part of a database migration from Oracle9i Database to Oracle Database 11g.

Oracle Database 11g Customer Upgrade
A paper discussing a customer Upgrade project taking their installed base from Oracle 9i to Oracle Database 11g. The paper covers planning through execution

Minimal Downtime Upgrade using Oracle GoldenGate
The Oracle Grid Center is a joint effort between Oracle and Fujitsu to provide solutions that deliver safety and security to clients, including system construction, joint verification, and post-installation support. This white paper discusses procedures for upgrading Oracle Database using Oracle GoldenGate, Oracle’s real-time data integration software, as well as the results of such upgrades.

Downgrade Methods
A white paper describing the available methods for downgrading to an earlier release of Oracle Database.

Oracle Database 11.2 Upgrade Methods

Partner Webcast -- Oracle Database 12c: Reducing Upgrade Risk - 26/09/2013 (Part 1of2)
Oracle Database 12c includes exciting new features such as the Oracle Multitenant option, Oracle Active Data Guard Far Sync, information lifecycle management enhancements and new data types just to name a few.

Anyone wishing to take advantage of these and other new features will need to upgrade their existing databases to the latest Oracle Database 12c. Upgrading the database is a task that Database Administrators plan for, ahead of time, with great caution. This is because of the risk involved in upgrading a production system. This risk can be summarized in the following question:
How will the application(s) hosted by the database behave next to the upgrade?

Partner Webcast -- Oracle Database 12c: Reducing Upgrade Risk - 26/09/2013 (Part 2of2)
Oracle Database 12c includes exciting new features. Anyone wishing to take advantage of these and other new features will need to upgrade their existing databases to the latest Oracle Database 12c. Upgrading the database is a task that Database Administrators plan for, ahead of time, with great caution. This is because of the risk involved in upgrading a production system. This risk can be summarized in the following question:
How will the application(s) hosted by the database behave next to the upgrade?

This covers performance, but also functionality. Upgrading to Oracle Database 12c provides the latest in efficient, reliable, secure data management for mission-critical on-line transaction processing applications, query-intensive data warehouses, and content management and Web2.0 applications. The right planning, preparation, and upgrade steps will make the upgrade process simpler, faster, and more predictable from start to finish.

Complete Lifecycle Management of Pluggable Databases (aka Multitenant Option)

All Migration slides from Oracle ISV Migration Center:

14 October 2013

IT Security with EMMET 4.0


What is the Enhanced Mitigation Experience Toolkit (EMMET)?

The Enhanced Mitigation Experience Toolkit (EMET) is a utility that helps prevent vulnerabilities in software from being successfully exploited. EMET achieves this goal by using security mitigation technologies. These technologies function as special protections and obstacles that an exploit author must defeat to exploit software vulnerabilities. These security mitigation technologies do not guarantee that vulnerabilities cannot be exploited. However, they work to make exploitation as difficult as possible to perform.

The new EMET 4.0 also provides a configurable SSL/TLS certificate pinning feature that is called Certificate Trust. This feature is intended to detect man-in-the-middle attacks that are leveraging the public key infrastructure (PKI).

Are there restrictions as to the software that EMET can protect?

EMET can work together with any software, regardless of when it was written or by whom it was written. This includes software that is developed by Microsoft and software that is developed by other vendors. However, you should be aware that some software may not be compatible with EMET. For more information about compatibility, see the "Are there any risks in using EMET?" section.

What are the requirements for using EMET?

EMET 3.0 requires the Microsoft .NET Framework 2.0. EMET 4.0 requires the Microsoft .NET Framework 4.0. Additionally, for EMET to work with Internet Explorer 10 on Windows 8, KB2790907 must be installed.

Where can I download EMET?

To download EMET, go to the related Microsoft TechNet page:

Download emmet 4.0
The Enhanced Mitigation Experience Toolkit

How do I use EMET to protect my software?

After you install EMET, you must configure EMET to provide protection for a piece of software. This requires you to provide the name and location of the executable file that you want to protect. To do this, use one of the following methods:

Work with the Application Configuration feature of the graphical application.

Use the command prompt utility.

If you want to use the Certificate Trust feature that was released in EMET 4.0, you have to provide the list of the websites that you want to protect and certificate pinning rules that apply to those websites. To do this, you have to work with the Certificate Trust Configuration feature of the graphical application. Or, you can use the new Configuration Wizard. This enables you to automatically configure EMET with the recommended settings.

Note Instructions for how to use EMET are in the user's guide that is installed together with the toolkit.

How can I deploy EMET across the enterprise?

The easiest way to deploy the current version of EMET across an enterprise is by using enterprise deployment and configuration technologies. The current versions have built-in support for Group Policy and System Center Configuration Manager. For more information about how EMET supports these technologies, please refer to the EMET user's guide.

You can also deploy EMET by using the command prompt utility. To do this, follow these steps:

Install the .msi file on each destination computer. Or, put a copy of all the installed files on a network share.

Run the command prompt utility on each destination computer to configure EMET.

Are there any risks in using EMET?

The security mitigation technologies that EMET uses have an application-compatibility risk. Some applications rely on exactly the behavior that the mitigations block. It is important to thoroughly test EMET on all target computers by using test scenarios before you deploy EMET in a production environment. If you encounter a problem that affects a specific mitigation, you can individually enable and disable that specific mitigation. For more information, refer to the EMET user's guide.

What is the latest version of EMET?

A new version of EMET. EMMET 4.0 was made available on June 17, 2013. For more information about the latest version of EMET, go to the following TechNet website:

The Enhanced Mitigation Experience Toolkit

How can I get support for EMET?

Customers who are using EMET 3.0 or EMET 4.0 who have access to Microsoft Services Premier and Professional Support can receive fee-based advisory support through these channels. Customers who do not have Premier or Professional contracts can receive support through the following official support forum:

Enhanced Mitigation Experience Toolkit (EMET) Support

EMET is a free utility that helps prevent memory corruption vulnerabilities in software from being successfully exploited for code execution. It does so by opt-ing in software to the latest security mitigation techniques. The result is that a wide variety of software is made significantly more resistant to exploitation – even against zero day vulnerabilities and vulnerabilities for which an available update has not yet been applied.

The feature set for this new version of the tool was inspired by our desire for EMET to be an effective mitigation layer for a wider variety of potential software exploit scenarios, to provide stronger protections against scenarios where EMET protection already exists, and to have a way to respond to 0day exploits as soon as possible. Here are the highlights of the EMET 4.0 feature set:

  • EMET 4.0 detects attacks leveraging suspicious SSL/TLS certificates

  • EMET 4.0 strengthens existing mitigations and blocks known bypasses

  • EMET 4.0 addresses known application compatibility issues with EMET 3.0

  • EMET 4.0 enables an Early Warning Program for enterprise customers and for Microsoft

  • EMET 4.0 allows customers to test mitigations with "Audit Mode"

SSL/TLS Certificate Trust features

EMET 4.0 allows users to configure a set of certificate pinning rules to validate digitally signed certificates (SSL/TLS certificates) while browsing with Internet Explorer. This option allows users to configure a set of rules able to match specific domains (through their SSL/TLS certificates) with the corresponding known Root Certificate Authority (RootCA) that issued the certificate. When EMET detects the variation of the issuing RootCA for a specific SSL certificate configured for a domain, it will report this anomaly as an indicator of a potential man-in-the-middle attack.

Advanced users can also add exceptions for each pinning rule. This will allow EMET to accept SSL/TLS certificates even if the pinning rule doesn’t match. Exceptions are related to some properties of the RootCA certificate, such as key size, hashing algorithm, and issuer country.

Strengthened mitigations, blocking bypasses

Microsoft learned a great deal during the "Technical Preview" phase of EMET 3.5. They saw researchers poking and presenting clever tricks to bypass EMET’s anti-ROP mitigations. EMET 4.0 blocks these bypasses. For example, instead of hooking and protecting only functions at the kernel32!VirtualAlloc layer of the call stack, EMET 4.0 will additional hook lower level functions such as kernelbase!VirtualAlloc and ntdll!NtAllocateVirtualMemory. These "Deep Hooks" can be configured in EMET’s Advanced Configuration. Microsoft has seen exploits attempt to evade EMET hooks by executing a copy of the hooked function prologue and then jumping to the function past the prologue. With EMET 4.0’s "Anti detours" option enabled, common shellcode using this technique will be blocked. Finally, EMET 4.0 also includes a mechanism to block calls to banned API’s. For example, a recent presentation at CanSecWest 2013 presented a method of bypassing ASLR and DEP via ntdll!LdrHotPatchRoutine. EMET 4.0’s "Banned API" feature blocks this technique.

Application compatibility fixes

Users of previous versions of EMET had encountered isolated compatibility issues when enabling mitigations on both Microsoft and third party software. EMET 4.0 addresses all these known app-compat issues. That list includes issues in the following areas:

- Internet Explorer 9 and the Snipping Tool

- Internet Explorer 8’s Managed Add-ons dialog

- Office software through SharePoint

- Access 2010 with certain mitigations enabled

- Internet Explorer 10 on Windows 8

The EMET 4.0 installer also opts-in protection rules with certain mitigations disabled where Microsocft knows a mitigation interacts poorly with certain software. Examples include Photoshop, Office 2013’s Lync, GTalk, wmplayer, and Chrome.

Early Warning Program for enterprise customers and for Microsoft

When an exploitation attempt is detected and blocked by EMET, a set of information related to the attack is prepared with the Microsoft Error Reporting (MER) functionality. For enterprise customers collecting error reports via tools like Microsoft Desktop Optimization Package or the Client Monitoring feature of System Center Operations Manager, these error reports can be triaged locally and used as an early warning program indicating possible attacks against the corporate network. For organizations that typically send all error reports to Microsoft, this information will add to the set of indicators we use to hunt attacks in the wild, and will facilitate the remediation of issues with security updates before vulnerabilities become a large scale threat. The EMET Privacy Statement (available also via the main EMET window) includes more information about the type of data that will be sent in the error report via Microsoft Error Reporting. The Early Warning Program is enabled by default for the EMET 4.0 Beta and can be disabled in the EMET UI or via the EMET command line component. We are eager to hear customer feedback about this feature to help shape the Early Warning Program for the EMET 4.0 final release.

Audit Mode

When previous versions of EMET detected exploitation attempts, it would report the attack via the EMET agent and then terminate the program to block the attack. For EMET 4.0, in response to customer feedback, we provided an option to configure EMET’s behavior when it detects an exploitation attempt. The default option remains to terminate the application. However, customers wanting to test EMET in a production environment can instead switch to "Audit Mode" to report the exploitation attempt but not terminate the process. This setting is not applicable for all mitigations but we provide this option whenever possible.

Other Improvements

EMET 4.0 includes a bunch of other improvements. The quantity of new features and volume of work put into this release is the reason Micorosft skipped the EMET 3.5 full release and jumped straight to EMET 4.0. Please refer to the EMET 4.0 Beta Users Guide for the full set of features but here are several other highlights:

- EMET Notifier becomes EMET Agent, with new duties and functionalities

- More granular reporting options (tray icon, event log, both, or none)

- New default profiles for both mitigations and Certificate Trust

- Registry configuration to customize the EMET Agent’s messaging

- Optimized RopCheck for significantly better performance

- Numerous UI tweaks to make EMET easier to use

- Enable wildcard support when adding applications to be protected

- Allow processes to be protected even if they do not have .exe extension

- Switched to .NET Framework 4.0

- EMET is an officially supported Microsoft tool with support available for customers with Premier contract

First, a quick overview of what EMET does. EMET allows users to force applications to use several key security defenses built into Windows — including Address Space Layout Randomization (ASLR) and Data Execution Prevention (DEP). Put very simply, DEP is designed to make it harder to exploit security vulnerabilities on Windows, and ASLR makes it more difficult for exploits and malware to find the specific places in a system’s memory that they need to do their dirty work.

EMET can force a non-Microsoft application to perform ASLR on every component it loads, whether the program wants it or not. Please note that before you install EMET, you’ll need to have Microsoft’s .NET Framwork 4 platform installed. And while EMET does work on Windows XP (Service Pack 3 only), XP users cannot take advantage of mandatory ASLR and a few other notable protections included in this tool.

However, EMET includes several important security features that can help fortify third-party applications on XP. Namely, its "Structured Exception Handler Overwrite Protection," or SEHOP protection, which guards against the most common technique for exploiting stack overflows on Windows. Microsoft says this mitigation has shipped with Windows ever since Windows Vista Service Pack 1.

In addition to a revised user interface, EMET 4.0 includes a handful of new features that were bundled with the 3.5 tech preview version, such as novel methods of blocking an exploit technique called return-oriented programming (ROP). Attackers can leverage ROP to bypass DEP protections by using snippets of code that are already present in the targeted application.

One of the much-hyped new capabilities of EMET 4.0 is its "certificate trust" feature, which is designed to block so-called "man-in-the-middle" attacks that leverage counterfeit SSL certificates in the browser. The past few years saw several attacks that impersonated Webmail providers and other top Internet destinations using fraudulent digital certificates obtained by certificate authorities, including Comodo, DigitNotar and Turktrust. This feature is a nice idea, but it seems somewhat clunky to implement, and only works to protect users who browse the Web with Internet Explorer. For tips on configuring and using this feature of EMET, check out this post.

If you have questions about EMET or run into issues with the program, check out the Microsoft support page for EMET
EMMET Support

, which lets you to submit questions to the user community if you don’t see your problem addressed in a previous support thread.

The chart above indicates which system- and application-specific protections in EMET 4.0 are available for each supported version of Windows. Visit this link: http://www.microsoft.com/en-us/download/details.aspx?id=39273 to download EMET 4.0, as well as a detailed user guide on the software.

For more information please contact me at:

Drs. Albert Spijkers
DBA Consulting
web:            http://www.dbaconsulting.nl
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook

email:          info@dbaconsulting.nl 

26 August 2013

Windows Server 2012 your OS platform of choice!

Windows Server 2012 your OS platform of choice!

Windows Server 2012 Overview

Windows Server 2012 brings Microsoft’s experience building and operating public clouds to the server operating system, making it a dynamic, highly available, and cost-effective platform for private clouds and on-premise datacenters. It can take you Beyond Virtualization while offering The Power of Many Servers, and the Simplicity of One. It helps with Every App, Any Cloud, and offers to help Enable the Modern Work Style. Learn what Microsoft means by all that and furthermore, experience this in a number of demos showing exciting new features and scenarios.

Hyper-V - What's New in Windows Server 2012 R2

Learn about the new features and functionality in Windows Server vNext in Hyper-V.

New Networking Diagnostics with Powershell in Windows Server r2


Transforming your Datacenter with Software-Defined Networking (SDN)


Securing Windows Server 2012

Use these tools to help assess security risks, identify missing security updates, and manage the security and compliance process for the most widely used Microsoft technologies.

Microsoft Security Assessment Tool 4.0

The Microsoft Security Assessment Tool is a risk-assessment application designed to provide information and recommendations about best practices for security within an IT infrastructure.

Microsoft Baseline Security Analyzer 2.2 (for IT pros)

The Microsoft Baseline Security Analyzer provides a streamlined method to identify missing security updates and common security misconfigurations.

Microsoft Security Compliance Manager

This Solution Accelerator provides centralized security baseline management features, a baseline portfolio, customization capabilities, and security baseline export flexibility to accelerate your organization’s ability to efficiently manage the security and compliance process for the most widely used Microsoft technologies.

Security Tools to Administer Windows Server 2012:

Inside Windows Server 2012 Multi-Server Management Capabilities

Windows Server 2012 will offer excellent total cost of ownership as an integrated platform with comprehensive, multicomputer manageability. Two areas in which Windows Server 2012 improves multicomputer management are Server Manager and Windows PowerShell 3.0. Server Manager in Windows Server 2012 helps you efficiently deploy and manage roles and features on the local server, on remote servers, and on both online and offline virtual hard disks. It also provides a multi-server experience where you can centralize your Windows Server management in a single view, and streamlined your server configuration and deployment from the same window. Windows PowerShell 3.0 provides an extensive platform to help you manage server roles and automate management tasks. With access to over 2300 commandlets (a tenfold increase from the previous version), Windows PowerShell 3.0 offers comprehensive management across your datacenter. This session overviews these subjects in detail and prepares you for enhancing your management capability.

Windows Server Blog:

For more information please contact me at:

Drs. Albert Spijkers
DBA Consulting
web:            http://www.dbaconsulting.nl
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook

email:          info@dbaconsulting.nl 

22 August 2013

IBM TeaLeaf

IBM TeaLeaf

IBM Tealeaf Customer Experience Management solutions help customer-centric organizations deliver better digital customer experience. From e-commerce professionals, to digital marketers and business executives, as well as IT and customer service staff, IBM Tealeaf solutions provide an incisive "view" of the digital customer that empowers organizations to deliver better web and mobile experiences and provide more effective customer service. IBM Tealeaf solutions help companies increase online conversation rates, raise customer retention rates and improve customer satisfaction. Customer Experience Management solutions are an integral offering in the IBM Enterprise Marketing Management product suite.

Using groundbreaking technology, IBM Tealeaf solutions capture and record every digital customer interaction, and how the site or application responds in real-time. By capturing every customer visit, IBM Tealeaf solutions visualize the qualitative details of every single interaction, uniquely helping businesses understand user actions and unexpected business results. This rich customer experience dataset then fuels quantitative assessments of the negative business impact that results from customer’s online or mobile struggles, and helps prioritize opportunities for improvement and innovation.
With IBM Tealeaf solutions, e-businesses benefit from:

  • Maximizing the value of every single customer visit (web and mobile) and ensuring that more transactions are completed successfully.
  • Immediate visibility into the struggles affecting customer behavior and their business impact (without tagging or impacting site performance or reliability).
  • Rapid resolution of hard-to-find usability, system or application problems.
  • Improved customer service when agents have instant access to online customer sessions.
  • Preserving digital customer interactions to resolve customer disputes quickly and accurately.

For any online business facing pressure to increase revenue and reduce costs, Customer Experience Management is an essential. IBM Tealeaf solutions provide the ability to pinpoint customer struggles on websites in real-time. Organizations can intercept problem spots and remove roadblocks to maximize conversions, revenue and customer loyalty.

IBM Tealeaf Mobile

IBM Tealeaf Overview

Watch Zions Bancorporation discuss how they used IBM Tealeaf solutions to create user interfaces -- for both web and mobile -- that were easier to use, more customer friendly, and provided better results.

Introduction to IBM MobileFirst Analytics with TeaLeaf

With the rapid adoption of mobile devices, consumers now have the ability to conduct transactions anywhere, anytime. To succeed in this burgeoning new business channel, you must deliver mobile services and features that your customers will adopt and use productively. Yet most e-businesses today have a limited understanding of how their customers are engaging with them on mobile channels.
Given the magnitude of mobile variables—including the abundance of devices and browsers—the risk of customers encountering obstacles is inherently greater. Some of these issues are technical but many of the things that cause customers to struggle are related to business process and usability, making them harder to detect, diagnose and resolve effectively.

This session provides an introduction to the IBM MobileFirst Anlaytics

Tealeaf is the industry leading Customer Experience Management Solution (CEM). Within transactional eComerce and Self-Serve applications Tealeaf helps companies make web site optimization decisions faster and smarter than they ever could before. This is done by identifying segments of customers having a bad experience, allowing Tealeaf users to replay those experiences to learn why they are struggling and then to rapidly create a business case against their learning's so that optimizations can be prioritized by business impact. Regardless of the web channel: traditional fixed web, mobile web, or native application, Tealeaf ensures the success of online customers.

Mobile apps are different, and so are the techniques required to distribute and manage them. Learn how the IBM Worklight Application Center makes it easy to distribute, govern, and collect feedback on mobile apps. For more information, visit ibm.com/worklight.

Learn more at:  IBM Tealeaf Home Page

IBM Many Eyes

What is the future of visual analysis? Imagine if business decision makers easily uncover business patterns and trends not readily apparent in a standard spreadsheet. Visualization helps to uncover insights hidden in the raw data. Imagine capturing your path of analysis and sharing that within the team with other team members collaborating with you on the same visualization. Imagine taking the power of that visualization and interacting with it on your mobile device or web just as you would on the desktop. Join IBM Many Eyes and usher in the future of visual analytics.

IBM Many Eyes is a community that connects visualization experts, practitioners, academics and enthusiasts. Many Eyes democratizes visualization. In three easy steps you can create your own visualization using your own public data set. On the Many Eyes website, you can find expertise contributions from IBM visualization luminaries and IBM Research's Center for Advanced Visualization. These contributions and more provide guidance on creating the most effective visualizations while describing new trends and advances in visualization.

Bring your data to life at http://www.ibm.com/manyeyes.

The Four Pillars of Effective Visualizations

As a member of the IBM Center for Innovation and Visual Analytics, Noah Iliinsky works to create new and innovative domain-specific visualizations while working with IBM clients to create effective and efficient visualizations that yield insights and answers into their business quickly.

This talk, delivered at Strata 2013, discusses the broad design considerations necessary for effective visualizations. You will learn what's required for a visualization to be successful, gain insight for critically evaluating visualizations they encounter, and come away with new ways to think about the visualization design process.

To be most effective, a visualization must have, in this order: Purpose (Why are we creating this visualization? Who is it for?) Content (What data matters? What relationships matter?) Structure (How do we best reveal those data and relationships?) Formatting (How does it look & feel? How will it be consumed?)

For additional visualization insights from Noah and other IBM visualization luminaries, visit http://www.ibm.com/manyeyes a community of over 100,000 visualization professionals and enthusiasts.

IBM many Eyes video introduction:

For more information please contact me at:

Drs. Albert Spijkers
DBA Consulting
web:            http://www.dbaconsulting.nl
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook

email:          info@dbaconsulting.nl 

21 August 2013

Put big data to work for you!

Put big data to work for you – with SAP BusinessObjects BI Platform, analytics edition

Quickly and easily deploy high-performance analytics – bypassing system integration challenges – with SAP BusinessObjects BI Platform, analytics edition. This offering is a complete analytics platform that combines market-leading data integration, data management, and business intelligence (BI) products, pre-certified to run together – for a more effective way to harness big data.

  • Analyze massive volumes of data with superior performance and unprecedented scalability
  • Detect trends and outliers across structured business data and unstructured social data
  • Leverage impactful analytics tailored to your industry and/or line of business needs
  • Act on relevant information from your desk or on the road, and react to market changes – faster
  • Proactively seize new business opportunities and respond to potential threats
  • Reduce the complexity of your IT landscape and minimize total cost of ownership

Video Infographic: Mobile Analytics

Interesting stats on mobile analytics from COMPTIA, Gartner, Good Technology, IDC, LOUDHOUSE, Motorola Solutions, Portio Research, Stiel Direct, and University of Texas at Austin. View the infographic, too: http://www.slideshare.net/SAPanalytics/mobile-analytics-infographic

SAP BusinessObjects for Finance Line of Business

See how SAP BusinessObjects solutions can help Finance line of business run better by enabling strategic alignment, predictable performance, and confident decisions. For more information: Visit us on the Web at www.sap.com/sapbusinessobjects

SAP Bundle Offering

SAP announced integration of Apache Hadoop into real-time data warehousing environments with a new “big data” bundle and go-to-market strategy with Cloudera, Hitachi Data Systems, Hortonworks, HP and IBM. The offering is based on the flagship SAP HANA platform and combines the SAP Sybase IQ server, SAP Data Integrator software and SAP BusinessObjects business intelligence (BI) solutions. It provides a comprehensive data warehousing solution for real-time insights across massive data sets from various sources

Bringing together the speed, scale, flexibility and affordability needed to fully tap the potential of “big data,” SAP is offering the following Hadoop-integrated solutions in a single bundle, as well as individually:

  • SAP HANA database
  • SAP Sybase IQ, a columnar database and enterprise data warehouse database
  • SAP Data Integrator
  • SAP BusinessObjects BI suite

SAP enables customers to integrate Hadoop into their existing BI and data warehousing environments in multiple ways, giving customers the ability to tailor the integration to their needs. With SAP Data Integrator, organizations can read data from Hadoop Distributed File Systems (HDFS) or Hive databases, and load relevant data rapidly into SAP HANA or SAP Sybase IQ, helping ensure that BI users can continue to use their existing reporting and analytics tools. Furthermore, customers can federate queries across SAP Sybase IQ and Hadoop environments, or alternatively run MapReduce jobs across a SAP Sybase IQ MPP environment using built-in functionality. Lastly, SAP BusinessObjects BI users can query Hive environments giving business analysts the ability to directly explore Hadoop environments.

For more information download the pdf on this URL:

BI Analytics Edition

For more information please contact me at:

Drs. Albert Spijkers
DBA Consulting
web:            http://www.dbaconsulting.nl
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook

email:          info@dbaconsulting.nl 

17 August 2013

IBM is winning with Cognos 10.2

IBM is winning with Cognos 10.2

Data Warehousing and BI are offered by a large number of vendors these days. Since W.H. Inmon “father of data warehousing”, defined data warehouse as: A data warehouse is a Subject Oriented, Integrated, Non-volatile, and Time-variant collection of data in support of management’s decisions, there have been several developments in BI generally. Real-Time BI has become a big issue these days. Big Data is another one. In your choice for a BI and Data warehouse applications and a comparison of vendors it is important to know what the goal is for your BI Data Warehouse. There is first the difference in methodologies, Kimball vs Inmon, is a first point to look at.

Which Data Warehousing Methodology is best? Which car is best? It depends!

I will briefly compare the main differences between Kimball and Inmon methodologies:

Operational Data Store (ODS)
Enterprise Data Model
Star Schema Datamarts
Yes [1]

 [1] Inmon’s Corporate Information Factory advocates the user of star schema’s to build data marts.

Inmon’s main tenet is that an Enterprise Data Model is required to underpin a Corporate Data Warehouse and Kimball makes no such claim.  In reality, most large corporates replicate operational table structures and data regularly into an Operational Data Store (ODS) which is an approximate union of the data models from each operational system.  So in a Kimball shop the ODS approximates a rough Enterprise Data Model, thereby closing the gap on the perceived difference.  However, Inmon does stress the importance of reconciling the Data Warehouse back to source, whereas Kimball provides no such emphasis.
Both propose Star Schema Datamarts, business driven incremental development involving prototyping iterations (Agile) and report/query delivery from relational databases directly or via OLAP data repositories such as n-dimensional cubes.

Here at UOW, we utilize our ODS as a rough Enterprise Data Model, we reconcile our Kimball fact and conformed dimensions as required, and build data marts using star schemas and n-dimensional cubes, from which data is extracted using Cognos Bi tools and native SQL.

 After having had a thorough look at which data Model you want to choose, which can be a lot more complex than just comparing them, depending on data volume, goal of analysis and drill downs required, performance is a next great issue to look at which entails choice of hardware, OS platform, and vendor.

Below is a comparison of three vendors, IBM, Oracle and SAP, which compares Business Intelligence (BI) Express Software Comparison for IBM Cognos 10 BI by IBM, Hyperion System 9 by Oracle, SAP Business Objects Edge Business Intelligence by SAP

From this comparison one can conclude that IBM is clearly winning overall. A comparison is always a temporary view on things and one can assume that the solutions from Oracle and SAP have improved since the releases compared, but so has IBM’s solution.

IBM Cognos 10.2 Enterprise was announced a short while ago, and with it comes increased usability, performance and a host of new features. Below we’ll take a walk through a few of these new features and highlight how they’ll impact your bottom line business.

Cognos Insight 10.2

Cognos Insight, released in Early 2012, is the Personal Analytics solution that has taken the marketplace and user’s desktops by storm, garnering a #1 ranking among all Self Service Business Intelligence Platforms in The Forrester Wave (Q2 2012). Cognos 10.2 continues to improve ease of use, and integration with IBM Cognos Enterprise to encourage collaboration and enterprise distribution while avoiding data silos that other competitive solutions can create. What’s the use of personal insight if the entire organization cannot stand to benefit?

Tree MapsCustomers and Partners alike have clamored for improved data visualizations and IBM has responded in kind. The addition of Tree Maps to Cognos Insight pays homage to the applied data visualization theories of luminaries such as Edward Tufte and Stephen Few and it is a theme that is quite prevalent in Cognos 10.2. Unfortunately, we’ll have to wait for Tree Maps in the enterprise studios as this is a Cognos Insight-Only feature for now.

Smart MetadataA new data discovery engine in Cognos Insight will automatically detect dimensional levels in hierarchies and even differentiate between numeric attributes and measures. This means users will spend even less time importing data, further shortening the learning curve of this already intuitive platform.

Drill-able, Drag and Drop Charting and Top/Bottom FilteringUsers can now drill up and down directly on charts, just as is possible in Cognos Enterprise, and they can also drag and drop dimensions and measures directly onto charts as opposed to having to retain a crosstab in prior versions. Also included is rapid top/bottom filtering in Crosstabs that is always a simple right click away.

Package ImportPrior to this latest release, users could import data into Cognos Insight from existing IBM Cognos Reports. IBM takes the story of unified metadata one step further allowing users to source data directly from the same ad-hoc reporting packages that are published in the Cognos Enterprise environment. For IT and business alike this means master data management and data governance from the enterprise to the desktop: unified business logic and terminology at every step of the way.

Time RollupsCognos Insight now has out-of-box functionality to build custom time dimensions or roll-ups. Populate entire years regardless of how sparse your data may be or customize it to match your organizations fiscal calendar.

High Fidelity PublishCustomers who also have IBM Cognos TM1 Enterprise can publish their Cognos Insight dashboards to Cognos 10.2 Enterprise as full-fledged, tabbed Cognos Workspaces. This means that Cognos Insight users can share their analyses with other Cognos Enterprise users who do not have Cognos Insight capabilities. This is huge from both a customer licensing and a usability perspective as prior releases required that any users who wanted to view an Insight dashboard must have Cognos Insight capabilities, which came at the higher Advanced Business Author licensing level. To view a Cognos Workspace a user need only be at popular Enhanced Consumer license tier.

 Cognos Workspace (Formerly Business Insight)

It seems a little strange to say we’re glad that IBM Cognos 10.2 delivers fewer “insights”, but the renaming of Business Insight and Business Insight Advanced to Cognos Workspace and Cognos Workspace Advanced respectively, is a welcome change. Hopefully this will help to ease some of the confusion that’s arisen in recent years among a myriad of “insight” labeled components in within the IBM Business Analytics solution portfolio. Along with this re-branding, come a number of useful new features.

Multi Tabbed WorkspacesA major enhancement to Cognos Workspace is the ability to easily create multi-tab workspaces enabling you to expand your workspace’s visual footprint without the need to scroll. With tabbed workspaces also comes a new control known as an Action Button which can be programed to trigger tab changes.

Freeze and Unfreeze Column and Row HeadersExcel users rejoice, they’ve added the functionality to freeze and unfreeze crosstab column and row headers while scrolling.

Data Visualization GuideAs mentioned previously, the theme of applied data visualization theory is a recurring one in Cognos 10.2. The new Visual Recommender in Cognos Workspace will help you to select the appropriate chart type based on the data values in your workspace, along with some insightful rationale for that decision.

Graduated CapabilitiesAdministrators can now assign graduated capabilities to the Cognos Workspace tool. Users can have the option of Authoring, Interacting or just consuming any Cognos Workspace. This is useful in controlling the available Cognos Workspace feature set for governance purposes, or to even further simplify the experience to drive adoption in a user population of diverse skill sets.

Other FeaturesCognos workspace 10.2 also brings support for printing and use in Google Chrome and Safari.

 Cognos Mobile
Cognos Mobile was a major focus in the 10.1 (General) and 10.1.1 (Refresh Pack) releases, with outstanding functionality and support across a broad set of devices. In 10.2 Mobile sees a few minor, but noteworthy updates.

Push NotificationsCognos Mobile now supports push notifications to the status IOS status bar in the iPad app – users can now be notified when a new version of their report is available, further reducing the latency in decision making on the go.

Improved Performance of Multi-page ReportsMulti-page reports can now be streamed to devices, reducing the loading time. Users no longer have to wait for the entire report to download before viewing.

Administrators Can Now Secure Mobile AccessA new mobile capability in Cognos Administration allows administrators to govern access to Cognos via Mobile devices. This has benefits from a governance perspective for all organizations that deploy Cognos Mobile, especially those that employ a Bring Your Own Device (BYOD) policy.

Report Studio

Report Studio, the work-horse of the IBM Cognos solutions suite, receives a few minor, but high impact updates in the IBM Cognos 10.2 Enterprise release.

Prompt APIThe new prompt API is a long overdue and welcome update to Professional Authors and Report Studio hackers everywhere. The API is 100% documented and supported, and like any good API can be expected to persist across future product renditions. The API provides a documented method for setting, reading, deleting and validating prompt values using JavaScript. The API is supported in Report Studio, Cognos Viewer, Cognos Workspace and Cognos Workspace Advanced.

Excel ImprovementsExpect improved Excel compatibility of Cognos report outputs with increased spreadsheet maximums to 16,384 columns by 1,048,576 rows. Cognos 10.2 also brings a brand new Excel output format called Excel 2007 Data which is perfect for lightweight data transfer to Excel without any report formatting.

Dynamic Cubes

By far the most exciting new feature in Cognos 10.2 is the addition of a new OLAP technology to the IBM Cognos solution suite which in conjunction with pre-existing OLAP options provides developers with the option of the right tool for the job at hand. The Dynamic Cube solution builds upon existing Dynamic Query Mode (DQM) functionality to close a major gap that exists in many vendor OLAP offerings: the organization with a large or mature star or snowflake schema data warehouse that wants to provide an OLAP experience to their users without sacrificing data details or high performance.

Here are a few highlights of this new feature:

     100% In-Memory OLAP Engine for a high-performance, low-latency user experience.

     Minimized access to the underlying data warehouse.

     Security aware caching features.

     Aggregate awareness to allow query routing to in-memory or physical aggregate tables in the data warehouse.

     Aggregate Advisor feature will monitor, recommend new physical aggregate tables, and even generate SQL/DDL.

     Uses a new OLAP modeling tool called Cube Designer that should be intuitive to developers with previous OLAP experience.

     Multiple cubes can share conformed dimensions.

     Use of Multi-Pass SQL is easy on data warehouse server resources and DBA’s alike.

     80 times faster than similarly modeled dimensionally modeled relational (DMR) data sources.

Transformer and PowerCube loyalists (ourselves included) can breathe easy as this new technology is not a signal of their decline. Dynamic cubes are meant to complement existing OLAP technology and provide developers with the most appropriate option for every scenario, rather than trying to force a one-size-fits-all solution.

Architecture and Environment Support
New Data SourcesWith every release we see exciting additions to the list of supported environments, and Cognos Enterprise 10.2 is no disappointment. You can expect full support for a number of new data sources, a few of which are listed below:

     Big Data Support: Hadoop / Hive via JDBC Connector

     SQL Server and Analysis Services 2012

     Salesforce.com (Native DQM)

     SAP ECC (R3) (Native DQM)

     Siebel (Native DQM)

The big news here is native support for Big Data and seamless integration with IBM InfoSphere BigInsights (Hadoop). Additionally, native support for a number of ERP vendors has been added to Cognos via Dynamic Query Mode for increased performance and reduced implementation complexity. Prior to 10.2, support for data sources such as Saleforce.com, SAP ECC and Siebel required a connector via Virtual View Manager (VVM).  We should also note that VVM 10.2 will be the final release of this solution, and while it will continue to be supported, developers should take note that it is now deprecated in favor of DQM.

100% 64 BitThese remaining 32 bit components of IBM Cognos 10 get an update for full 64 bit compatibility: BI Gateway, Metric Studio and Data Manager

Multi-Tenant SupportCognos 10.2 now supports native multi-tenancy. While this feature may not have mass appeal, it will be incredibly valuable to certain IBM Cognos OEM partners as well as organizations that have deployed Cognos in a federated manner and are looking to more easily segment different business units or sub-organizations within their shared IBM Cognos platform architecture.

Content ArchivingLast but not least, Cognos 10.2 now natively supports fully integrated content archiving to a file system. This feature will be coveted by organizations that have content retention and audit requirements that are looking to keep their Cognos content store free from large report outputs to maximize their environmental performance. This new feature has much of the same archival functionality that IBM FileNet customers have enjoyed since the 10.1.1 release

Some in depth information about the new features can be found in this webinar 

In this webinar you learn why Cognos 10 begins a new series of innovations for business analytics by expanding traditional business intelligence capabilities. You will learn how Cognos aligns information and the decision process so you can collaborate across the organization to turn data into insights.

IBM Cognos 10: The product vision, Eric Yau, Harriet Fryman and others explain the motivation and vision driving the creation of IBM Cognos 10

IBM Cognos 10.2 Overview:

Business Analytics Diagnostic Usability Matrix


IBM Cognos 10.2 New Features Presentations:

The following topics describe the new features for 10.2.0. 64-bit IBM Cognos gateway

 In earlier versions, if you installed 64-bit versions of IBM Cognos Business Intelligence, only 32-bit versions of the gateway component were available. In this version, 64-bit versions of the gateway are also available. You can take advantage of the 64-bit hardware and the new 64-bit libraries.

Configuration of multi-tenant applications in IBM Cognos Configuration

 You can use new properties in IBM® Cognos® Configuration to configure Business Intelligence environments supporting multi-tenant applications.

Predefined LDAP configurations

 In IBM Cognos Configuration, you can configure your environment by selecting from a number of predefined LDAP authentication namespace configurations.

Option to view the status of silent installations on the screen

 You can use the -displayLog option to view the status of the silent installation on the screen.

Option to initialize Cognos Configuration from a different file

 You can use the -startupfile path/filename.xml option to specify a startup file other than the cogstartup.xml file when starting the IBM Cognos configuration tool.

Listed below are features that are new in version 10.2.0 of IBM® Cognos® Business Intelligence.

Multiple tenant environments

Multi-tenancy provides the capability to support multiple customers or organizations (tenants) by using a single deployment of an application, while ensuring that each tenant can access only the data that they are authorized to use. Such applications are called multi-tenant applications. Multi-tenant applications minimize the extra costs associated with these environments.

Support for bidirectional languages

The bidirectional features supported by IBM Cognos Business Intelligence include bidirectional text, digit shaping, and object direction in reports.

Restricted access to Cognos Mobile

 You can now restrict access to IBM Cognos Mobile using the Mobile secured function.

Improved search with field-level search capability

 IBM Cognos Connection search delivers more relevant results, faster.

Excel 2007 Data report output format

 The Excel 2007 Data report output format enables you to generate native Microsoft Excel 2007 spreadsheets containing list report data for further manipulation.



 This is a 5 part series that takes a ground-up approach to designing reports for performance. Beginning with data access strategies and followed by metadata modeling tips, viewers will delve into various best practices for report design and learn how to ensure that reports are optimized for performance. Topics span various IBM Cognos Business Intelligence roles, including administrators, metadata modelers, and report authors.

This video contains the introduction and data access strategies.

For more IBM BA Proven Practices content, please visit http://www.ibm.com/developerworks/analytics/practices.html

Data Science Central - The Online Resource for Big Data Practitioners

IBM Dev Ops

 Big Data News:

IBM Cognos 10 - Collaborative BI
See a full product demo using IBM Cognos 10 BI and IBM Lotus Connections here: http://bit.ly/gOTlg1

The Boeing Company chooses IBM Cognos 10
Even the BEST BI cannot prevent manufacturing errors from third party suppliers, but can help analyze the weak spots. Think of the battery problems from Boeing, IBM BI certainly can help analyze and pinpoint the issues to look at for you. Just ask the right questions with your BI solution. Big Data or Data Warehousing IBM Cognos 10 can help you with IBM DB2 10.5.

Analytics: the real-world use of big data
This new study, from the IBM Institute for Business Value in partnership with the Saïd Business School at the University of Oxford, explores how organizations are leveraging big data to create competitive advantage in the marketplace and reflects input from more than 1,100 business and IT executives, in 95 countries, combined with executive interviews and case studies.

To download this study, go to http://www.ibm.com/2012bigdatastudy

Understanding the Impact of Smarter Analytics

IBM Smarter Analytics tranforms organizations by providing access to all information, delivering insights to all people, and improving all decisions (from tactical to operational). Learn more: http://www.ibm.com/SmarterAnalytics


Take test at:

Next Steps:

For more information please contact me at:

Drs. Albert Spijkers
DBA Consulting
web:            http://www.dbaconsulting.nl
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook

email:          info@dbaconsulting.nl