Mazen Manasseh, Author at Perficient Blogs
Blog

Posts by this Author

  • Topics
  • Industries
  • Partners

Explore

Topics

Industries

Partners

Mazen Manasseh

LinkedIn Public Profile

Posts by this author:

How to Import Oracle DB Dumps into ADW using SQL Developer

In this blog post I demonstrate how to import Oracle Database schemas from dump files into Autonomous Data Warehouse (ADW). In this post, I use SQL Developer to run the Data Import Wizard. Quick links to other posts in this series: Summary Blog Post Export Data into Dump Files Option 1: Export DB Schemas Using SQL […]

Read more

Easily Upload Large Files to Oracle Object Storage with Swift REST

This post is in a series of blog posts on migrating schemas from an Oracle DB (Cloud DBaaS) to Autonomous Data Warehouse (ADW). This post is focused on uploading the large Data Dump files from the DBaaS compute machine onto Cloud Object Storage using Swift REST. Quick links to other posts in this series: Summary […]

Read more

How to Upload Large Files to Oracle Object Storage with OCI CLI

This post is in a series of blog posts on migrating schemas from an Oracle DB (Cloud DBaaS) to Autonomous Data Warehouse (ADW). This post is focused on uploading the large Data Dump files from the DBaaS compute machine onto Cloud Object Storage. Quick links to other posts in this series: Summary Blog Post Export […]

Read more

How to Export Oracle DB Schemas Using Data Pump Command

This is part of a blog series on migrating data from Oracle Databases into Oracle Autonomous Data Warehouse (ADW). This blog discusses exporting Oracle Database Schemas using the Data Pump Command. Quick links to other posts in this series: Summary Blog Post Export Data into Dump Files Option 1: Export DB Schemas Using SQL Developer Option […]

Read more

How to Export Oracle DB Schemas Using SQL Developer

This is part of a blog series on migrating data from Oracle Databases into Oracle Autonomous Data Warehouse (ADW). This blog will discuss how to export Oracle Database Schemas using the SQL Developer. Quick links to other posts in this series: Summary Blog Post Export Data into Dump Files Option 1: Export DB Schemas Using […]

Read more

Migrating Data from Oracle Databases to Autonomous Data Warehouse

Creating a new Oracle Autonomous Data Warehouse (ADW) Cloud instance is a quick task. But migrating data over from one or more other Oracle databases will require a few steps. This blog series leverages the Oracle Data Pump technique to export and import schemas from Oracle DB into ADW. The overall process consists of 3 […]

Read more

Oracle Fusion SaaS Security with Oracle Analytics Cloud

The question that is often asked is: Can we leverage the same security we already have in Oracle Fusion SaaS (which includes users, duties, roles and security policies) to secure data in Oracle Analytics Cloud (OAC – an Oracle PaaS)? The answer is Yes. To understand better how this is possible, keep reading. This blog […]

Read more

How to Create an OAC Data Replication from Oracle SaaS?

Oracle Analytics Cloud offer several options when it comes to loading data from Oracle SaaS (such as Financials, HCM, Sales, etc…). Using OAC against Oracle SaaS has several advantages, and most importantly being able to perform analytics on data that is not part of the SaaS application. You may be familiar with using Data Sync […]

Read more

How to Integrate Oracle SaaS Data into Oracle Analytics Cloud?

Reporting on Oracle Fusion and non-Fusion SaaS Apps from Oracle Analytics Cloud (OAC) is a common solution to performing cross-functional reporting from one or more Cloud and non-Cloud applications. The BI capabilities within each of the transaction systems, whether Financials, HCM, Sales or other, are limited when it comes to integrated reporting with external data […]

Read more

Oracle BI Data Sync: How to Add a New Fact

Following my previous blog post on how to add a new Dimension to a Data Sync task, this post looks at how to add a Fact and perform a lookup on dimensions while loading the target fact table in a data warehouse using Data Sync. To refer to the blog post on adding a Dimension […]

Read more

Oracle BI Data Sync: How to Add a New Dimension

In this and the following post, I will cover the steps entailed in adding dimension and fact tasks in Oracle Data Sync. The latest releases of Data Sync included a few important features such as performing look-ups during an ETL job. So I intend to cover these best practices when adding new dimension and fact […]

Read more

The Road to Oracle Analytics Cloud from OBIEE & BI Apps [Webinar]

If you are already running OBIEE/OBIA on premises and wondering about your options to migrate to Oracle Analytics Cloud (OAC), you are not alone. Many are overwhelmed by this transition and might be asking themselves questions such as “What does it take to get migrated to the cloud? When should I make this transition? What […]

Read more

3 Easy Ways to do ML with Oracle Analytics Cloud

Over the past couple years several Machine Learning (ML) capabilities have made their way into Oracle Analytics Cloud (OAC). If you are using OBIEE or OAC and wanting to apply ML to your data, there is no need to look for an additional software to do that. There are several ways in which ML capabilities […]

Read more

From OBIEE or OBIA to OAC: The Fundamentals at #C18LV

Oracle Cloud BI solutions have been available for a few years now and have evolved significantly over the past couple years. If you have been using OBIEE or OBIA (Oracle BI Applications), you are in a pretty good position to start migrating to Oracle Analytics Cloud (OAC). The reason: OAC relies on a similar underlying […]

Read more

OBIEE Reporting for HFM: Solution for Hierarchical Roll-ups

One of the many multi-dimensional data sources that OBIEE supports is Hyperion Financial Management (HFM). If you have used Essbase as a data source in OBIEE, you will realize that HFM integrates in a similar approach, but not quite the same. While a direct connectivity between OBIEE and HFM is very useful for financial users, […]

Read more

How to Connect Oracle OAC to Planning & Budgeting Cloud?

Oracle Analytics Cloud (OAC) was updated recently to support direct connectivity with Oracle Planning & Budgeting Cloud Service (PBCS) and EPBCS. Consequently, we can now source data live from PBCS applications without the need to extract and import into OAC. I have seen several financial departments use PBCS as a source for budgets and forecasts […]

Read more

5 Oracle Analytics Trends to Watch Out for Starting Now

“Catching up” is the term that came to mind when I used to check out what’s new with Oracle Analytics in previous years. This year, however, I frankly say I was impressed with what I saw at Oracle Open World last week. The rules of the analytics platform game have changed, tremendously. This is after […]

Read more

Running Oracle BI Apps or OBIEE On Premises? Cloud or No Cloud?

I spend much of my time figuring out what things organizations are doing well when it comes to their enterprise analytics, what makes them better, and how to get there. After a few communications consulting for a new customer, I came to realize that they are likely categorized in one of three groups, most if […]

Read more

Day by Day: An Oracle Personal Assistant for Enterprise Analytics

You are in a hurry and away from your office desk but really need an important piece of information before your next call or meeting. If only Siri or Google Voice can help. These personal assistants can’t answer questions related to your secure enterprise data, at least not without some serious amount of programming. Last […]

Read more

Business Analytics Cloud at Collaborate 17 #C17LV

At the Collaborate 17 conference, I attended the official announcement of the release of Oracle Analytics Cloud (OAC), delivered by John Hagerty, VP of Product Management. It was a clear message from Oracle BI Product Management that Oracle’s Cloud BI offerings are positioned to provide a solution for “Everyone”. “Everyone” here is primarily twofold: First, BI […]

Read more

Subscribe to the Weekly Blog Digest:

Sign Up