When it comes to choosing the right data integration solution, Oracle offers multiple products that may seem redundant but in fact target different purposes even though an overlap in the capabilities exists. Oracle clarified the distinctions among the various integration products during the Collaborate 16 conference this year. The decision making process around which […]
Posts Tagged ‘ETL’
Continuous Integration in the Analytics Project
Many people may have known that Continuous Integration (CI), Continuous Delivery (CD) is great part of the agile activity. In the Java related project, there were lots of open source tool such as Hudson, Continuum, Jenkins etc to support this automation process. However, if you are going to look for some tools to support the […]
10 Healthcare Analytics Trends for 2016: Trend #5
TREND #5: UTILIZE REUSABLE ACCELERATORS TO QUICKLY ACHIEVE ACTIONABLE DATA-DRIVEN INSIGHTS One of the keys to a data-driven organization’s success is interoperability of all data systems. Data integration is not only critical for making sound business decisions but it is also the cornerstone to understanding and engaging with consumers. For healthcare organizations, integrating data is […]
Oracle BI Cloud Service (BICS): Data Sync for Automated Data Load
In a few days Oracle will release Data Sync, a utility that facilitates the process of loading data from various on-premise sources into BI Cloud Services (BICS). The Data Sync utility comes as an addition to several other already available means of loading data into BICS: data load wizard to upload data from files, SQL […]
3 Options for Migrating Safety and Pharmacovigilance Systems
Deciding “if, when or how” to move from one safety application to another can be a daunting task full of angst, pressure and fear of the unknown. Arguably, most of this distress is experienced in the initial analysis of the migration options and sifting through the solutions available to an organization. This blog entry will attempt […]
Virtualization – THE WHY?
The speed in which we receive information from multiple devices and the ever-changing customer interactions providing new ways of customer experience, creates DATA! Any company that knows how to harness the data and produce actionable information is going to make a big difference to their bottom line. So Why Virtualization? The simple answer is […]
Getting to know Oracle Data Integrator (ODI)
As an avid user of IBM DataStage for over 8 years I was recently on a client engagement where I had to use Oracle’s Oracle Data Integrator (ODI). At first I was disappointed as I was out of my confront zone. But after a week or two I was very surprised how quickly I was […]
What’s new with IBM InfoSphere Information Server Version 11.3
Well I know I’m a little late on this but I figured if you haven’t heard already this would be a great blog post to inform you of the latest update to IBM’s InfoSphere Information Server Version 11.3. For those that don’t know IBM’s InfoSphere Information Server Version 11.3, the following platform is made […]
Looping through files in a folder using ODI
On a recent project, I was faced with a requirement to scan the contents of a folder and load all the files into their respective staging tables. There were multiple file types – Customer file, Store file, Products file, Sales file, etc. Every day, we received zero to many files for each type of file. […]
Data Indiscretions
Data loaded into a TM1 or SPSS model will, in most cases, include files consisting of thousands (or hundreds of thousands) of records. It is not reasonable, given the number of fields and records in files of this size, for you to visually inspect all fields in every record (of every file) for missing or […]
Microsoft Cloud BI: Azure Virtual Machines, pt 2
In the last post in this series, we looked at why Azure Machines are the most likely candidate for workable SQL Server-based cloud BI implementations. Today, we talk turkey about actual limitations and things you need to know as you look at a potential solution in this environment. The first thing to know is that Azure […]
Automation of Cognos TM1 Data Loading
In one of my earlier posts I recommended an approach for loading larger amounts of data into TM1 applications, and provided a high-level explanation of this approach, which I call the “File Route” solution. Some More Thoughts I like this load-strategy because, in following best practice guidelines, it leverages TM1’s proven ETL tool, TurboIntegrator to […]