Enhance Your Oracle EPM Reporting with Qubix Cloudbridge Across a Hybrid Environment
- Link and unite source data and cloud applications across your hybrid IT environment.
- Establish control and trust in the data with master data management capabilities.
- Provides the Finance team fast and easy access to data and apps so they can do more in less time.
Architecture
This architecture shows the deployment of Qubix Cloudbridge in a single availability domain, inside a single infrastructure region, along with a default Oracle Autonomous Data Warehouse and Oracle Analytics Cloud.
The following diagram illustrates this reference architecture.
Description of the illustration epm-reports-hybrid-env.png
epm-reports-hybrid-env-oracle.zip
The architecture focuses on the following logical divisions:
- Data refinery
Ingests and refines the data for use in each of the data layers in the architecture. The shape is intended to illustrate the differences in processing costs for storing and refining data at each level and for moving data between them.
- Data persistence platform (curated information layer)
Facilitates access and navigation of the data to show the current business view. For relational technologies, data may be logical or physically structured in simple relational, longitudinal, dimensional or OLAP forms. For non-relational data, this layer contains one or more pools of data, either output from an analytical process or data optimized for a specific analytical task.
- Access and interpretation
Abstracts the logical business view of the data for the consumers. This abstraction facilitates agile approaches to development, migration to the target architecture, and the provision of a single reporting layer from multiple federated sources.
The architecture has the following components:
- Qubix Cloudbridge
Qubix Cloudbridge is a web tool that empowers business users to integrate data, manage data, and manage metadata. Cloudbridge uses pre-built connectors and commands for a zero-coding experience and virtually eliminates dependency on IT to run data integration and management processes.
Cloudbridge functions as the central hub through which all data and processes flow - empowering users to build and automate all flows from a single place with speed and ease. Link and unite source data and cloud applications across your hybrid IT environment. Establish control and trust in your data with master data management capabilities. Level up your team with fast and easy access to your data and apps so they can do more in less time.
Cloudbridge is certified by Oracle and deployed from the Oracle Marketplace.
- Autonomous Data
Warehouse
Oracle Autonomous Data Warehouse is a self-driving, self-securing, self-repairing database service that is optimized for data warehousing workloads. You do not need to configure or manage any hardware, or install any software.
Oracle Autonomous Data Warehouse eliminates all the complexities of operating a data warehouse, securing data, and developing data-driven applications. It automates provisioning, configuring, securing, tuning, scaling, and backing up of the data warehouse. It includes tools for self-service data loading, data transformations, business models, automatic insights, and built-in converged database capabilities that enable simpler queries across multiple data types and machine learning analysis.
- Oracle
Analytics Cloud
Oracle Analytics Cloud is a scalable and secure public cloud service that provides the industry’s most comprehensive cloud analytics in a single unified platform, including everything from self-service visualization and powerful inline data preparation to enterprise reporting, advanced analytics, and self-learning analytics that deliver proactive insights.
With support for more than 50 data sources and an extensible, open framework, Oracle Analytics Cloud gives you a complete, connected, collaborative platform that brings the power of data and analytics to every process, interaction, and decision in every environment – cloud, on-premises, desktop and data center.
Recommendations
- Virtual cloud network (VCN)
When you create the VCN, determine how many IP addresses your cloud resources in each subnet require. Using the Classless Inter-Domain Routing (CIDR) notation, specify a subnet mask and a network address range that's large enough for the required IP addresses. Use an address space that's within the standard private IP address blocks.
Select an address range that doesn’t overlap with your on-premises network, so that you can set up a connection between the VCN and your on-premises network, if necessary. Ensure that CIDR blocks don't overlap with any other network (in Oracle Cloud Infrastructure, your on-premises data center, or another cloud provider) to which you intend to set up private connections.
After you create a VCN, you can change, add, and remove its CIDR blocks.
When you design the subnets, consider your functionality and security requirements. Attach all the compute instances within the same tier or role to the same subnet, which can serve as a security boundary.
Use regional subnets.
-
Select an address range that doesn’t overlap with your on-premises network, so that you can set up a connection between the VCN and your on-premises network, if necessary.
When you create a VCN, determine the number of CIDR blocks required and the size of each block based on the number of resources that you plan to attach to subnets in the VCN. Use CIDR blocks that are within the standard private IP address space.
When you create a VCN, determine the number of CIDR blocks required and the size of each block based on the number of resources that you plan to attach to subnets in the VCN. Use CIDR blocks that are within the standard private IP address space.
After you create a VCN, you can change, add, and remove its CIDR blocks.
- Load balancer
While creating the load balancer, you can either select a predefined shape that provides a fixed bandwidth, or specify a custom (flexible) shape where you set a bandwidth range and let the service scale the bandwidth automatically based on traffic patterns. With either approach, you can change the shape at any time after creating the load balancer.
The shape of the load balancer starts at 100 Mbps. Depending on the number of simultaneous connections needed and on the total throughput, you can use larger shapes. This architecture uses a 100 Mbps load balancer.
Use DNS names because the load balancer’s IP address can’t be reserved.
- Instances
A tenancy has two Standard.E2.1 (VM) instance by default, which this architecture uses. If more processing power is required, you can select different shapes.
- Database systems
A tenancy has two Oracle Database, Express Edition (Oracle Database XE) databases, which are used as the metadata repository for each instance. Management information is located in the terraform log.
- Storage
The instances in this architecture use a 50GB boot volume and 2 - 700 GB block storage. Each environment is created with an Oracle Cloud Infrastructure Object Storage bucket to store backups, and public and private keys.
- Network connectivity
You can manage the environment by allowing your IP address in the security group and access through SSH.
You may also manage the environment by connecting to your existing on-premises infrastructure by using a site-to-site VPN or a dedicated connection with Oracle Cloud Infrastructure FastConnect.
If the environment needs to be segregated from the existing infrastructure or accessed externally, a bastion host or bastion service can secure the management connections. The bastion service is typically provisioned in a demilitarized zone (DMZ). It protects sensitive resources by placing them in private networks that can't be accessed directly from outside the cloud. You can avoid exposing the more sensitive components of the architecture without compromising access to them.
- Autonomous Database
- Oracle Autonomous Data Warehouse is recommended, although you can use Oracle Autonomous Transaction Processing without impact.
- Database version 19c
- At least 2 OCPUs
- At lease 1TB Storage
Deploy
The Terraform code for Qubix Cloudbridge is available as a stack in Oracle Cloud Marketplace.
- Deploy by using the sample stack in Oracle Cloud Infrastructure Resource
Manager:
- Click
.
If you aren't already signed in, enter the tenancy and user credentials.
- Review and accept the terms and conditions.
- Select the region where you want to deploy the stack.
- Follow the on-screen prompts and instructions to create the stack.
- After creating the stack, click Terraform Actions, and select Plan.
- Wait for the job to be completed, and review the plan.
To make any changes, return to the Stack Details page, click Edit Stack, and make the required changes. Then, run the Plan action again.
- If no further changes are necessary, return to the Stack Details page, click Terraform Actions, and select Apply.
- Click
-
Deploy by using Oracle Marketplace, follow the instructions in Qubix Cloudbridge BYOL.