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 […]
Mazen Manasseh –
Mazen is a Director of Data & Analytics at Perficient and an accomplished professional services leader with 20 years of being a customer advocate. An analytics solutions delivery expert in functional domains covering Supply Chain, Financials, HCM, Projects and Customer Experience. Being a thought leader in the business analytics space, he conducted numerous business training sessions and spoke at technology conferences around analytics and machine learning.
Connect with Mazen
Blogs from this Author
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]