Move Oracle Linux VM to New Machine – Static IP

AshokTechnical TipsLeave a Comment

I just copied an Oracle Enterprise Linux VM from one Windows machine to another and the IP address for the guest Linux machine changed. I had a feeling that this might happen, but wasn’t quite sure why it did nor how to get it back to the old IP address. As we all know, an IP address changing in an Oracle environment is best avoided.

Salesforce.com Integration – Oracle Fusion Middleware SOA and BPEL

AshokCase Studies, Industry Trends, News and Updates, Technical Tips14 Comments

Oracle Corporation has recently published a white paper written by M&S Consulting, where we take the opportunity to outline an integration approach to Salesforce.com using Oracle BPEL.

A Technical Case Study – Creating an Oracle BPEL adapter to integrate with Salesforce.com – Feb 2009

Below is the introduction to the article, which goes on to detail (with step-by-step screenshots) how to achieve integration with Salesforce.com…

BPA 10.1.3.4 Windows Install with XE

kevin.landonTechnical TipsLeave a Comment

I have just had a heck of a time with installing BPA (Architect) Evaluation on a Windows Server 2003 machine. There were no inherent issues with the product itself, but some gotchas that I thought I might point out. For the following, I assumed you are installing on a single machine for testing/evaluation purposes like I was.

For one, if you were familiar with BPA 10.1.3.3, there is no longer an auto-installable olite database option. You must use Oracle XE Universal (or better) and you should have it installed locally prior to installing BPA. Note: You should use XE Universal specifically so you get the AL32UTF8 character set that is expected by the BPA install.

After I got the character set squared away, I continued to receive a database connection error

Oracle Database vs Sun MySQL

AshokIndustry Trends, Technical TipsLeave a Comment

Well, this is a topic we have reviewed numerous times over the years for projects and customers. The fact is, like most important decisions, picking a winner is based mostly on your specific needs. Of the many aspects we review, we will discuss one line of thought in this article.

If there is in-house expertise in Oracle, and management is happy with the skills, productivity of existing staff, and license fees, stick with it. I don’t know many — actually, I don’t know any — CIOs or Directors in IT Management that have been berated for choosing Oracle as an enterprise-wide database platform.

That said, if the strategic decision to use Oracle database for all purposes hasn’t been made, MySQL is worth a very serious look, especially for …

Supplier Portal – Oracle EBS and Middleware

AshokCase StudiesLeave a Comment

The Challenge

ABC, a publicly traded services and manufacturing organization, has leveraged Oracle E-Business Suite (EBS) to manage a variety of back-office functions, including their suppliers. Suppliers have been provided data from EBS manually by internal teams — the data sent has varied in both content and as well as format.

Internal teams spend valuable time generating reports manually for external supplier organizations and suppliers are left with the tedious process of generating their own reports. All the while, both groups may be relying on measures out of line with ABC’s priorities.

The Solution

We took a systematic approach to the issue, addressing:

  1. EBS/Data
  2. Discoverer/Reporting Logic
  3. Portal/UI

The Results

Finally, by setting up proper SSO and hooks from Portal to Discoverer and integrating end-to-end all the way down into the database, users in Portal (regardless of whether they are internal or external users) see only what their user account can see. Additionally, by leveraging the latest Portal 10.1.4 features, we were able to provide ABC with a portal that had a completely customized look-and-feel matching their external website exactly.

Within days, the entire solution was architected, designed, and developed. We were all excited about the quick progress and all of ABC’s expectations were exceeded.