Oracle Cloud ERP offers several built-in tools for reporting. While native reporting tools like Oracle Transactional Business Intelligence (OTBI) and Oracle BI Publisher are well-suited for specific types of operational reporting, they do have limitations when it comes to performing complex and enterprise-wide reporting. It is therefore crucial to complement the Oracle Cloud ERP application […]
Posts Tagged ‘data warehouse’
Seamless Integration of Oracle Fusion Apps Data with OAC Data Replication
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, […]
Meet Perficient’s Chief Strategists: Bill Busch
Thrilling our clients with innovation and impact – it’s not just rhetoric. This belief is instrumental for our clients’ success. In 2018 we introduced our Chief Strategists, who provide vision and leadership to help our clients remain competitive. Get to know each of our strategists as they share their unique insights on their areas of expertise. […]
Data Strategy at Strata Data Conf New York
It’s no secret that data is a massive asset when it comes to making better business decisions. But gaining the valuable insights required to make those decisions requires quality data that you can trust. And to accomplish this you need a data strategy. Without understanding your business objectives, identifying use cases, knowing how your users […]
Top Considerations for Moving Your Data Warehouse to the Cloud
The blog “5 Ways Your Data Warehouse Is Better In the Cloud” outlined the advantages of running your data warehouse in the cloud. In this blog, we look at the high-level considerations for migrating your data warehouse to the cloud. Building the Business Case for Migrating Your Data Warehouse Many companies facing expensive on-premises product […]
5 Ways Your Data Warehouse Is Better In the Cloud
According to RightScale’s eighth annual survey, “Cloud Computing Trends: 2019 State of the Cloud Survey”, “A significant number of public cloud users are now leveraging services beyond just the basic compute, storage, and network services.” The survey says relational database services is the most popular extended cloud service and “data warehouse moved up significantly to […]
EDW in the Cloud TCO
In 2016, when I did my first in-depth comparison, the resulting TCOs were usually very close. Usually, the OpEx was slightly higher for the cloud TCO versus the on-prem TCO required substantial capital investment. However, our most recent estimate was eye-opening to our client. We were assessing a green-field implementation for a Data Warehouse at […]
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 […]
Healthcare Information Integration Challenges and Solutions
Healthcare IT is ever-changing and Perficient is on the forefront of this change, guiding the industry and those we serve toward a brighter future. We partner with healthcare companies to help people live their lives to their fullest potential today, using best practices and cost saving technologies and processes. As we look to the future […]
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 […]
Why CU Anschutz Medical Campus Migrated to Google Cloud
Our healthcare team has been working with the University of Colorado over the past couple of years to overcome critical data challenges in healthcare… and the results are exciting. In this blog post, I’ll share how the academic medical center was able to improve security, reduce maintenance, and increase efficiency in support of the university’s […]