Introduction into existing BICC Automation BI Cloud Connector offers a broad bandwidth of options to automate the extraction of data. In various other blogs...
Introduction into existing BICC Automation BI Cloud Connector offers a broad bandwidth of options to automate the extraction of data. In various other blogs we’ve shared information how to download extraction files, log information or to delete extracts. Those scripts can be scheduled on the client side via the tools of choice. The built-in capabilities in BICC provide more and more automation as the product evolves. Scheduling frequent extraction runs was a feature that...
Introduction into existing BICC Automation BI Cloud Connector offers a broad bandwidth of options to automate the extraction of data. In various other blogs we’ve shared information how to download...
Introduction EXTRACT JSON files Since end of 2018 SaaS Cloud provides a new feature to track the status of a data extraction run in BI Cloud Connector (BICC)....
Introduction EXTRACT JSON files Since end of 2018 SaaS Cloud provides a new feature to track the status of a data extraction run in BI Cloud Connector (BICC). Every single run to extract data or keys will produce a JSON file with log information that can be used for monitoring purposes. The naming style per file looks like shown below: EXTRACT_STATUS_DATA_SCHEDULE_<Schedule ID>_REQUEST_<Request ID>.JSON BICC Extract log file for VO data if been chosen in run definition...
Introduction EXTRACT JSON files Since end of 2018 SaaS Cloud provides a new feature to track the status of a data extraction run in BI Cloud Connector (BICC). Every single run to extract data or keys...
Introduction Oracle's Fusion SaaS applications cloud is built on a single data model that connects end-to-end business processes across Human Capital Management...
Introduction Oracle's Fusion SaaS applications cloud is built on a single data model that connects end-to-end business processes across Human Capital Management (HCM), Enterprise Resource Planning (ERP), Customer Experience (CX) and Supply Chain Management (SCM) functionalities. While Oracle is providing a common extension and configuration framework across all Fusion SaaS applications, every pillar has also provided additional purpose-built tools and utilities that supports...
Introduction Oracle's Fusion SaaS applications cloud is built on a single data model that connects end-to-end business processes across Human Capital Management (HCM), Enterprise Resource...
table, tr, th, td { border: 1px solid blue; border-right: 1px solid blue; border-left: 1px solid blue; border-collapse: collapse; border-spacing: 0; }...
table, tr, th, td { border: 1px solid blue; border-right: 1px solid blue; border-left: 1px solid blue; border-collapse: collapse; border-spacing: 0; } th:not(:last-child), tr:not(:last-child), td:not(:last-child) { border-right: 1px solid blue; } Introduction In continuation to my previous blog on Best Practices to model parties in Oracle Fusion Cloud, I will discuss common use cases, design considerations, and options around managing hierarchies (customer, supplier, partner)...
table, tr, th, td { border: 1px solid blue; border-right: 1px solid blue; border-left: 1px solid blue; border-collapse: collapse; border-spacing: 0; } th:not(:last-child),...
Introduction Three major entities of every business/enterprise in most industries, are Customers, Suppliers and Products. In reality, customer, supplier and...
Introduction Three major entities of every business/enterprise in most industries, are Customers, Suppliers and Products. In reality, customer, supplier and product data is required to be stored in all applications and each application might have different data model and data structure requirements. If customer data and product data are not consistently stored in all applications across enterprise, this will result in supply chain inefficiencies, misguided campaigns, and...
Introduction Three major entities of every business/enterprise in most industries, are Customers, Suppliers and Products. In reality, customer, supplier and product data is required to be stored in...
For other A-Team articles by Richard, click here Introduction In the recent Oracle Analytics Cloud release, exciting new SaaS data replication functionality was...
For other A-Team articles by Richard, click here Introduction In the recent Oracle Analytics Cloud release, exciting new SaaS data replication functionality was added. This allows Oracle Analytics Cloud (OAC and OAAC), to replicate data, on a schedule, from a number of Oracle's SaaS offerings. For many use cases, this will mean that a separate extract and load processes, is no longer required. In this initial release, the sources that can be replicated are: - Oracle Fusion...
For other A-Team articles by Richard, click here Introduction In the recent Oracle Analytics Cloud release, exciting new SaaS data replication functionality was added. This allows Oracle Analytics...
For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work...
For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work directly against. The recommended approach to extract data for most use cases, is through the BI Cloud Connector tool. This pulls data from 'View Objects' in the Business Intelligence layer of Fusion SaaS. Other tools can also extract from these view objects. BI Apps customers have pre-created ODI mappings, that take the...
For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work directly against. The recommended approach to...
For other A-Team articles by Richard, click here Introduction The Oracle Data Sync tool provides the ability to extract from both on-premise, and cloud data...
For other A-Team articles by Richard, click here Introduction The Oracle Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into Oracle Analytics Cloud Service (OAC), Oracle Autonomous Analytics Cloud Service (OAAC), and other oracle relational databases, or into Essbase. In the most recent 2.5 release, Data Sync added the ability to pull data directly from Fusion SaaS view objects. The same view objects that...
For other A-Team articles by Richard, click here Introduction The Oracle Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into Oracle...
Introduction With the increasing adoption of Oracle Cloud among customers, one of the key challenges the customers' security teams face is managing network...
Introduction With the increasing adoption of Oracle Cloud among customers, one of the key challenges the customers' security teams face is managing network access for the newly purchased SaaS services. The security teams are firm on enforcing the rules and regulations around IT security that are already in place, and they expect their new SaaS subscriptions to adhere to these rules as well. One such rule is controlled network access, and IP-Address Whitelisting is one...
Introduction With the increasing adoption of Oracle Cloud among customers, one of the key challenges the customers' security teams face is managing network access for the newly purchased...
