www.onecloud.io
1460 Broadway New York, NY 10036
2018
Oracle OAC BizApp In Action
(212) 749-2220
OneCloud, Inc.
{{page}}
So what is happing out there? Or what isn't?
The OneCloud BizApp for Oracle Analytics Cloud (OAC) provides a powerful way to connect and automate OAC with a range of on-premise and cloud technologies. Eliminate the need to write and manage script with OneCloud's out-of-the-box functions for the execution of calculations, exchange and load of data and commands to administer OAC. When combined with other technologies that OneCloud supports, the possibilities become endless and truly enables a scalable, maintainable, and auditable approach to automate your enterprise. These capabilities in turn, provide OAC application owners an ability to share and streamline data and tasks between a hybrid mix of applications. Additionally, business users can be granted access to manage, run or even build their own OneCloud automations through the user-friendly and self-service web and mobile interface that also integrates with messaging platforms such as Slack. Later in this white paper, we will explore two possible use cases of the OneCloud Oracle OAC BizApp: Directly extract and load Oracle PBCS to Oracle OAC. Enhanced administration of OAC operations. But first let's provide a bit more background and insight into the OneCloud platform.
| OneCloud OAC BizApp
Jeff Brobst (VP Financial Planning, Seagate)
OneCloud is an integration and automation platform designed to boost end-user productivity and reduce the burden on IT. OneCloud seamlessly connects legacy and modern technologies and orchestrates complex handshakes across a hybrid mix of on-premise and cloud systems while making it easy for application owners and end-users to be self-sufficient in a code-free and intuitive environment. The focus of this white paper is to highlight specific OneCloud functionality that support Oracle OAC. The intended audience are users and administrators of Oracle OAC. To learn more about the OneCloud platform or other application specific support, please visit www.onecloud.io
About OneCloud
"The OneCloud platform enabled our corporate planning team to be self-sufficient from day 1 to connect and automate our cloud and on-prem apps…the easiest go-live we’ve ever experienced."
OneCloud Oracle OAC Planning Analytics BizApp
Enterprise software has become so fragmented and unnecessarily complex that end-users struggle to use it. Enterprise software users rightfully complain about clunky interfaces that lack visibility and self-service. This places an extraordinary amount of pressure on IT departments to keep the data flowing and is having an adverse effect on productivity. One factor in boosting business productivity is to build an ecosystem of connected applications. To accomplish this, the first order of business is to tackle the integration of a vast number of fragmented enterprise applications. This integration challenge goes hand-in-hand with the need to orchestrate and automate the many processes that support critical business functions that are the heartbeat of every company including: operational planning, performance management and business intelligence. The final and most overlooked step to boost productivity is to empower the business user. Business users nowadays already bring to the workplace a savvy ability to use an array of digital tools from social media to ride hailing services and now every company with an eye on the future should enable its business users with a powerful tool-set to get more done with less. A user-friendly tool that allows end-users to easily run and manage their business processes on-demand is imperative, but the concept of self-service and self-sufficiency is still deafeningly and surprisingly absent in today’s enterprise. Let’s change that! - The OneCloud Team
OneCloud Terminology
The OneCloud Platform
OneCloud ensures that cloud and on-premise applications operate together. The platform's native connectivity to many of the most widely used enterprise performance management (EPM), business intelligence (BI), and resource management systems allows for a connected ecosystems of applications. OneCloud eliminates the challenges of integrating a hybrid mix of technologies that co-exist on premise and in the cloud. Key features of the OneCloud architecture include:
Deployment Architecture
Command Commands are the building blocks of OneCloud automation workflows (chains). A command is a single task that is pre-configured to perform an operation on a system. When building a command, the user links it with a connection in order to choose where the command is executed. Chain A linear sequence of commands that represents an automation workflow. Chains can be scheduled, run manually, or even triggered externally via the OneCloud API. Each chain allows a user to build commands based on conditional logic. Commands can also be grouped within a chain, and execute either serially or in parallel. Connection A connection consists of a resource (i.e. a server) that is pre-configured to run a certain type of command and the credentials associated with connection to a particular application (i.e. login information for a SaaS platform). Connections can be configured to use either a Linux or Windows environment. Commands are aware of which connections they need to run (for example, a command that can run only in a Windows environment), and cannot be created until an appropriate connection is configured. Environment Environments are used to manage the life-cycle of your chains. Chains can be moved between environments, and variables can be set per environment. The most common example is using a development environment to test your chain, and when you are happy with the results, you can promote the chain into a production environment. Resource Resources are files that are managed within the OneCloud platform. They be can attached to commands as inputs, and even support variable replacement for extensibility and re-usability throughout a user's workflows. Runner Runners are the agents that carry out commands and send the results to OneCloud. CloudRunners are managed by OneCloud, whereas GroundRunners operate within a user's the corporate firewall. Users control where commands are run by linking each connection to a particular runner. Variable In the context of OneCloud, variables are inputs that can be changed. Variables defined on a workspace can be used across chains that belong to that workspace, and variables defined in a chain can be used locally by the chain's commands. In addition, commands can use a variety of system-level (for example, current time) and metadata variables (chain name, environment, etc). Outputs Outputs are artifacts from previous Commands and can have the following types: Strings, Integers, Lists, Dates, JSON, Maps, File. They will appear as variables in subsequent commands in a chain. Workspace A grouping of related workflows that encapsulates multiple environments. In addition, workspaces can store variables that can be used within chains and commands. Lastly, connections are stored at the workspace level.
Connect & Automate Code-Free
Self-service to manage, view and run automated processes via web and mobile interfaces. CloudRunners and GroundRunners that natively integrate cloud and on-premise applications.
OneCloud allows technical and non-technical users to easily connect, automate, manage and run their applications. OneCloud Chains are created by simply adding automation commands and setting parameter values. In the example to the left, OneCloud is being configured to export data from PBCS, convert the native PBCS SUI format to a standard CSV format and finally load the content to OAC.
OneCloud Oracle OAC BizApp - Case Studies
Case Study I: Directly extract and load Oracle PBCS to Oracle OAC (con't)
Introduction OneCloud can quickly and easily extract data from Oracle PBCS, converted to a standard and open format and load to target application. The process is easy to setup, relies upon PBCS' native export jobs and eliminates challenges related to standard batch processing. In this case study, a OneCloud chain will be created to perform the following steps: Execute a PBCS Export Data job Download the export data payload Convert from native SUI format to CSV Filter unneeded columns Upload the converted CSV content to OAC Import the CSV content to the target cube via a load rule
Step 1 - Export and retrieve the plan Using PBCS' native data export functions, create a job to export the required slice of data and download the content. Leverage OneCloud's built-in feature to automatically decompress the data payload so it can be subsequently converted from SUI format to CSV in the next step.
Step 2 - Convert from SUI to standard CSV OneCloud has a unique out-of-the-box function to convert PBCS' native Standard User Interface (SUI) format to CSV. This is especially handy to set up a predefined rule that maps the POV fields to standard columns that can be loaded to a target such as Oracle OAC.
Case Study I: Directly extract and load Oracle PBCS to Oracle OAC
Step 3 - Filter unneeded columns OneCloud has lightweight transformation capabilities to easily filter columns, rows, find & replace, join and split columns. In the example to the left, a column filter is being applied to the converted output from the prior step. The filter will strip off all columns except the columns 1 to 12 and 20 to 24 based upon the column index.
Step 4 - Preview results prior to loading to the target The example on the right demonstrates a "load ready" CSV format that has been converted from the PBCS SUI format and now ready to load to OAC.
Step 5 - Upload to OAC Once the data is in a standard tabular format, it can be used by an array of systems. In the example to the left, the output from the column filter is being uploaded directly to the application/database location in OAC.
Step 1 - Create OneCloud chains to support the process flow. To the right are two sample OneCloud chains to automate OAC tasks such as start & stopping the cubes, executing scripts, LCM exports, clearing data, building dimensions and loading data and file management.
Step 2 - Configure the Commands OAC administrators can easily configure each command by setting the appropriate value for each parameter. Alternatively, variables can be leveraged that are set system-wide or dynamically based upon an external event. In the example to the left, a region of data is being cleared via an MDX expression.
Case Study II: Enhanced administration of OAC operations
Introduction OneCloud has specialized commands to perform important OAC operations to calculate OAC business logic including consolidation, translation and allocations. Additionally, OneCloud can perform data management operations to control clearing and copying data in combination with open and closing periods and enabling and disabling connection after users have been forcibly logged off.
The OneCloud Oracle OAC BizApp has the following commands available to connect and automate OAC with other applications supported by OneCloud. Each command has different parameter inputs and outputs that are relevant to the operation being performed. Please see http://docs.onecloud.io/ for more information.
More on the OneCloud Oracle OAC BizApp
Available Commands
List Objects List Applications List Databases List Files List Filters List Locks List Variables Load & Data Operations Build Dimension Load Data Clear Data Deploy Spreadsheet
Script Execution Calculation Scripts MaxL Scripts MDX Script File Operations Upload File Download File Delete File Administrative Operations LCM Export LCM Import Start Application | Database Stop Application | Database
Technical data subject to modification and delivery subject to availability. Any liability that the data and illustrations are complete, actual or correct is excluded. Designations may be trademarks and/or copyrights of the respective company, the use of which by third parties for their own purposes may infringe the rights of such owner.
Disclaimer
All rights reserved, including intellectual property rights. Changes to technical data reserved. Delivery subject to availability. Any liability that the data and illustrations are complete, actual or correct is excluded. Designations may be trademarks and/or copyrights of the respective company, the use of which by third parties for their own purposes may infringe on the rights of such owner. For further information see http://www.onecloud.io ©2018 OneCloud, Inc
Copyright
