If you’re looking to copy over data from one Oracle Autonomous Database (ADB) to another, you are probably wondering how to go about doing that. OCI offers a whole database clone capability which is straightforard to use and provides a clone of the whole autonomous database within the same Oracle Cloud tenant. However, if you’re […]
Posts Tagged ‘Autonomous Data Warehouse’
Supplement Oracle EPM with Oracle Analytics and Autonomous Data Warehouse in 10 Weeks
Are you looking to supplement your Oracle EPM applications with enhanced analytics capabilities? At Perficient, we have successfully implemented analytics solutions that complement both on-premises Hyperion applications as well as Oracle EPM Cloud business processes: Planning and Budget Cloud Service, Financial Consolidation & Close Service, and Essbase Cloud. Our methodology requires minimal data movement leveraging […]
See How Adding Oracle Analytics Can Elevate Your EPM Experience
The Oracle EPM suite provides best-in-class business process applications when it comes to activities such as financial planning, consolidation and period-end close. Organizations are often looking for ways to easily incorporate financial information, out of EPM applications, into consolidated reporting with other systems (such as ERP, Sales, HR, and others). Also, there is great value […]
Autonomous Data Warehouse is the Business Analyst’s Dream Database
At the heart of all business software is always a database. But what once used to be a cumbersome component, something that only developers and system administrators had to deal with, has evolved to become a directly reachable solution of itself. With Oracle Autonomous Data Warehouse (ADW), the Business Analyst is now able to be […]
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 […]
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 […]