OAC Articles - Perficient Blogs
Blog

Posts Tagged ‘OAC’

  • Topics
  • Industries
  • Partners

Explore

Topics

Industries

Partners

Reader’s Choice: Top 5 Oracle Blog Posts of 2019

Subject matter experts in Perficient’s Oracle practice published more than 100 blog posts in 2019!  Many thanks to the team for taking the time to share your thoughts as well as tips and tricks with our readers. Below are the top five Oracle blog posts authored by the Oracle practice in 2019, ranked in order […]

Read more

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

All About Machine Learning with Oracle Analytics

  Perficient Presents at Oracle OpenWorld 2019 – Live from the show floor, a director in our analytics team delivers an overview of the machine learning capabilities of Oracle Analytics Cloud with its built-in ML algorithms. Machine Learning is a science that existed for several decades. However, it wasn’t until the last 10 years that […]

Read more

Oracle Simplifies Branding and Packaging of its Analytics Product

Oracle simplifies its cloud, on-premises and prebuilt analytics applications under a single brand ‘Oracle Analytics’. At the analytics summit this week, Oracle announced a new customer-centric vision for its Analytics product. Under the new product direction, 18+ products which include Oracle Analytics Cloud, on-premises platforms like OBIEE, Oracle BI Applications among others will be consolidated […]

Read more

Oracle Analytics Cloud Cube Designer – #Kscope19

Kscope is where the Oracle technology users come together to share and learn through 300+ technical sessions, hands-on training, all-day symposiums, and networking with Oracle experts. This year, Kscope19, is being held June 23-17 in Seattle, WA. Perficient is proud to be a silver sponsor and exhibitor at Kscope19. Make sure to visit us at […]

Read more

Automating Financial Reporting with Oracle Analytics Cloud

A new ERP system presented a financial reporting challenge for one of the top specialty contractors in the U.S. – the means to assemble financial data from multiple systems (Penta ERP, ADP, and other custom-built applications) and easily distribute that information to various business unit leaders. The current solution required manual intervention and was very […]

Read more

Welcome to the Period of Augmented Analytics

According to Gartner, Augmented Analytics Is the future of Data and Analytics – the next disruption in Analytics and Business Intelligence. It’s the capability of automating insights using machine learning and natural-language generation. If we look back over the last two decades, there are three different waves in the Analytics and Business Intelligence space. Analytics […]

Read more

7 Sessions to Add to Your Collaborate 19 Agenda #C19TX

Perficient is proud to be an OAUG Star Partner and exhibitor at Collaborate 19, which is being held April 7-11 in San Antonio, TX. Did you know that Collaborate is where the Oracle user community comes together to share and learn through 1200+ education sessions, panels and networking events? We are honored to have been […]

Read more

Reflections on Hosting Multiple Oracle Analytics Cloud Workshops

Our team has been partnering with Oracle on running Oracle Analytics Cloud (OAC) Workshops all across North America. To date we have partnered in running more than 10 workshops, the most recent one was held yesterday in Houston, TX. We had a record number of attendees, more than double the capacity we had planned for. […]

Read more

Readers’ Choice: Top 5 Oracle Cloud Blog Posts of 2018

As I look back on 2018, I’d like to thank the amazing bloggers within the Oracle group for contributing such rich content for our readers to enjoy. It’s evident by the numbers that some topics really struck a chord. Subscribe to our blog if you haven’t already and you’ll never miss another blog post! Hopefully, […]

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

Subscribe to the Weekly Blog Digest:

Sign Up