Tag Archives: Cloud

The Case for ETL in the Cloud – CAPEX vs OPEX

Recently Oracle announced a new cloud service for Oracle Data Integrator. Because I was helping our sales team by doing some estimates and statements of work, I was already thinking of costs, ROI, use cases, and the questions behind making a decision to move to the cloud. I want to explore what is the business case for using or switching to ODICS?

Oracle Data Integration Cloud Services

First, let me briefly talk about what is Oracle Data Integration Cloud Services? ODICS is ODI version 12.2.1.2 available on Oracle’s Java Cloud Service known as JCS. Several posts cover the implementation, migration, and technical aspects of using ODI in the cloud. Instead of covering the ‘how’, I want to talk about the ‘when’ and ‘why’.

Use Cases

What use cases are there for ODICS?
1. You have or soon plan to have your data warehouse in Oracle’s Cloud. In this situation, you can now have your ODI J2EE agent in the same cloud network, removing network hops and improving performance.
2. If you currently have an ODI license on-premises, you are allowed to install that license on Oracle’s JCS at the JCS prices. See here for more information about installing on JCS. These use cases are described in a webinar posted in the PM Webcast Archive.

When and Why?

So when would it make sense to move towards using ODICS? These are the scenarios I imagine being the most likely:
1. A new customer or project. If a business doesn’t already have ODI, this allows them to decide between an all on-premises solution or a complete solution in Oracle’s cloud. With monthly and metered costs, the standard large start-up costs for hardware and licenses are avoided, making this solution available for more small to medium businesses.
2. An existing business with ODI already and considering moving their DW to the cloud. In this scenario, a possible solution would be to move the current license of ODI to JCS and begin using that to move data, all while tracking JCS costs. When the time comes to review licensing obligations for ODI, compare the calculation for a license to the calculation of expected usage for ODICS and see which one makes the most sense (cents?). For a more detailed explanation of this point, let’s talk CAPEX and OPEX!

CAPEX vs. OPEX

CAPEX and OPEX are short for Capital Expense and Operational Expense, respectively. In a finance and budgeting perspective, these two show up very differently on financial reports. This often has tax considerations for businesses. Traditionally in the past, a data warehouse project was a very large initial capital expenditure, with hardware, licenses, and project costs. This would land it very solidly as CAPEX. Over the last several years, sponsorship for these projects has shifted from CIOs and IT Directors to CFOs and Business Directors. With this shift, several businesses would rather budget and see these expenses monthly as an operating expense as opposed to every few years having large capital expenses, putting these projects into OPEX instead.

Conclusion

Having monthly and metered service costs in the cloud that are fixed or predictable are appealing. As a bonus, this style of service is highly flexible and can scale up (or down) as demand changes. If you are or will soon be in the process of planning for your future business analytics needs, we provide expert services, assessments, accelerators, and executive consultations for assisting with these kinds of decisions. When it is time to talk about actual numbers, your Oracle Sales Representative will have the best prices. Please get in touch for more information.

Oracle Analytics Cloud: Product Overview

Oracle Analytics Cloud: Product Overview

We at Rittman Mead are always helping our customer solving their problems, many times we heard them

  • being unsure about the sizing of their server
  • being worried about the upfront cost of the licensing
  • having recurring nightmares about patching
  • willing to try the cloud but couldn't find the right option to replace their on-premises system

This is their lucky day: Oracle officially launched Oracle Analytics Cloud (OAC), a new PaaS (Platform as a Service) providing a complete and elastic Business Intelligence platform in the cloud, customizable and managed by you but all on the Oracle Cloud!

Oracle Analytics Cloud: Product Overview

If you haven't been on a remote island you may have noticed that in recent years Oracle's main focus has been around the Cloud. Several products have been launched covering a vast spectrum of functionalities: Data Management, Application Development, Business Analytics and Security are only some of the areas covered by the Software/Platform/Infrastructure as a Service offering.

Oracle Analytics Cloud: Product Overview

In the Business Analytics area, we at Rittman Mead started thinking long time ago on how to host Oracle's BI on-premises (OBIEE) in the Cloud and worked closely with Oracle since the beta phase of their first PaaS product: BI Cloud Service (BICS). Effectively we put our hands on all the cloud products in the BA family like Big Data Discovery (both on premises and cloud), Data Visualization Cloud Service, Big Data Preparation Service.

Business Intelligence Cloud Products

Until few weeks ago Oracle's main Business Analytics cloud products were BI Cloud Service (BICS) and Data Visualization Cloud Service (DVCS). As mentioned in our blog both tools aimed initially at departmental use-cases: the simplicity of the data model interface and the lack of admin configuration options stopped them from being a compelling story for hosting a full enterprise Business Intelligence solution.

Oracle Analytics Cloud: Product Overview

New features like BICS Data Sync, Remote Data Connector and RPD lift and shift addressed almost all the limitations but the lack of detailed admin/maintenance capabilities represent a stopper for moving complex environments in the cloud. Still BICS and DVCS are perfect for their aim: business users analysing sets of data without needing to wait the IT to provision a server or to care about upfront licensing costs.

Oracle Analytics Cloud

Oracle Analytics Cloud extends the watermark in every direction by providing a product that is:

  • Complete functionality: most of the tools, procedures and options provided on-premises are now available in OAC.
  • Combining all the offering of BICS, DV, BIEE and Essbase: OAC includes the features of Oracle's top BI products.
  • Licensing Tailored: the many options available (discussed in a later post) can be chosen depending on analytical needs, timeframe of service, required performances
  • Easily Scalable: do you want to expand your BI solution to the double of the users without loosing performances? Just buy some more horsepower!
  • Fully Accessible: SSH connection available to the server makes it easy to change settings as needed, REST API and Clients are provided for all lifecycle operations
  • Customizable: settings, images, networking, VPN all settings are available
  • Scriptable: settings like scaling, instance creation and deletion, start and stop can be easily scripted via the REST-APIs
  • Fully Customer Managed: Oracle provides the automation to backup and patch but the customer decides when to run them.

What's The Difference?

So what's the difference between Oracle Analytics Cloud and the "old" DVCS and BICS? How is OACS going to change Oracle's BI offer in the cloud?

The great deal of using OACS is control: BICS/DVC limiting factors around admin options and development are solved providing a tool capable of hosting a full enterprise BI solution. Even if the platform is managed by Oracle SSH access is provided meaning that instance configurations can be changed. No more upfront server sizing decisions, now the size of the instance is decided during creation time and can be changed later in the process if the demand changes.

The REST-APIs will enable the scripting of the full lifecycle of the instance, providing a way to automate the BI enterprise workflow even in complex environments where concurrent development is needed. Patching and Backups are not a problem anymore with the automated processes provided.

Direct RPD online editing is available with the Admin tool. The old BICS Data Modeler is still there for simple models, but Admin Tool can be used in case of complex RPDs.

Oracle Analytics Cloud: Product Overview

The front-end is like the BICS and OBIEE 12c one, some new visualization have been added to Visual Analyzer in line with the new additions to Data Visualization Desktop: Parallel Coordinates, Chord, Network, Sankey diagrams are now available.

Oracle Analytics Cloud: Product Overview

A new console is now available in Visual Analyzer allowing settings like Mail or Deliveries that before were only accessible via Weblogic Console, Enterprise Manager or config files.

Oracle Analytics Cloud: Product Overview

Finally Essbase is now available in the cloud too with a new web interface!
Summarizing, if you wanted to go Cloud, but were worried about missing options, now Oracle Analytics Cloud provides all you need to host a full Enterprise BI solution.

In the next few days I'll be analysing various aspects of Oracle Analytics Cloud Suite, so keep in touch!

If you need assistance in checking if Oracle Analytics Cloud suits your needs or in planning your migration to the cloud don't hesitate to contact us

Oracle Tax Reporting Cloud (TRCS) – April 2017 Update

The following announcements and considerations are outlined in the upcoming Oracle Tax Reporting Cloud (TRCS) update:

Oracle Tax Reporting Cloud (TRCS)
April 2017 Updates

Monthly Update Schedule:

We would like to inform you of the upcoming monthly update for your Oracle Cloud environments. We will apply the latest updates to your test environment on Friday, April 7, 2017 and to your production environment on Friday, April 21, 2017. The update will be applied during your normal daily maintenance window.

    Announcements:

    • Using the Tax Reporting Cloud Sample Application 
    • Configuring Jurisdictions and Entities 
    • Enhanced Usability of the RTA Automation Form 
    • Importing Data 
    • Displaying the POV Member Selector for a Report 
    • Performance Enhancements 
    • New EPM Automate Utility Version 
    • Single Sign-On Access with NetSuite 
    • Accommodating Daylight Savings Time 
    • Activity Report Now Contains Information on Long Running Reports
    • New Smart View for Office Version 
    • Changing Financial Reporting Server Values in Financial Reporting Web Studio
      Refer to the following links and documents for further information:
      • Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. To access this broad range of assets, locate your service on the left, then choose a release from the service's drop-down menu. Learn and how to plan your upgrade by reviewing expanded discussions of new features,including capability overviews, business benefits, setup considerations and usage tips.
      • My Oracle Support (MOS) Knowledge Article: Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1

      Oracle Profitability and Cost Management Cloud (PCMCS) – April 2017 Update

      The following announcements and considerations are outlined in the upcoming Oracle Profitability and Cost Management Cloud  (PCMCS) update:

      Oracle Profitability and Cost Management Cloud  (PCMCS)
      April 2017 Updates

      Monthly Update Schedule:

      This document outlines the announcements and known issues in the upcoming Oracle Profitability and Cost Management Cloud Service update. Oracle applies the monthly service update to your test environment on the first Friday of every month and to your production environment on the third Friday of every month.

      We would like to inform you of the upcoming monthly update for your Oracle Cloud environments. We will apply the latest updates to your test environment on Friday, April 7, 2017 and to your production environment on Friday, April 21, 2017. The update will be applied during your normal daily one-hour maintenance window.

      Known Issues:

      • Translated Help and Guides Are Now Available 
      • New Smart View for Office Version 
      • Single Sign-On with NetSuite 
      • Improved Smart View Cell Formatting 
      • Dimension Management Improvements 
      • Activity Report Now Contains Information on Long Running Reports
      • Changing Financial Reporting Server Values in Financial Reporting Web Studio 
      • Activity Report Now Includes Smart View Version Information 
      • Oracle Profitability and Cost Management Cloud Supports Smart View Private Connections 
      • Avoid Special Characters in Artifact Names, Including Calculation Rules 

      Removal of Support for Financial Reporting Studio Desktop Client

      Oracle is committed to providing a simple and intuitive experience to the users of the service. To achieve this goal, Financial Reporting Web Studio will be established as the only tool for designing and building reports. In this update, Financial Reporting Web Studio will achieve parity with most of the functional capabilities provided with Financial Reporting Studio desktop client. You will be able to create new reports and modify existing reports using Financial Reporting Web Studio.

      Support for Financial Reporting Studio desktop client will tentatively be stopped in the May 2017 update. Oracle will not distribute Financial Reporting Studio desktop client after May 2017. Please send questions and concerns to Oracle using the Provide Feedback option in the service.

      Oracle recommends that you transition to using Financial Reporting Web Studio at the earliest opportunity.

        Refer to the following links and documents for further information:

        • Oracle Cloud Release Readiness - Get up to speed on the latest cloud release and ensure your upgrade is a success with Oracle's Release Readiness assets. To access this broad range of assets, locate your service on the left, then choose a release from the service's drop-down menu. Learn and how to plan your upgrade by reviewing expanded discussions of new features,including capability overviews, business benefits, setup considerations and usage tips.
        • My Oracle Support (MOS) Knowledge Article: Enterprise Performance Management Cloud Release Highlights Doc ID 2055579.1