Data Sync

Solution

DataQuarry® delivers high-performance data replication of Oracle SaaS data sets out of the box without the need for any technical development or import routines. It provides a third-normal-form data repository by subject area in a customer-managed Oracle Database either running on-premise or in the Oracle Cloud.

Strategy

Customers migrating to Oracle SaaS Applications will need to design a strategy for accessing data in the Cloud whether that is for enriching reporting, integration or application extension. Oracle SaaS Applications have a number of solutions to do this ranging from tools such as HCM Extract in Oracle Human Capital Management, Business Intelligence Cloud Connector, API’s and ATOM feeds. In all cases, these tools require in-depth technical know-how as well as the necessary routines to import the data to the required target.

One Solution

Through a single solution, customers no longer have to invest in developing bespoke solutions to perform data extract from Oracle SaaS. DataQuarry offers a centralised solution for extraction and ingest reducing the need for multiple point-solutions.

Data Sets

Subject Areas

DataQuarry synchronises key data sets by subject area in 3rd-normalform. Data coverage is provided across the most commonly used data sets and additional entities are continually added to future releases or on customer request.

Audit

History tables track day-to-day data movements allowing customers to track changes over any given period to assist with audit or changes-only integrations.

Performance

DataQuarry uses a lightweight and highly efficient extract and ingest process with minimal impact on Oracle SaaS. The solution protects Oracle SaaS instances by moving high-resource activities away from the SaaS ecosystem

Usage

Integration

With access to Oracle SaaS data in 3rd-Normal-Form customers can empower technical teams to build integrations without the need for individual point-solutions that interrogate the Oracle Cloud Applications directly thus protecting the SaaS ecosystem from high-resource activities.

Web Services

Customers can leverage DataQuarry as the data provider for custom web services empowering internal systems to gain rapid access to cloud data sets.

Reporting

Since the target Oracle instance is customer-managed, customers can hold 3rd party data alongside the Oracle SaaS data sets to provide enhanced reporting.

Application Extensions

Customers building applications or SaaS extensions can use DataQuarry to supply SaaS data alongside customer-defined data allowing for rich data-input and validation.