Knowledge Management Issues


Knowledge Management IssuesI take this blog entry to retrieve the answers to three questions I posed Edgar Cateriano to participate as an expert in one article on Knowledge Management in the journal that published CLADEA . The participation was very low end, and I think are worth sharing the thoughts that arose from these questions...

Spanish Business Intelligence


There are three Spanish suppliers of business intelligence software. I am referring to Apesoft, Litebi And Bingo Intelligence.
Interestingly, the products of these three BI vendors are very different. Apesoft software is essentially a report generator in Excel, with some additional features that facilitate the automation and distribution of these reports. Litebi solution provides software as a service, ie, data and applications are on their servers, and clients access via a simple yet powerful web interface. And finally, Bingo Intelligence platform that offers a smart client to access corporate information in a very visual ...


Remote access with Oracle dblink global_names or without


"Without knowing how easy the item may seem difficult"

Creating a database link to point to an oracle database to another in principle is easier, if you read the post dataprix Remote access through Oracle dblink . The pity is that in this post do not say anything about the global_names of each database and rename the dblink as if global_names are active.


  1. We created the dblink to a dummy database hr (after having configured tnsnames ...):
    create database link connect to rrhh dblinkrrhh recursoshumanos IDENTIFIED BY USING 'HR';
  2. Consult your name and surprise is not called if DBLINKRRHH.REGRESS.RDBMS.DEV.US.ORACLE.COM dblinkrrhh. We can see with the following query:
    select * from dba_db_links;

    Now what?

Which brings Oracle Business Intelligence 11g


Last week I attended a Web Seminar Oracle that presented the new features of Oracle Business Intelligence 11g.

The truth is that I was pleasantly surprised, because these improvements solved what I considered so far the main weaknesses of the Oracle BI Suites .

Most significant to me is the integration efforts made in the portal since it can use most of the tools of the suite, and thus reduce the feeling of working with different products. For instance, you can create operational BI Publisher reports from the same portal, and has created an integrated scorecarding tool that allows you to define KPI's, and 'react' with Agents and Actions, another pending issue of the suite. The part of administración system has also been integrated into Enterprise Manager.

Other improvements are those which have been introduced in the creation and display Dashboard, the possibility of using interactive maps, and above all the possibility of using also Answers MOLAP data sources such as Essbase cubes, which enables integration Hyperion, greatly improves the analytic reporting and enables dynamic navigation for multi-dimensional hierarchies, and other features in the reports.

CRM solutions for SMEs


The customer

I've found an interesting Discussion on CRM Experts Linkedin Group baout the search of CRM solutions for small businesses.

The debate has many responses and, apart from good advices, have come many proposals for CRM applications aimed at SMEs, so I've decided to create a list, that I hope to be useful..

Democratization of Business Intelligence



Some information systems have exceeded the boundaries of the department and his knowledge has spread to all areas of the company. As the technologies are becoming easier to use and accessible for all business casuistry, his knowledge extends and extends beyond the field of "understood" by the experts, to be known by every company profiles. Concepts such as CRM, ERP, etc., Not long ago in companies known only to the department and the department involved (Marketing and Sales for CRM, ERP Operations, Human Resources for the intranet, etc.).. Concepts today are managed and understood by anyone in the business world.

As for Business Intelligence, I believe that unfortunately is still preserve of experts and technologists. Today it is very common to find a business decision makers are unclear about the functions, spheres of influence, potential and business benefits of a Business Intelligence system. The BI is still known by a few, there has been democratized, it has jumped the hurdles of technology to be part of each and every one of the departments of companies. In my opinion there are several reasons for this.

LifeDashBoard 4 Team Prelytis SaaS solution, you can use without paying for their use.


Prelytis, the company recently surprised us by being the frist to adapt its Business Intelligence solution (or Dashboarding, more specifically) to Apple's iPad, also excels in the world of SaaS solutions with its proposal LifeDashBoard 4 Team, which is not is nothing but the cloud version of its software LifeDashBoard Dashboards.

It has the usual characteristics of SaaS software, and soon afte a user register and upload data from an Excel spreadsheet, for example, may have created an attractive dashboard. Collaborative options available, and also takes advantage of the features of mobile devices like the iPhone or IPAD.

But what makes this more special is that it's SaaS solution, but can be used without paying for its use, and without limitation in the number of users. A strong commitment by Prelytis, which seems to be really willing to put a dent in the world based BI innovative proposals.



Pentaho Solutions: Reviews



I finally finished reading the book Pentaho Solutions, who kindly have sent me Roland Bouman (co-author of the book) and Wiley.

On that occasion will realize different reviews from different points of view, as I did with Pentaho Reporting. Here are the reviews:


1) Overview :  It is a very easy book to read and handled very well the theoretical and practical.

As the concepts are giving more complex and heavy, is always accompanied with an example, graphic or exercise.

This book is really very useful and indispensable reading both for those who are just beginning to work with Pentaho, and for that we have some time.



Information is the power, Business Intelligence on Corporate Governance



"The goal of Business Intelligence is to provide the information they need, when you need it and in a form appropriate to people who have to make decisions."

The aim of this paper is to support the Business Intelligence or BI should be, of all business software tools (including CRM, ERP, or BI himself), that is closest to the role of management, specifically the Executive Officer.

Since the computer revolution and the explosion of Internet, information is becoming more and more importance. Everything is or will soon be digitized, the amount of information available each year is multiplied and the activity of our business is computerized in most respects.

Studies tell us that the information maintained by companies is doubling every two years and that 80% of decisions are made with only 10% of the available information.

And all of this information is power! Is necessary, vital, to compete. 

How to disable autocommit option in SQL Server Management Studio


Have you ever wondered how to disable the autocommit option in Sql Server Management Studio?

The answer is quick. Simply uncheck the option SET IMPLICIT_TRASLATIONS. To do it follow next path from the menu:

Tools> Options> Execution of the query> SQL Server> ANSI, then Uncheck Option SET IMPLICIT_TRANSACTIONS.



It seems rather simple but is a common doubt when you start using SQL Server Management Studio. By sharing this tip I hope to save time to someone that wants to disable the autocommit option in SQL Management Studio.

Syndicate content