The Oracle Australia and New Zealand Middleware and Technology Blog.

Wednesday, November 26, 2008

The Perfect ECM Architecture - Part 2

Hopefully you enjoyed Part 1 of this article and had a giggle at the analogy!

How should an organisation execute on their ECM requirements - well, to draw upon a similar analogy you need a vehicle and visit your local showroom. You are shown a real-vehicle, go for a test-drive, negotiate the price and when you get to the delivery day - the vehicle you selected is waiting for you with a full-tank of petrol ready to drive away. All you have to do is tune in your favourite radio stations, put the drivers-seat in the right position and set the mirrors correctly. Buying an ECM solution should be as straight-forward - the solution architecture you get should be like the car you buy from a dealer - the parts come from one manufacturer, have been designed to work together seamlessly from day-1 and all you need to do is configure it to your requirements. There should be no need to bolt the solution together and hope it all works, you shouldn't need to spend time and money with 3rd party suppliers to help you get it running!

We believe that the perfect ECM architecture should look something like this....


So, how should this all work???

The ECM solution should provide the ability to manage ALL of your unstructured information as easily as you manage your structured information. Managing unstructured data across a relational database AND a file-store(s) AND an index is painful, time-consuming and costly. Managing unstructured data WITHIN a relational database is easy, cheap and occurs using the common database management tools and processes you have already developed and deployed for managing structured data. Unstructured data should be stored, managed and protected within the repository and able to be leveraged by other systems including enterprise search using a common set of open-standards tools and APIs.

The ECM platform should be singular in its architecture and approach. You should not have to use different tools and interfaces for managing different types of unstructured data. It should be easy and seamless to create a new HR policy, for example, through MS-WORD (and SharePoint?) review and approve the policy using a template-driven workflow, convert to PDF (or HTML), publish to your portal, intranet or extranet, apply a retention policy appropriate to the document-type and its context and apply digital-rights all through a single solution.

The ability to archive any information from any system should be a component of the ECM solution. A lot of data exists in file and email systems for example. The ability to ingest this data, leaving a 'stub' of metadata is a deliverable that most IT managers will be interested in as it provides back-end benefits. Integrations with ERP and CRM systems to archive data and deliver data is crucial in the improvement of business processes - an example of this is Accounts Payable/Receivable where delivering a digitised image of an invoice, for example, reduces organisational risk and speeds up the payment process. This is driven by image capture, which is ideally also provided as a part of the ECM solution and delivers the ability to acquire (the process that occurs immediately after capture/scanning/eFax-delivery) physical information, tag/categorise/classify, and ingest into the repository.

Underpinning a deployment of Microsoft SharePoint is another area where a complete ECM solution will provide real benefits to an organisation. We all know what SharePoint is good at and most organisations are rapidly becoming aware of its limitations. As a user-interface supporting office-level collaboration SharePoint is great. However, for a larger organisation - its deployability presents some concerns, typically around the number of repositories it can create to support scalability. Providing a true-enterprise repository to support these multiple silos of unstructured data means that common and consistent records and storage policies can be applied and that data can be shared and leveraged by the organisation as a whole.

An organisation may already have tier-2 or tier-3 solutions in place to manage components of ECM such as records or web-content. A complete ECM solution will provide the capability to integrate with these environment to perform one or more of the following functions. Migration, easily support the rapid migration of unstructured information into the enterprise repository enabling the legacy solution to be decommissioned. Federating ECM functionality, such as unified records management, into the legacy repository enabling the application of common and consistent records policies to be applied to unstructured data without the need to migrate information. Leveraging the legacy solution through enterprise search enabling the organisation to find unstructured and structured data through a single search regardless of the repository where data is stored.

Finally, end-user content consumption and interaction through the organisational web-presence environments is becoming a key-focus for businesses around the world. Recent reports have highlighted that in order for a organisation to be successful in the current and projected economic climate, a closer relationship with its customers and partners needs to be established. This occurs in two key ways - publish and interaction.

The first of these, Publish, predominately supports the Internet or any other web-presence where content-consumption is the lead requirement. Content is created and managed within the ECM solution and then, as a part of its lifecycle, published to a website. End-users access the site and either navigate or search for information and land at the published content. In order for this to be successful and for the organisation NOT to end up with a management overhead because they selected a separate app-server/portal-server and ECM solution from different vendors - the ideal solution is to have a single solution in place. This enables the website and the ECM solution to be integrated in such a way that management and administation occurs once. New content, with potentially new categorisation resulting in a change to naviagation, is created, managed and published and ALL changes required around the content occur naturally and automatically. New classification results in the navigation hierarchy being modified - the user, or administrator, does NOT need to create a new 'node' on the menu manually.

The second, interaction, enables multi-directional web-based communication between an organisation and its customers and partners. Recent developments in web-technologies resulting in the adoption of Web2.0 and the popularity of social-networking sites such as FaceBook and mySpace have raised questions with organisations around how this can be of real-benefit to the business. Qualification has taken place around the investments required to return value to the business and organisation like Oracle have invested in initiatives like SocialCRM and its Enterprise 2.0 offerings. The interactive environment will allow employees, customers and partners to consume and contribute information within an easy-to-use (i.e. minimal training required) environment and is totally integrated with the ECM solution. Information from varying systems should be accessible through this single environment - allowing the mashing together of data, e.g. from the ERP, CRM and ECM environment to provide better context around information and participation within the creation and review process.

All of this functionality and capability is available from a handful of tier-1 ECM vendors including Oracle. Tier-2 and tier-3 ECM vendors can offer part of the overall ECM requirement but do so through an imperfect architecture - often requiring multiple UI's or repositories to be deployed or compromising on functionality or capability in some way.

I look forward to reading your questions and comments about this article - I'm sure it will raise many amongst our readership.

Paul

Greening the Data-Centre - the ECM Way

Greening the data-centre is an initiative that any responsible environmentally-aware organisation should be undertaking.

Simply virtualisation at the server-level goes along way to achieving your goals - but so does switching off monitors, ceiling-lights and other items of electrical equipment that are on your desks right now!

One of the major challenges that is faced by an organisation is actually around the amount of information spread across multiple systems and held in numerous versions or simple duplication of data. Within an organisation, 85% of information is comprised of unstructured data and of this - a high percentage (30-40% in some cases) is duplicated. Implementing an ECM solution properly, that promotes single-point-storage for unstructured data is a key deliverable in greening the data-centre. Managing a smaller data footprint on fewer servers delivers environmental benefits as well as reducing overall costs in real-dollar terms.

Paul

Friday, November 21, 2008

ECM - 'One' Repository or 'Three'?

Quick question, which looks simpler to you in the following diagram....?
If you answered A then you are probably from another ECM vendor organisation claiming efficiency, scalability and all the usual reasons quoted to your customers. Whilst it is true that during the 1980's and 1990's this was the ONLY architecture available that would work for an enterprise organisation - things have moved-on in the world!

Oracle's 11g technology allows any information to be managed in a single database architecture. You really, and truly don't have to deploy and manage a separate filestore and index in order to manage your unstructured information separately from your structured data and to the IT department - you can use the same management tools and methodologies you love to look after the 85% of information your organisation generates outside of the database. Think about a world where you don't have to worry about persistence of backups in order to prevent data-loss when recovering a system.

Doesn't the diagram to the right look simpler? We'll be covering more around the 11g architecture and time progresses but for now - consider simplifying your lives and providing richer functionality to your users through a single ECM solution.

Paul

[Addendum]
Information Security

Oracle has a great capability in this area using 11G to store all three of the core data sets inside one instance ( Text, metadata and objects) this makes tracing illegal access both viable and practical which to us is the key to good security policy. The single-repository approach promotes this and provides some obvious benefits.

Patching with Confidence!

I was reading this recent article regarding the latest security patches released by Oracle, and it had me thinking about how to best manage patching cycle.

At the outset it addresses a frightening reality:
“In many cases, companies, especially large ones with many databases, are reluctant to bring down production databases to implement new patches. Many are also wary about deploying untested patches in live environments or need to wait for their packaged application vendors to test and certify the patches before they can be deployed"

“As a result, there usually is a considerable lag time between when a patch becomes available from Oracle and when it gets deployed. In some cases, the lag can be months. Other users simply skip entire patch cycles and choose to deploy the patches on a yearly or twice-yearly basis.”

Furthermore, the article said: “…of 305 Oracle database administrators from 14 Oracle user groups between August 2007 and January 2008 and found that two-thirds of Oracle DBAs apparently are not installing Oracle's security patches at all, no matter how critical the vulnerabilities are.”


This drew the author to the make the following stark but obvious conclusion: “…such practices can leave companies dangerously exposed to attacks directed against database vulnerabilities.”

Patch Management is no that difficult. So why are organisations still struggling? Many DBA’s and Operations Managers I’ve spoke to mention three recurring themes.
  1. Application Regression Testing- often, because of 3rd party application certification dependencies, there is a requirement to wait for the next application refresh cycle so that appropriate regression testing can be completed prior to upgrading.
  2. Confidence is often low because - regardless of the fact that an update has gone through certification - many DBA's have a story to tell about when a tested patch in dev worked differently in production as a result of environmental differences.
  3. The timing and time required to apply an update. DBA's need to allocate time to apply and test the update in a test environment, then they need to find a slot in the upgrade schedule to apply it in production. All of this needs to multiplied by the number of environments that need updating and the number of updates to be applied. Clearly, mechanisms are required to cut down cycle times and automate recurring tasks.
Patch Management requires planning and change management to ensure that each updateis priorotised and scheduled accordingly. The DBA should review each vulnerability patch and make a determination on the criticality and impact on their specific environment. Often not all patches need to be applied based on the broader security setup and criticality of the system.

As it stands today, Oracle provides a robust set of tools under our System and Application Management (SAM) portfolio.Real Application Testing, an innovation in Oracle Database 11g, allows database workloads to be efficiently captured in production and replayed for testing purposes. The facility faithfully replays transactions with order and timing preserved. It then reports on the performance of the test and highlights areas of change. Using Oracle Testing capabilities, confidence is increased are tests are based on real production workloads rather than synthetic test scenarios. Testing cycles are therefore shortened, not only because the test is largely automated, but also because the increased confidence associated with using real production workloads.


Furthermore, Oracle Enterprise Manager Provisioning Pack provides automated provisioning and patching facilities that make it easier to locate and apply patches. It also drastically reduces the effort required to patch multiple systems, which is great news if you’ve got scores of databases to manage.

Finally, when it comes to applying updates to production environments, 11g “Hot patching” means that it will be possible to apply an update to the Oracle binary while the database continues to run avoiding small downtime windows.

The article goes on to say that of DBAs and IT Managers at 300 organisations surveyed by the Independent Oracle Users Group, “…20 percent said they expected their databases to be breached in the coming year”.


Fortunately, these and other innovations in 11g, if utilised will take the pain out for DBA's, Application and System administrators which in turn will make their life easier.

Marc Caltabiano
Director, Enterprise Architecture

The Perfect ECM Architecture - Part 1

It's funny trying to explain the perfect ECM architecture to people representing a business-unit or even to IT on occasions. I often get asked 'What is the perfect ECM architecture' and of course, the answer is normally based upon the perceived requirements. So, to make things easy to understand, I'm writing this blog in 2 parts. The first part, that you are reading now, will focus on the imperfect architecture - really to explain what you should be avoiding and the second part will talk about the architecture that you should look to deploy.

I'm going to start with an analogy. You walk into a car dealership and talk to the sales person about your requirements for transport. You talk about the need to carry 4 people, in-car entertainment, performance and economy etc. etc. etc. The salesperson shows you a picture of a brand-spanking new vehicle that looks absolutely perfect for your requirements - it is the right colour, has 4-wheels, seats and a radio and the specifications for the vehicle show the right levels of performance and economy. You negotiate on price and come to an agreement, shake hands and set a delivery date. The day arrives when you are to have your new vehicle delivered. You arrive early at the dealership and get walked through the terms of the agreement, you drink some nice coffee and eat some chocolate biscuits. The time arrives and you are shown your new vehicle......

To your surprise, in the car park, is a pile of boxes from very different manufacturers - some of which you even recognise the names of. The engine has been shipped from Germany, the doors come from Geelong, the wheels from the UK, the chassis from the USA, the radio from Japan.... The sales person explains that what you brought is the best-of-everything meeting your precise requirements. What he failed to explain during the sales process is that you needed to spend an inordinate amount of time wiring and bolting the car together and that getting the vehicle serviced once complete would require visits to multiple providers. The salesperson offers the names of several mechanics and auto-electricians that can help you put together your new vehicle - at additional cost of course.

What do you end up with....?


As casual as this seems - this happens every-day around the world with ECM solutions. You think you know what you are getting from the vendor but more-often-than-not - you actually get something different. The document management solution doesn't talk to the WCM solution. Records policies cannot be applied to collaborative content. The WIKI and BLOG environment is separate and based upon unsupported open-source code. The user-interface looks clunky and the solution delivers not one, but many silos of information that you need to manage.

Your organisation doesn't need this, if it happens you will end-up spending more money that you ever imagined and the promise of an enterprise content management environment may never materialise! Your users will face an interface that doesn't provide any value and impacts their ability to perform their role on a daily basis. Of course, the inverse of this is a nice-looking interface that sits on top of a messy back-end that just causes headaches for the IT department to manage.

What you need is a nice-looking, functional user-interface based upon a complete, integrated and open-standards based back-end that provides the ECM capability that your organisation needs. This is simple, surely?

The perfect ECM architecture, I'll introduce you to that in the next article!

Paul

Wednesday, November 19, 2008

Oracle Fusion Middleware Forum

The recent OFM Forum was a great success in Sydney and Melbourne with around 150 people attending each event.  The event covered all facets of OFM with particular attention on the WebLogic Application Grid, Governance, SOA Best Practice and product roadmap information.  Presently also were several key Oracle Fusion Middleware partners including Intelligent Pathways, Integral Technology Solutions and Renewtek.

Thanks to all who attended. Below are links to the various presentations and podcast recordings of the speakers.

First up was Matt Wright (ANZ Product Marketing). Matt spoke about the Application Grid and how the concept of pooling compute resources and the services and data layers can result in much greater efficiency and scalability for applications.  Below is Matt’s presentation.  The podcast for Matt's presentation is here.

Next Ryan Close (CIO of Australian Vintage Limited) spoke about the use of SOA within the AVL. This focused on the automation of Order Management and the use of BAM to get greater business visibility.  Ryan’s presentation below and the podcast is here.



The next presentation came from Alison Foster (Managing Consultant at Integral Technology Solutions) who spoke about the how Business Process Management can enable a more dynamic business environment. Alison’s presentation is below and the podcast recording here.



We then shifted focus to governance and had Aaron Blishen (Solution Architect and Intelligent Pathways) talk about how to avoid becoming and SOA statistic through using the appropriate methodologies, tools and skills to ensure high quality delivery of projects.  Aaron’s presentation is below and the podcast here.

After a great lunch we had Peter McTaggart (CTO of Renewtek) speak about the use of Agile Methodologies and the relationship of these new project approaches to SOA.  Peter’s presentation is below and the podcast is here.



Wrapping up the day was Saul Cunningham (SOA Business Development, Oracle) who spoke about SOA Adoption and Best Practice.  This presentation looked at the SOA Maturity Model and the typical progression and best practice at the various levels. Saul’s presentation can be found below and the podcast here.

Monday, November 17, 2008

Real Application Testing Certified with E-Business Suite

One of the significant new options of Oracle Database 11g, Real Application Testing, is now certified with Oracle Oracle E-Business Suite Release 11i and 12. This means that for E-Business suite customers who wish to upgrade their database layer, from 10gR2 to 11g in preparation for an apps R12 upgrade.

Or migrate from a single siloed, monolithic infrastructure to a RAC cluster, as part of a consolidation strategy. You now have a tool that will greatly assist in all that expensive, mundane and repetitive testing that needs to be done when migrating a business critical application.

For more info take a look here:-

http://blogs.oracle.com/stevenChan/2008/11/real_application_testing_certified_with_ebs.html

Once you have migrated your EBiz to 11g you can then start looking at the benefits of Advanced Compression.

http://blogs.oracle.com/stevenChan/2008/10/using_advanced_compression_with_e-business_suite.html

Barry