Data + Intelligence

“What’s new?” is an interesting and broadening eternal question, but one which, if pursued exclusively, results only in an endless parade of trivia and fashion, the silt of tomorrow. I would like, instead, to be concerned with the question “What is best?”, a question which cuts deeply rather than broadly, a question whose answers tend […]

The three best things about MicroStrategy 10.6 If you’re like me, you nerd out a little bit when any software upgrade comes out. The list of enhancements can make me think “Wow, what an amazing innovation! I can’t wait to tell my friends” or, on the flip side, “FINALLY! They fixed the problem, it’s about […]

 “A pixel is worth 1024 bits” In recent years, Organizations are pivoting towards the hottest keyword “BigData” to handle a wide variety of enterprise and social media data. Massive volume, complex and unstructured datasets are beginning to reshape many of the industries and hence the big data initiatives and implementations are priorities for many. Macy’s […]

CIOs are key contributors of new business models and organizational strategy. Data is the key asset for CIOs and CDOs to have a seat with the CEO, CFO, and CMO. In addition to unstructured data collection like social media and machine data, companies have started to consume strategic market competition data such as benchmarks, new […]

For people who write, edit, update or otherwise create and maintain web content, moving to a new enterprise CMS can be a pretty exciting process.  I’ve never met a content author or publisher who didn’t want at least a little something more from their authoring interface.  Typical questions and comments include: “Can we make it […]

Typically, the customization of the Atomic Warehouse Model is driven by the customization performed on the Business Data Model in the context of a project. And if a preexisting element of the Business Data Model got customized, the customization needs to be reflected accordingly into the Atomic Warehouse Model. Or Dimensional Warehouse Model have the […]

Here are the blogs that I have posted previously as part of my blog series on Oracle DataSync (BICS). Best Practice to ETL with Data Sync (BICS) In this blog, I am going to talk about three different ways to integrate Oracle ERP Cloud data with Data Sync (BICS) through OTBI.         […]

Introduction In today’s fast paced world, Organizations have started using different types of software systems to compete and to be up to the speed of the world. This eventually increases the need for communication between different software systems and the same is growing by leaps and bounds. And with the Current data warehousing and data […]

XML files, being the most popular way for data transportation, could be the most sought ought way by many clients for moving the data around. Hence, it becomes inevitable for one to know how to create/parse/transform XML files in an ETL tool like IBM datastage. In this blog, we will look at how we could […]

As Simon Sinek pointed out, “people want to do business with you because of why you do what you do.” The story of Steve Jobs revolutionizing the marketing of Apple products and building a cult of Apple loyalists is timeless. This is the age of the customer and word of mouth is the best marketing […]

In this blog, I will finish the Best Practice to ETL with Data Sync (BICS) post by showing you how to configure the Data Sync to load data in staging database. First, set up a new database connection in Data Sync for SQL Server or Oracle database. For SQL Server > Set Connection Type to MSSQL > Fill in the rest […]

As Oracle BI Cloud Service (BICS) starts to become popular, I am going to write a series blogs about best use of the Data Sync to upload data to BICS schema service.  In this post, I am going to share with you a best practice to use Data Sync for ETL. As an ETL tool, Data […]