The Challenge

M&S was engaged by ABC, a publically traded company, for a multi-national Oracle initiative. Upon joining, M&S recognized the need to easily share, collaborate, and centrally publish information.

The Solution

The value of Web/Enterprise 2.0 social software was no longer a secret reserved only for the most cutting-edge — or as some might have labeled them, “bleeding-edge” — organizations.

The Results

Within two weeks of deciding to implement the M&S solution, the application was available to the customer, hosted by M&S Consulting.

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…

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.

The Challenge

ABC, a facilities services company, has employed over 16,000 people in fiscal year 2008. At year end, ABC’s payroll vendor generated an enormous number of W2 documents for distribution to each employee. In addition to physically mailing the individual W2 documents, ABC desired this information be delivered through their employee Portal so the information could be

1. quickly accessed,
2. accessible 24×7 now and into the future, and
3. available in an electronic format.

The Solution

M&S devised a mechanism to generate a single file per employee based on a unique Social Security Number. Once the files were generated, they were loaded into a database inside the customer’s LAN. A web application was built to identify the user logged into the Extranet Portal, request the appropriate W2, and display it to the user securely over SSL.

The Results

Within weeks, the entire solution was designed, developed, and deployed into production, available to over 16,000 employees. Once deployed, employees immediately began logging into the Extranet Portal from around the US to access their electronic W2s quickly and securely.

You lie in wait, looking for your prey, it approaches, and looks around. You spring the trap and
find the spoils of war…the dreaded %20

Ok, maybe not all that exciting, but it brings up an important problem in data conversion and in
application development projects. Namely the importance of input data trapping and input
validation.

The Challenge

• Senior Management at a silicon wafer manufacturing facility were making decision based on incomplete or inaccurate operational data
• Management needed data issues resolved to improve plant profitability and drive strategic decisions
• Technology group was working with a system built before their time – i.e. didn’t fully understand the BI system from source to reporting

**This is an excerpt. Click to read BI, Datawarehousing, and ETL...

The Challenge

Affle, a mobile media innovator based in Singapore has been working in stealth, start-up mode for a number of months and is ready to begin outreach to customers and partners as well as others following the fast-growing mobile media industry. Affle required the ability to manage content quickly and easily while presenting a unique site that was friendly to mobile handset users as well as large mobile operators that they partner with.