Monday, November 30, 2009

BI StepByStep - SSIS Calling a WebService (Option 1)

Dear Friends,
There is lot of issues in the EE and MSDN communities relating to calling a webservice from SSIS. For thatSSIS Calling a WebService reason, I decided to write a new technical paper concerning to the subject.

And as I told before, technical papers and discussions, will be posted on the BI Community (

And you can also directly download each paper from here:


StepByStep - SSIS Calling a WebService with Web Service Task (Added 30-11-2009)

I hope It can help you!

Thursday, November 12, 2009

BI Certifications - CBIP/TDWI Certifications done!

I started writing this post on the return trip to Portugal. It was a very enriching and experience trip, which I reached one more objective I had in mind for more than two years. I passed the four exams and got the specialization in Business Analytics and Data Management provided by The Data Warehouse Institute (TDWI -

To whom I dedicate this achievement...I'd like to dedicate the achievement of this goal, besides of course my family and girlfriend who accompanied me on this trip to Germany, two very special persons.
Maria Jose TrigueirosFirstly, to Mrs. Maria José Trigueiros for all messages and follow that gave me along the master. Secondly, to my master adviser Mr. Orlando Belo, who accompanied me on a daily basis during the dissertation. These two persons, directly and indirectly supported me in the last two years, and for sure without them, it would be difficult to maintain my motivation and strength to deepen my knowledge in this amazing world of Business Intelligence.

The exams…Relating to the exams, what I felt was that in fact, the level of difficulty is high and mainly because there is less than a minute to answer to each question. There are 110 questions to be answered in 90 minutes ... Each question has 4 possible answers, where two of them are usually very similar and can be confusing ... When the "mother" language is not English, is even more complicated because some questions and their answers are long.

Fortunately, I was lucky to begin with the apparently the less complicated exam to make, and it allowed me to understand the time management that should be looked at, in order to do other exams. To get an idea, in the first exam when I had only 5 minutes to finish, I had 20 questions to answer... it was an authentic stress and the last question was answered over the last second ... There's no time to think and go back to review the answers ... that is, or you known the answer and quickly respond to a question, or it will be better to go ahead to next question!

It is difficult to describe the best way to prepare for the exams ... Normally the scope of a normal exam it’s a well-defined scope and the issues are related to the context and usually reading a book or two is enough. But in CBIP/TDWI exams it is quite different... you need to have a real-world experience and read several (many) books. But for the preparation and bibliography to make the CBIP exams, I’ll prepare/describe in a future post.
I made and passed in four exams: Information Systems (core), Data Warehouse (core), Business Analytics and Data Management that turns me a specialized professional in Business Analytics and Data Management. The more complicated exam was the Information Systems which is too much technical and detailed.

TDWI Germany Centre...It all started at 8:00 in the morning of last Friday (06-Nov-2009)... in the TDWI Germany centre, located about 30 km’s from Cologne (Germany) where I was accommodated with my girlfriend Joana.
The facilities of the centre are very good and the staff really fantastic, especially Simmone and Mr. Guenter Fuhrmeister, CEO of SIGS DATACOM (TDWI Partner) ... They both received me very well and they greatly reduced my stress caused by so many tests on the same day. In addition to all the sympathy and coffees, snacks, drinks, and others... they offered me an amazing book that I will start reading during this week, wrote by Frank Buytendijk. (Click on the book image to preview the book)

The Cologne city...Cologne (German: Köln) is Germany's fourth-largest city after Berlin, Hamburg and Munich, and is the largest city both in the German Federal State of North Rhine-Westphalia and within the Rhine-Ruhr Metropolitan Area, one of the major European metropolitan areas with more than 10 million habitants. It is one of the oldest cities in Germany, having been founded by the Romans in the year 30 BC.
Cologne lies on the Rhine. The city's world famous Cologne Cathedral (Kölne
r Dom) is the seat of the Roman Catholic Archbishopric of Cologne. The University of Cologne (Universität zu Köln) is one of Europe's oldest universities and internationally renowned for its economics department.

The party...At the end it was the party where my princess Joana was waiting for me at the in Cologne... we started enjoy this fabulous city with some of the advices given by Simone. We were focused mainly in the shopping area and near the Rhine river. It is a beautiful city with an intense movement of people not only in the shopping area, but also in the restaurants and bars area. We attend, almost every day, to a Cuban bar where we drank exotic drinks as capiroska, mojito and others!

My sensation is that I’ll return to Germany to take the other CBIP specializations very soon... I hope this post was helpful to you.


Related Posts Plugin for WordPress, Blogger...