Posts Tagged ‘Autonomous Data Warehouse’

Oracle Cloud ERP offers several built-in reporting capabilities to address the needs for operational reporting. Implementing more elaborate reporting use cases though requires that we extract data out of Oracle Cloud ERP. This is in part because the real-time Fusion APIs are more tailored for transactional interfaces and therefore not adequate to scale to a […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]