Monday, September 7, 2015

Consume the wsdl with SOAPUI request using an active login

The purpose of the functional requirement is to specify a login name to identify which integration is used in order to create the Service Request (within Siebel).

WSDL permit Service Request creation if an Administration name/password is specified. Anyway, consume the wsdl with SOAPUI request using whichever login of interest is available.

So, change the web service url in the SOAPUI request (username/password of the interested login in the url), for instance, using USERA the url request is such as:

http://localhost/eai_esn/start.swe?SWEExtSource=WebService&SWEExtCmd=Execute&Username=USERA&Password=USERA

Thursday, August 21, 2014

Optimizing the Value of Information Technology Investments

Recently, a client ask me if I consider using Open Source software for support “Business Intelligence” needs, which question I answer: it’s possible, but the Open Source system provides less functionalities to specific problems. 

As it’s well known, OBIEE is, for me, the Flagship of Flagships that continues its strong growth year over year. So, thanks to acquisition of Siebel, Oracle provides a friendly and high quality application that stay on top of “Business Intelligence” technologies.
 

Anyway, needless to say that the licensing is an intangible cost involved in commercial products. In this way, I focus on reaching ways of cutting costs, ensuring that information system is efficient according business requirements.
 

The usage of Open Source software as alternative for commercial products may cause nightmare, not only because of support that you can expect after buying a license, but also because of software requirements of businesses.
 

Notice that a solution could be combining  commercial  software with open-source applications. So, “Pentaho Report Design” (OpenSource) allows create custom reports using Oracle Database (commercial product).

In this way, within “Pentaho Report Design” include the SELECT statement, such as in the screenshot below:



Once is included and customized, click on “Print” > “PDF” and you could save the Report as PDF, just as in the screenshot below.


Best wishes.
Joan Martí Peraire.

Saturday, September 21, 2013

Stop and think

My bro releases another work: "Equilibrios", and once again he give us an essential key of life. In this case: Is whatever you have whatever you want?

So once again complex situations become simple or understandable, I always focus on whatever I wish, whatever I need or which one is my priority. Anyway just now I realize that these concepts are secundary, and it's crucial that whatever you have is really whatever you want.

When I listen that release I was under impression that "Equilibrios" is not just a new song in general, it can also refer a specific style of life: stop and think, so then go on.

Below is available the link to related song:

Equilibrios - Artur Martí.

Best wishes,
Joan Martí.

Friday, August 23, 2013

1993 - Not so small revolution


In 1993 Thomas Siebel and Patricia House founded Siebel Systems, Inc.

Forward 20 years and here we are:

-       Siebel CRM:

o    Oracle's roadmap for Siebel CRM is already announced.

o    More than 3.000 organizations use Siebel CRM.

-       Siebel Analytics (now known as OBIEE) is considered a reference within Business Intelligence products, as Oracle's standard Business Intelligence product.

Within IT industry, that means for me: not so small revolution.

In 2004 began my particular Siebel journey thanks to Deloitte and until now I have worked closely with Siebel products. Currently I still struggle to get the concepts that are incorporated into each Siebel releases (in other words: within Siebel, new technologies are being continuously improved). 

So what makes Siebel CRM or Siebel Analytics so successful should be considered exhaustive, anyway let me explain the conceptual overview of what really fascinated me.

1.     Business logic layer

Siebel CRM is a consistent way to record and Siebel Analytics is a consistent way to provide information, both products include predefined modules such as Energy, Public Sector, Loyalty, Order Management and so on. Both products separate each layer:

-       Physical layer: Contain the definition of the relational database.

-       Business logic layer: Contain the abstraction layer of the business.

-       Presentation layer: Contain the end user interface.

I was so impressed when I find out the abstraction of the Business logic layer. To be concrete, Business entities are customized within Business logic layer. In this way, Siebel provides several resources (such as the usage of user-properties based on classes or the incorporation of additional code into Business Component events) to enable particular customer requirements that predefined entities doesn’t include. 
 

2.     Operational vs Analytical:

At high level, in this point there are two main concepts involved: Operational environment and Analytical environment.

In this scenario, the analytical environment builds consolidated information from more than one source.

On that basis, I was really fascinated as soon as I realized that depending on physical layer configuration, Siebel analytics (OBIEE) is able to provide not only Analytical dashboards (operate in data collected over time, insights into historical data), but also Operational dashboards (operate in real-time, insights into current performance).

To sum up: It’s an asset that the Analytical environment contains Analytical and Operational dashboards, depend on the purpose of the dashboard. In order to be efficient, effective and also identify issues before they become problems.  

Finally, let me say that I really think that a way to evolves is incorporate into Siebel Analytics (OBIEE) statistical modules, conceptual functionalities that nowadays provide software such as SPSS, for me currently OBIEE and IBM SPSS are complementary (have an eye to: Can't see forest for the trees ).


Best wishes.

Joan Martí Peraire.
(Industrial Engineer)

Wednesday, August 14, 2013

Adapt to survive


Little by little things evolves and evolution means change over time. These changes should be always focused on improvement and only adaptive mechanisms are the key to get better.
There’s no sense bet on something that over time is useless.
Finally, I’ve installed the latest version of Oracle BI (11G), and this release includes the latest application server Weblogic.
Once works, I noticed that Oracle BI 11g provides a new robust architecture within Business Intelligence applications. After a bit of research, now it’s time to share my findings (thoughts that are still on my mind).
First of all, as you can see in the below screenshot, let me represent the main part (from my point of view): How are involved Oracle Instance within Oracle BI 11g application.
 
Focus on Oracle Instances, use the following command line to start (Oracle Process Manager and Notification Server) OPMN services:
Command: opmnctl.bat startall
Path: C:\OracleBI11g \instances\instance1\bin
e.g.: C:\OracleBI11g\instances\instance1\bin>opmnctl.bat startall
Anyway, in order to start the process separately, below are listed each service:
opmnctl startproc ias-component=coreapplication_obiccs1                         (Cluster Service)
opmnctl startproc ias-component=coreapplication_obis1                            (BI Service)               
opmnctl startproc ias-component=coreapplication_obijh1                           (Javahost)
opmnctl startproc ias-component=coreapplication_obips1                          (Presentation Service)
opmnctl startproc ias-component=coreapplication_obisch1                        (Scheduler Service)
Finally, in order to stop Oracle Process Manager and Notification Server (OPMN) services, we use the following command line:
Command: opmnctl stopall
Path: C:\OracleBI11g \instances\instance1\bin
C:\OracleBI11g\instances\instance1\bin>opmnctl stopall


Such as start OPMN services, each process can be stopped separately, below are the command lines:
opmnctl stopproc ias-component=coreapplication_obisch1          (Scheduler Service)
opmnctl stopproc ias-component=coreapplication_obips1           (Presentation Service)
opmnctl stopproc ias-component=coreapplication_obijh1            (Javahost)
opmnctl stopproc ias-component=coreapplication_obis1              (BI Service)
opmnctl stopproc ias-component=coreapplication_obiccs1           (Cluster Service)



Hope it helps.
Fins aviat,
Joan Martí.

Saturday, June 29, 2013

Go ahead



First of all let me say so sorry for not having written for so long, maybe because I needed to work so hard or maybe just finished a complicated life stage that once is over it’s better to forget. Anyway life is life and now it's time to look forward and be enthusiastic about it.


Recently, I devote so time to propose an innovation initiative to be efficient, the main idea is the usage of water according the quality you need. For instance, not only it’s not required, but also it’s not efficient use water with the same quality for all tasks.


So, my initiative is based on collect rainwater and includes an auxiliary mechanism to provide our system with water that comes from a wastewater treatment plant.


 According to the rules established by regional law, physic-chemical properties of water collected should be measured.


In this case, Oracle BI helps us to monitor the physical and chemical properties of water, within a Dashboard, such as I represent below:




If you have an eye on that again, you’ll notice that I design the Dashboard using some of my theories:

  •  A Dashboard must focus on information, instead of art. 
  •  Dashboard should include concrete alerts, such as remark unexpected values. 
  •  A Dashboard should present the process evolution, in order to compare results.

Finally, below is detailed my water-efficient model proposed:




Best wishes,

Joan Martí Peraire.



Tuesday, December 25, 2012

Christmas, time for reflection


After almost 3 years, it has become (on Christmas seasson) a tradition here at the Siebel Resources blog to take time to share my thoughts.

Recently, I was getting answers to focus on the question: Profession is just a job or lifestyle? And here are my lucubrations on this...

On our journey through life, I think that our roadmap should be based on a consistent education. More and more, the rise of creativity and developing innovation relies on our education and professional background. And that means that a profession is closer to lifestyle than simply a job, because of the constant individual involvement level.

Anyway I think that's so complex, I wonder if professional structures in a regional labour market influences the choice of education and profession. And I think obviously so, we are conditioning on the labour market. In addition, I notice that the essence of each region is nowadays missing, that means talk about new concepts such as job mobility, globalization and so on.

There is an expression found in the letters of Isaac Newton: "If I have seen further it is by standing on the shoulders of giants."

As a conclusion, I believe that each region can be identified by activities which are the lifeblood of each specific region. In another words, obviously there are innumerable disciplines, but each region is a source of focused expertise (such as Centers of Excellence), so I think that's no sense lose the product of generations of efforts  because of economy, in particular capitalism. Within a concret context, What i would mean by it, is that I come from a region where the textil industry was the root, and nothing make me saddier than realize that my region is unable to offer competitive “just in time” products.

In general, low quality imports are cheaper to produce, and it works in the era of Consummation within short term use. Anyway, not only destroy local competitors’ product, but also destroy regional production system and acumulative knowledge.

If you ask me we should not waste our ancestors' efforts, don’t let the giant die, standing on the shoulder of consummerism.

Bon Nadal i bona entrada al 2013.
Joan Martí Peraire.