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 and RedHatConsulting

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

Microsoft Consulting

For all Microsoft related consulting services.

Citrix Consulting

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

Welcome to DBA Consulting Blog. The specialist for IBM, Oracle, Novell, RedHat, Citrix and Microsoft.

DBA Consulting is a consultancy services specialist who can help you with OS related support and migration and install. Also BI implementations from IBM like Cognos 10 and Microsoft BI like SQL Server 2008, 2012 and the CMS systems releated to it like Microsoft Sharepoint and Drupal and Oracle OBIEE 11R1. We focus on quality and service and customer whishes are central, just like quality of services and customer satisfaction. Our focus on cost savings and no vendor lock in are central in business values.

Oracle related video's


Saturday, April 12, 2014

Going Mobile with Oracle ADF Mobile

Going Mobile with Oracle ADF Mobile

A Java & HTML5 Based Framework for Developing Mobile Applications

Oracle ADF Mobile enables developers to build and extend enterprise applications for iOS and Android from a single code base. Based on a hybrid mobile architecture, ADF Mobile supports access to native device services, enables offline applications and protects enterprise investments from future technology shifts.

ADF Mobile Overview

Building Mobile Applications with Oracle ADF Mobile

ADF Mobile Tutorial

Oracle Mobile - Simplify Enterprise Mobility

Oracle Mobile is about simplifying enterprise mobility giving customers complete mobile solution and the choice and flexibility to develop their own unique enterprise mobile strategy. Whether you prefer turnkey mobile applications, or decide to develop and extend your existing enterprise applications, Oracle provides the platform, security and applications to meet your mobile enterprise needs.

Mobile Platform

Enterprises need to easily create and deliver engaging user experiences on one secure platform, for any application, for any device, and around any data. To build mobile applications for enterprise systems, developers need to be able to easily define mobile interfaces and APIs, and to extend applications to enterprise data and back-end services via the cloud. Oracle’s mobile platform provides these capabilities, empowering developers, IT, and the business to deliver highly engaging mobile and cross channel experiences.

Mobile Platform

Mobile Security

In today's connected world, organizations must effectively manage the end-to-end lifecycle of user identities across all enterprise resources, within and beyond the firewall, and into the cloud. Oracle's mobile and social access service helps organizations strengthen security, simplify compliance and capture business opportunities around mobile and social access.

Mobile Security

Mobile Applications

Organizations across all industries are looking for robust and powerful applications that are tailored to mobile devices and can provide their people with anywhere, anytime access to enterprise information. To give the mobile workforce easy access to mission-critical information, Oracle offers a wide range of out-of-the-box mobile applications, as well as the option of leveraging the Oracle Mobile Platform to develop their own mobile applications.

Mobile Applications

Oracle Mobile Enterprise

Oracle ADF Mobile Samples

The Oracle Mobile Platform Blog

Oracle ADF Mobile Tutorials

Oracle ADF Insider  - Learn Oracle ADF Online:

Oracle ADF Mobile Overview 

Introduction to ADF Mobile

A presentation by Oracle Development Tools Manager Shay Schmeltzer, from OTN Virtual Developer Day: Mobile Development for iOS and Android.

Preparing to Go Mobile: Oracle ADF Mobile and Developing for iOS and Android

Shay Shmeltzer's keynote presentation from Oracle Virtual Developer Day: Mobile Development for iOS and Android.

Oracle ADF Mobile Demo for Developing Hybrid Mobile Applications

Key benefits and features of Oracle ADF Mobile for developing hybrid mobile applications across multiple device platforms.

Oracle ADF Mobile Overview

Oracle ADF Mobile is a Java and HTML5 based mobile development framework that enables developers to build and extend enterprise applications for iOS and Android from a single code base

Overview of ADF Mobile

ADF Mobile provides a way of quickly developing on-device applications for Android and iOS. In this video you can see and overview of the technology and a demonstration of how you can build ADF Mobile applications.

Learning Oracle's ADF:

This 90 minute recording introduces the concept of ADF unbounded and bounded task flows, as well as other ADF Controller features. The session starts with an overview of unbounded task flows, bounded task flows and the different activities that exist for developers to build complex application flows. Exception handling and the Train navigation model is also covered in this first part of a two part series. By example of developing a sample application, the recording guides viewers through building unbounded and bounded task flows. This session is continued in a 10 part playlist intro into ADF.

For More Information:

DataSheet Oracle ADF Mobile:

Going Mobile with ADF – Implementing Data Caching and Syncing for Working Offline Part I

Going Mobile with ADF – Implementing Data Caching and Syncing for Working Offline Part II

Going Mobile with ADF – Running ADF Faces on Mobile Phones and Tablets

Going Mobile with ADF: Programmatically Invoking SOAP Web Services with Complex Types

Going Mobile with ADF – Implementing Data Caching and Syncing for Working Offline Part I


For more information:

Drs. Albert Spijkers
DBA Consulting
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook


Friday, April 11, 2014

Oracle Big Data at Work

Oracle Big Data at Work
The term big data draws a lot of attention, but behind the hype there's a simple story. For decades, companies have been making business decisions based on transactional data stored in relational databases. Beyond that critical data, however, is a potential treasure trove of less structured data: weblogs, social media, email, sensors and photographs that can be mined for useful information.
Demystifying Big Data for Oracle Professionals

This short video uses the simple analogy of a fishing trawler to explain big data, and the steps involved in gaining competitive advantage by combining new sources of data within existing, structured data.

Big Data: datafication of everything -- the capture and use of more data in more activities. There's huge opportunity there, but the world's ability to produce data outstrips most companies' ability to use it. Close this gap with Oracle Big Data.

Oracle Academy Big Data Roundtable

Listen to Oracle experts discuss the growing field of Big Data. Learn about the skills required to pursue a career in Big Data as well as the types of opportunities available to Big Data practitioners.

Big Data Analyst Report

This free report goes beyond buzz words and tells you who is using big data, how they are using it, and what the future holds.
Download this free report from EMA to learn how companies are putting Big Data to use.

Limited Edition Exadata X4-2C - Brighten Up Your Data Center
For a short period only, Oracle is offering its data warehouse customers the chance to buy a limited edition EXADATA X4-2C. This new Exadata configuration is going to brighten up your data center with its exciting range of color coordinated racks! Now you can enjoy running those really sophisticated business queries in glorious technicolor. Most importantly, the great news is that we are not charging you anything extra for this fabulous new technicolor data warehouse experience:

Each color-coded rack comes with its own color-linked version of Enterprise Manager to add more colour, brightness and joy to all those day-to-day tasks as you can see below on these specially designed monitoring screens: 

 Your Exadata DBA is really going to thank you!
So what happens if you buy a 1/2 rack then slowly add more Exadata nodes? Great question - well, while stocks last you can actually create your own multi-colored Exadata rack. As always we are ahead of the game because we know what our customers want. SO WHY NOT HAVE A  TECHNICOLOR DATA WAREHOUSE in your data center! Go on, you know it makes sense….

BUT YOU GOTTA HURRY - This new Exadata X4-2C range is a limited edition, special order only model. Stocks are limited. To brighten up your data center make sure you contact your Oracle Sales Representative right now because you do not want to miss out on this exciting opportunity to put one of these gorgeous, colour-coded dudes in your data center. And don't forget, only Oracle gives you  HARDWARE, SOFTWARE AND COLORENGINEERED TO WORK TOGETHER

An Overview of Oracle Big Data, BI and Analytics Solutions Heretofore Oracle has taken big swings at big data with several of its Oracle Engineered Systems, also known as appliances, such as Exadata, Exalytics and the Big Data Appliance.  The appliances have met with a fair amount of recent success.  Oracle CEO Larry Ellison crowed about that success in Oracle’s fourth-quarter earnings call on June 20 when he stated, “All our Exa products, Exadata, Exalogic, Exalytics and the Big Data Appliance and the Oracle Database Appliance, all had their best ever quarters.”  Even though Oracle’s hardware numbers were down 11 percent year over year for the quarter, and new software license revenues were up only 1 percent, big data-related growth had to be one of Oracle’s bright spots. 

Oracle’s software lineup remains the same it has for the past several years, albeit with updates to better deal with big data and Hadoop scenarios.  The core products include:
  • Oracle Data Warehouse (which in fact runs on the Oracle database)
  • Oracle Essbase used mainly for OLAP
  • Oracle Hyperion which is most well known for enterprise performance management BI/analytics
  • Oracle Endeca, which some use for customer discovery analytics purposes
  • A long list of role-oriented and industry-oriented analytic apps
  • Oracle Business Intelligence

OBIEE, or Oracle Business Intelligence Enterprise Edition, packages a fair amount of the above mentioned offerings.  In terms of key partnerships, Oracle has a close relationship with Cloudera, which supplies the Hadoop distribution delivered through Oracle, and related services.  Oracle has also continued to invest its own Oracle NoSQL Database, which offers the key-value store technique often used in advanced analytics.  The Oracle NoSQL Database is included along with open source R, one of the most popular statistical programming languages, in its Big Data Appliance.  And some will cite Oracle Times Ten database, an in-memory database established years before SAP HANA came to market, that is the database engine behind Exalytics, as participating in the big data race.

But the Oracle database remains the keystone in any Oracle shop, and it is an inescapable element in the big data endeavors of those shops – either as a primary data source, or as a data warehouse, or for analytics processing, or as a data mart or dataset repository.   Where does Oracle Database 12c fit into this big data Oracle technology picture?   There are two cases of low hanging fruit.
A Rapid Way to Make Oracle Data Warehouse More Rapid
One initial big data opportunity most organizations will discover for Oracle Database 12c involves using 12c to your advantage for Oracle Data Warehouse (ODW).   In particular, long-standing ODW implementations grow stale and slow unless they are closely tended to, perhaps because of too much unnecessary historical data, or perhaps using what once was an appropriate but is no longer a well-fitted infrastructure, or perhaps because it is handling too many complex queries.
Data analysts, data scientists and DBAs will have the opportunity to split out individual data marts from an ODW implementation, and allocate the data marts as pluggable databases in the Oracle Database 12c container.  In Oracle Database 12c parlance, the container database is what allows for multi-tenancy.  It handles the background and overhead processes, such as memory or storage management, for multiple databases that are plugged into a single container.  But each pluggable database contains its own metadata, actual data, and any embedded code like triggers, wholly contained.  Also, each pluggable database may receive its own priority, so the container knows which database(s) should receive more memory to speed along processing, for example.
Using this technique, organizations may finely tune data ingest and query resources of ODW for various BI and analytics purposes.  And in Oracle 12c, “spinning up” a pluggable database in a container literally takes seconds, and changing priorities are a simple, real-time task.  Thus, one data mart might need all the resources the container can muster for one day mid-month, literally having its day in the sun in terms of resource allocation using Oracle Database 12c, and then you could move the data mart to the back of the queue for the rest of the month.  Similarly, during intensive warehouse periods of data ingest, DBAs may pop up the priority of the effected databases with more temporary horsepower.  Similarly, this splitting of a larger ODW into data marts may service the requirements of multinationals as well, in terms of local rules and regulations about data privacy, but also to put the data required for BI or analytics closer to the user base.

Oracle Database 12c to the Rescue of Development and Test
When data analysts, data scientists, and DBAs develop dashboards or models, BI and analytics assets that will become permanent business assets, there is a development and testing process.  Figuring out the design of a durable final dataset may take months.   Ensuring that the data ingest and refresh is utterly accurate and performs as necessary takes many iterations.  And the analytics visualization decisions will cycle through plenty of testing and refinement, hopefully with a sample of the final business user(s) in tow to ensure they are comfortable with the visualizations when they go live.  In short, producing small, medium, or big data that helps the organization’s decision-makers takes plenty of development and testing.
It is literally easy to provision new databases for data marts and/or full warehouses with Oracle Database 12c; your DBAs may need to find a few other tasks to keep them busy during your analytics project.  Need to offer up the warehouse to multiple developers and/or testers on tight schedules?  Cloning is a snap.  Want to replicate a production warehouse to a test warehouse to ensure testing is based on the latest data?  Similarly, replication has taken a big step forward in the world of Oracle databases with Oracle 12c.  Want to run an operational data store that directly reflects a production database, but is not the production database?  Oracle Database 12c offers a full set of technologies to make that happen, but also the features to ensure the production database still receives the resources it requires above the operational data store, even inside the same container.   In short, expect to reduce the time you estimate for BI and analytics projects using Oracle-centric data stores.

For more information:

Drs. Albert Spijkers
DBA Consulting
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook


Monday, March 10, 2014

NetScaler Application Delivery Controller

NetScaler Application Delivery Controller

Introduction to Citrix NetScaler SDX

High performance hardware with a flexible virtual architecture Citrix NetScaler SDX is a true service delivery networking platform for enterprise and cloud datacenters. An advanced virtualized architecture supports multiple NetScaler instances on a single hardware appliance, while an advanced control plane unifies provisioning, monitoring and management to meet the most demanding multi-tenant requirements—all with the industry-leading performance of the Citrix NetScaler MPX system architecture. Full resource isolation supports guaranteed performance SLAs as well as high availability, software version control, data separation and independent policy management. Providing a foundation for the consolidation of services in the enterprise, NetScaler SDX is also optimized to deliver next-generation cloud-based services.

Citrix Unveils NetScaler Control Center for VMware

NetScaler Control Center is a next generation cloud networking automation solution for integrating NetScaler SDX, VPX and MPX with cloud orchestration platforms. This solution automates deployment and configuration of NetScaler functionality within virtualized networks, particularly on the VMWare NSX network virtualization platform.

For more information please visit

For more information:

Drs. Albert Spijkers
DBA Consulting
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook


SQL Server 2014 CTP and Data-intensive Applications in the Cloud Computing World

Data-intensive Applications in the Cloud Computing World

When we first started working with customers writing cloud-based data-intensive applications, most would use a relational database like Windows Azure SQL Database for all data storage, including telemetry data.  This could be expected because developers often use the tool(s) they are most familiar with, TSQL provides a quick and well-known interface to get data in and out of the database, and relational databases generally take care of threading and concurrency for developers.  At the time, the default thinking was that most data belongs in a traditional relational database where data is always stateful and carries atomic transactional properties.  However, in the distributed cloud computing environment, scale will likely come from the implementation of stateless as well as stateful data properties.  The new paradigm shifts us away from the use of a traditional RDBMS for all data.

SQL Server 2014 Faster Insight from Any Data

An Example

Let me show you an example of a cloud application where multiple data stores are used.  The architecture is for an online gaming experience.  This application is designed to manage several thousand concurrent users and can scale out at several points, as needed.  After the diagram, I will explain the different functions of the application, the type of data store used for each function, and why that particular type of data store is used for that function.  As I describe each function, I will refer to a number in the diagram as a reference.

Function: Login and Initialize Profile — Looking at the bottom of the diagram, you see three users; let’s start there.  These users log in and their sessions are assigned to a Windows Azure web role (#1).  The web role hosts them while they are active on the system.  The first step is to authenticate them and bring their profiles into Windows Azure Cache (#5).  Their profiles are stored in Windows Azure SQL Database (#2).  Complex queries retrieve profile data from the SQL Database by joining data (game history, scores, activity, etc.) from multiple relational tables to store in the Cache.  A relational database is best suited for this type of persistent storage and complex query activity.  The user profile also needs to be updated when information changes, so the same types of complex transactions are required to update the information back into the SQL Database.  This is a good example of where a traditional relational database is best utilized as your data store.

Function: Play Games and Perform Online Activities — After the users are logged in and their profiles are in Cache, they can start the gaming experience.  As you might expect, the gaming experience will be all in Cache (#5).  The Cache is a high performance data store and is the obvious place to store active game data.  Because Cache is non-durable, leaderboard, profile, and friend information is pushed out to other data stores for persistence.

Function: Documenting and Updating Activities — All active game activity is recorded while the users are playing, and this activity needs to be durable during play while constantly making changes to it.  Activity data is stored in a Queue (#4).  This is a durable Queue, so unlike the Cache, activity data is not lost if an outage takes place.  Data stored in the Queue is processed by “activity processors” (hosted as Windows Azure worker roles) that process the data, carry-out application logic, and persist results and history.

Function:  Activity History — For each user, all activity is stored and kept as history.  Activity history is persisted on a periodic basis from the active Queue (#4) to a NoSQL store (#3).  This NoSQL store rests in a table, using Windows Azure Table service.  The table is used because the data is mostly write-only, with a requirement to easily grow in place with little need for complex query activity against it.  So, the Table service is the best store for this type of data activity.

Function: Friend Interaction and Leaderboard — While users are playing, they can communicate and interact with friends (other users) in the system.  They also might want to keep tabs of the leaderboard.  Friend and leaderboard data changes often but not constantly, so this data is best stored in an Azure SQL Database (#7).  The relational database is updated often, and the “cache tasks” role continuously pulls the latest information and ensures the active cache (#5) is always updated with the latest leaderboard and friend information through a query to the SQL Database.

Function: Data Warehouse — All user profile data and activity data is stored in a data warehouse (#6) for reporting purposes.  Unstructured data from the Azure Table service is stored in Hadoop (Windows Azure HDInsight), and structured data is stored in a relational data warehouse (Azure SQL Database).

Breakthrough Data Platform Performance with SQL Server 2014

SQL Server 2014 Mission Critical Performance


In summary, you can see that this single application uses five different data storage options:  Windows Azure Cache, Azure SQL Database, Azure Queue service, Azure Table service, and Azure HDInsight (Hadoop).  Each type of store was chosen because it represents the best option for the transactional needs of the operation being executed:

 - Windows Azure Cache is used for performance (non-durable).
 - Azure SQL Database is used for strong transactional consistency and for complex query needs.
 - Azure Queue service is used for performance with heavy activity (durable).
 - Azure Table service (NoSQL) is used for heavy inserts (write-only) and the need to grow easily
   and quickly.
 - Azure HDInsight (Hadoop) is used for reporting against unstructured data.

If this was an on-premise application, you could have used multiple data stores, too, but the overhead of procurement, installation, and configuration of all of these sources adds time and money to your solution.  As the diagram below suggests, with only a couple of clicks in the Windows Azure portal, you can have any of these data sources installed, configured, and up and running.

SQL Server 2014 Platform for Hybrid Cloud

Envisioning Microsoft Business Analytics

More information:

What Drives Microsoft's Data Platform Vision?

Try and Explore SQL Server 2014 for your self:

For more information:

Drs. Albert Spijkers
DBA Consulting
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook


Sunday, March 9, 2014

XenMobile Management 8.5

XenMobile Management

Complete enterprise mobility management (EMM) including mobile device management, mobile application management and enterprise-grade productivity apps

XenMobile enhances the user experience on BYO or corporate devices without compromising security. Unlike other mobile device management (MDM) and mobile application management (MAM) products, XenMobile provides the quickest path to productivity for mobile users with the lowest cost of ownership.

   -  Deliver enterprise-grade email, browser, file share, sync and editing users won’t reject
   -  Deliver mobile, Windows desktop, SaaS and web apps from a unified corporate app store
   -  Secure data with a FIPS-compliant container

1) Email, web browsing and file sharing with secure mobile apps

Deliver a rich user experience with Citrix-developed apps. Use WorxMail for secure email, calendar and contact access, WorxWeb for secure browsing and ShareFile for enterprise data sync.

2) Mobile application management with the largest ecosystem of business apps

XenMobile securely delivers Worx Mobile Apps, the industry’s largest collection of apps built for business. The Worx App SDK empowers the developer’s ability to add critical enterprise security features.

3) Deliver enterprise grade mobile device management

Configure, secure, and support mobile devices with MDM. Protect company data on any device or corporate asset by troubleshooting and selectively wipe any device if lost, stolen or out of compliance.

4) Protect company data with mobile device security

XenMobile FIPS-compliant secure container provides app data encryption on the device while separating personal and company information. XenMobile also offers a micro app VPN for over-the-air data transmissions that fully encrypts and protects company data.

5) Deploy on premises or in the cloud

XenMobile on-premises and XenMobile in the cloud deliver the same features, offering the flexibility to choose the best deployment option for your organization. XenMobile cloud multi-tenancy provides peace of mind with secure, dedicated instances and globally redundant infrastructure.

Compare XenMobile to the competition

XenMobile offers a complete solution for managing apps, data and devices. Whether your organization is replacing BlackBerry devices with BYO, finding a Good Technologies replacement due to poor user experience, or looking for a mobility solution that delivers more than just mobile apps, XenMobile provides a comprehensive set of capabilities that meets any mobile requirement.
The complete enterprise mobility solution

Only XenMobile provides a comprehensive enterprise mobility management solution that offers all of the following benefits:

What's new with XenMobile

XenMobile delivers employees applications including native mobile, Windows desktop, SaaS, and web while providing IT organizations a secure, scalable and cost-effective solution to manage complexity and cost in the mobile world.

Mobile users get more work done in less time

XenMobile enhancements to mail, calendar and contacts make mobile users productive on the go:

    - Fast join enables users to automatically launch and join GoToMeeting, Microsoft Lync and
      WebEx sessions directly from their calendar
    - Fast dial allows conference bridge numbers and participant IDs to be auto-dialed and entered
    - Mobile users can access work faster with fast auth and quickly access business apps from their
      mobile device by simply entering a PIN instead of complex Active Directory passwords that
      require capital letters, special characters, etc.
    - Two-factor authentication can be enabled via Active Directory certificates
    - Integrated contact support for FaceTime and SMS

IT organizations can respond faster and more easily to the changing needs of their business.

XenMobile simplifies enterprise mobility deployments across the varied platforms and devices that users bring into organizations. With the latest version of XenMobile, it's easier than ever for IT to configure and roll out mobility deployments, coupled with even more security capabilities and support for more mobile devices, data, apps and networks.

    - Quickly mobilize remote offices with wizards-based deployment
    - Enable day-one productivity and easily onboard new business units or subsidiaries via
      multi-domain support
    - Integration with Windows 8.1, Apple iOS 7 MDM APIs as well as Samsung KNOX and
      Amazon MDM platforms extend the 60+ application-specific policy controls of XenMobile
    - New support for HTML email, Lotus Notes and Office 365 enhances existing WorxMail
    - Enhanced SSO with Kerberos authentication and pin-based certificates to deliver advanced
      app authentication policies
    - Information rights management (IRM) policies for WorxMail to help control message attributes
       and expiration for highly secure environments

Flexible cloud deployment options

All three editions of XenMobile can now be deployed in the Cloud, hosted by either Citrix or a Citrix Strategic Partner. Citrix strategic partners extend the value of XenMobile with valued-added managed and consulting services that enable robust, integrated enterprise-ready mobility solutions.

Citrix XenMobile MDM is the market-leading enterprise mobile device management (MDM) solution.

Get the 10 Must Haves for Secure Enterprise Mobility:
Get the 10 Must Haves for Secure Enterprise Mobility

For more information:

XenMobile Overview

Citrix - Integrating mobile device management (MDM) in the enterprise 

Citrix XenMobile MDM is one of the industry's most innovative and secure mobile device management (MDM) solutions. Get an in-depth look at how XenMobile MDM snaps into your existing enterprise IT environment. We will cover managing security groups in Active Directory, integration with Exchange mail infrastructure and incorporation of mobile into SIEM or log management tools. Learn more at

For more information:

Drs. Albert Spijkers
DBA Consulting
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook


IBM Videos