Posts Tagged ‘ADW’

Natural language AI has proliferated into many of today’s applications and platforms. One of the high in demand use cases is the ability to find quick answers to questions about what’s hidden within organizational data, such as operational, financial, or other enterprise type data. Therefore leveraging the latest advancements in the GenAI space together with […]

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

One of the easiest and lowest maintenance approaches to feed Fusion Cloud Apps data into a data warehouse, is with Oracle Analytics Cloud (OAC) Fusion Business Intelligence Cloud Connector (BICC) Data Replication. Data Replication for Fusion Apps is a native feature of OAC Enterprise edition. If you’re migrating your on-premises application, such as E-Business Suite, […]

As organizations are moving faster to reduce their inhouse infrastructure, database and application management overhead, many are migrating their legacy on-premises ERP, SCM, HCM, and CX applications to Oracle Fusion Cloud Applications. And it is very common to see such organizations already invested in a consolidated data warehouse. A data warehouse is typically a common […]

The current economy has elevated the old saying that ‘Cash is King’ to new heights. With the altered nature of business flows arising from the COVID-19 crisis, many enterprises face new challenges to their continued existence, much less success. Being aware of Working Capital balances and taking proactive action has never been more important to […]

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

Perficient’s absence management solution with COVID-19 data helps businesses stay proactive, avoid productivity loss and better plan for skill back-fills. Absence and workforce management is one of the key HR functions that play an important role in the overall operation and performance of a company. This is even more crucial at a time when typical […]

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