MS Excel spreadsheets as a data source in Informatica PowerCenter


Informatica Power Center can use different sources of data. The most common sources are tables, views or synonyms, but for storing small sets of data, companies usually use flat files, MS Excel files or MS Access. Informatica treat Excel and Access file sources as a relational database, not as a flat file.

 Which steps do we have to follow to load this data from these files to our Data Warehouse? How are the connections created? Where do these files have to be located? How should we configure Informatica?

 In this article I will explain the way to load data from Excel files using Informatica Power Center running on Windows.

  Continue reading this post >

Webinar Registration | Building KPI’s & Scorecards with OBIEE 11g


Reserve your spot today and register to our webinar on Building KPI's & Scorecards with OBIEE 11g.  

In this webinar you will learn how to build KPI's & Scorecards using this new feature from OBIEE 11g. Create Strategy Trees and Maps, Cause & Effect Diagrams, define the Mission & Vision of your organisation etc., and visualise this information in a state-of-the-art user interface that will improve decision making at all levels of your organisation.

Scheduled Webinars for Building KPI's & Scorecards with OBIEE 11g:

Tuesday, February 14th, 2012, 10:00 AM - 11:00 AM CEST

Register Here

Wednesday, February 15th, 2012, 4:00 PM - 5:00 PM CEST

Register Here

Continue reading this post >

OBIEE 10g High Availability


Sometimes there is a need to have OBIEE system operating during planned or unplanned downtime. Because of this reason OBIEE provides a high availability capability: it is possible to configure all OBIEE components in order to offer high availability. In this entry I am going to describe the process of configuring a high available OBIEE 10g system.

Before going to the configuration I want to clarify some concepts:

Availability is the degree to which an application, service, or function is accessible on demand. Based on this concept we can conclude that High Availability is a system continuously operational as long as possible.

High availability systems can be categorized into local high availability systems which are configured in a single data center and disaster recovery solutions systems which are usually geographically distributed. OBI Server only can be configured in the first case; all components of the BI Cluster Server feature must reside on the same LAN.

High availability comes from redundant systems and components. Local high availability solutions can be categorized, by their level of redundancy, into active-active where two or more active instances are working at the same time and active-passive where only one instance is active and others are in standby.

OBIEE provides for high availability through the use of native clustering, failover and load balancing capabilities. Let’s analyze the OBIEE 10g components and how they are communicated in a clustered environment.

Continue reading this post >

privacy policy - Copyright © 2000-2010 ClearPeaks