Why’ Reporting Alone Isn’t a Strong Enough Business Intelligence Strategy

Not having a single version of the truth for business intelligence data used for reporting—such as data about customers, products, channel partners, suppliers, and employees—slows analysis, delays action, and impedes your ability to improve business performance. Continue reading “Why’ Reporting Alone Isn’t a Strong Enough Business Intelligence Strategy” »

Share Button

Read More

Do organizations need to adapt to latest technology trends in the data storage area?

The explosion of data, its criticality, and the increasing dependency of businesses on digital information is leading to larger and more complex information storage environments that are challenging to manage.

Organizations evolve over a period of time by creating value, and to create value quickly and cost-effectively they select technologies that can facilitate that growth.

That being said, let us look at the key challenges for data storage and how new trends can potentially impact a much larger market with the value proposition they are bringing in.

Key Challenges

IT/storage managers and storage professionals across companies of all sizes face the following mission-critical challenges:

• Managing storage growth

• Designing, deploying and managing backup, recovery, and archive solutions

• Making informed strategic/big-picture decisions

• Designing, deploying, and managing disaster recovery solutions

• Designing, deploying, and managing storage in a virtualized server environment

• Addressing the lack of skilled storage professionals

• Designing, deploying, and managing storage in cloud computing environments

• Addressing the lack of skilled cloud technology professionals

• Convincing higher management to adopt cloud

• Providing infrastructure for Big Data analytics

• Managing external cloud service providers

Trends in Data Storage

  • Cloud: Amazon EC2, Redshift, etc. Value: subscription based and on demand elasticity
  • Open source: HDFS, HIVE, Cassandra, MongoDB, Rocks DB, etc. Value: performance & relative cost

In memory: HANA, etc. Value: Performance

Now organizations need to decide if they are satisfied with the current storage mechanisms or they need to upgrade their data storage architecture with the one or combination of the latest technologies to get optimal benefit.

As depicted in the picture above data storage market is at the conjunction point of maturity and latest innovations in the same area. Organizations need to realize that it would be beneficial for them to increase the pace of growth with the adoption of latest technologies in the data storage area.

And the best way to do this would be to identify the use cases, which would bring in value to justify their investment in new technologies and then begin to evolve further.

Share Button

Read More

Enabling SOA Integration with ISG

Oracle E-Business Suite Integrated SOA Gateway (ISG) provides a customer-focused robust communication and integration infrastructure between an external system and ISG for inbound and outbound communication that does not require a special class of middleware software.  This will not only save license costs but also reduce maintenance costs as the existing EBS system support team can maintain the infrastructure easily. This infrastructure not only enables greater and effective business integration with standard SOA concept between heterogeneous applications, but also facilitates the development and execution of complex business processes into highly flexible and reusable Web services. With this standardized and interoperable Web service platform, ISG provides a powerful framework that accelerates publishing of custom PL/SQL procedures as web services over the Web.

Integration Architecture

ISG Integrations require some configurations and customizations to enable the functionality in the ISG module.  The functionality would be written in PL/SQL procedures and then enabled as a web service.  The Outbound calls are made using the Service Invocation Framework (SIF) of EBS, which internally uses built-in Business Events for initiating the transaction or web service call.  Organizations would not need to hire new resources to develop this functionality as Apps technical resources possessing PL/SQL skills can easily deploy this functionality. This helps the firm in saving recruitment and resource management costs.  This cross-industry integration can be performed on EBS versions R12.1 and above.

Implementation Steps

Here is a detailed illustration of web services implementation and calling web services from EBS.  Oracle E-Business Suite (R12.1.3) must be installed and ready to use for Integrated SOA Gateway (ISG) setup and implementation.  This implementation requires some setup configuration and development of several components for Inbound and Outbound as given below:


1.  ISG Setup
a. Enable ASADMIN user
b. Create ISGUSER
2. Write a Custom PL/SQL procedure
3. Write the annotation into Procedure
4. Generate and Upload the ILDT file
5. View the Published Custom Web Service developed
6. Monitoring SOA Requests


1. Run SQL script for Security Parameters to Support UsernameToken based WS-Security WSSE password   (If the external services are WSSE enabled only)
2. Creating Business Events
3. Creating Invoke Web Service Subscriptions
4. Creating Error Notification Subscriptions
5. Creating Call back event Subscriptions in PL/SQL
6. Testing the Setup (Don’t DO in the production environments)
7. Resubmitting Failed Business Events

For further details on implementation steps e-mail to Khaleel shaik our Java Practice lead at kshaik@bodhtree.com

Share Button

Read More

Navigated through the ‘Cloud’ to Singapore

Having built a strong customer base in India, North America and MENA regions we decided to expand our presence in Singapore and selected the Education industry to test the waters. We are proud to state that we now on-boarded one of Singapore’s largest and most renowned Universities as our customer.

Given our limited exposure and relatively lower visibility, it was a challenge to break in to the account. Competition from local players was fierce and Singapore was a relatively newer market for us. However, our strong experience in Salesforce coupled with extensive domain expertise in the Education vertical were critical success factors that contributed towards this win.

Though the University’s Business unit had already implemented Salesforce.com CRM, they were unable to yield required results due to limited adoption and partial knowledge on implementation best practices.

Bodhtree initiated a consulting workshop, analyzed the existing anomalies in the ‘As is’ process and recommended a ‘To be’ process that would enable them to yield favorable results.

Our workshop was well attended by IT and business users and had helped the University in visualizing the value that they can derive from Salesforce. Needless to say, it helped us gain their confidence and win the re-engineering services project.

Team Bodhtree did a fantastic job on this implementation and delivered Phase I to the University leadership team. They were thoroughly impressed with Bodhtree’s competitive edge and awarded us a larger project.

Looking at ROI from Salesforce, the university has plans to automate all their business processes in next 1-2 yrs.

This is an important achievement and milestone for us in Singapore as they are considering Bodhtree as a single vendor for all their IT needs.

Several business schools operate under this University’s umbrella and are ready to invest in Salesforce.com CRM.

With this success we will soon be expanding into other Eastern regions such as Malaysia, Australia, etc.

Share Button

Read More