RiteSync is an Extraction and Synchronization tool for Oracle SaaS Customers. But is that all? No.

RiteSync is an Extraction and Synchronization tool for Oracle SaaS Customers.
  • April 16, 2024
  • Mohammed Nadeem Uddin
  • 0
Published On April 16, 2024
Why is there a huge buzz around RiteSync? Why is there so much traction from Oracle Fusion users across verticals? We recently conducted a webinar to explore and deep dive into this exact question.

The webinar highlighted how RiteSync Bridges the Oracle SaaS with Data Warehouse with an effortless Extraction and Synchronization.

Let us double click on the multiple questions discussed in the webinar! One after another

What is RiteSync?

RiteSync is a tool designed for Oracle SaaS customers, simplifying the task of synchronizing data between Oracle’s cloud services (like Oracle ERP Cloud and Oracle WMS Cloud) and various databases or data warehouses. Its main purpose is to make it easier and more error-proof to transfer data from Oracle SaaS platforms to other systems.

It uses built-in connectors, such as REST JDBC, to facilitate seamless data transfer and reduce the chance of errors. With continuous innovation, RiteSync today can integrate with Oracle WMS cloud, comes with pre-built dashboards, reducing the latency.

Additionally, RiteSync assists customers in using tools like Power BI, Snowflake, and Incorta, enabling them to gain actionable insights from their data without being limited to the more expensive Oracle Analytical Cloud. It allows synchronization of application tables or reports from Oracle SaaS to databases like Oracle, Postgres, MySQL, or MS SQL Server, essentially replicating the data in these databases.

A key feature of RiteSync is its patent around metadata management, ensuring that all Oracle attributes are accurately captured and replicated in the chosen database or data warehouse. It also offers data in a Parquet file format, known for its efficient compression, making it ideal for use with modern BI systems.

In summary, RiteSync provides Oracle SaaS customers with a versatile and efficient tool for data synchronization, supporting a wide range of databases and facilitating the use of advanced analytics platforms.

Who would need RiteSync? What industries and what stage of ERP implementation does one need to be in, to make the most of RiteSync?

RiteSync is primarily used by those looking to synchronize their ERP data with their data warehouse. This includes data warehouses chosen based on strategic decisions, like opting for Snowflake, Incorta, Power BI, or traditional data warehousing solutions, to integrate data from Oracle SaaS. However, beyond this primary use, customers have discovered additional valuable applications of RiteSync.

One such application is for change audits, where RiteSync is employed to monitor and audit changes in specific tables, providing a consolidated view across different applications where Oracle’s reports don’t meet the user’s needs.

RiteSync is an Extraction and Synchronization tool for Oracle SaaS Customers

Another innovative use of RiteSync is as an integration tool. Users leverage it to pass on data transformed through BIP reports into other systems, including legacy systems. This eliminates the need for using Oracle’s OAC, which is more costly. RiteSync presents a cost-effective alternative, significantly reducing expenses compared to OAC and simplifying the integration process to a mere button click without needing specialized knowledge in OAC.

Additionally, RiteSync has been used to support the development of APEX-based applications, particularly useful for reducing licensing costs. It enables the creation of applications outside of SaaS for users only requiring read-only access, thereby avoiding the need for these users to log into SaaS and incur additional licensing fees. These applications can range from reporting tools to operational platforms.

Furthermore, RiteSync has found a niche in scenarios requiring publish and subscribe functionalities in a master data management context. It serves as a more efficient conduit for data distribution among external systems, reducing the reliance on Oracle SaaS’s web services and thereby optimizing system performance and cost.

To conclude, RiteSync extends well beyond its initial purpose of data synchronization, proving to be a versatile tool in change audits, system integration, application development, and data management strategies, offering cost-efficient and simplified solutions for Oracle SaaS customers.

Can we quickly compare RiteSync with Oracle Extraction Toolset?

RiteSync offers a compelling alternative to Oracle’s Business Intelligence Cloud Connector (BICC) for architects familiar with both tools. BICC, while optimized for high volumes and natively provided by Oracle, faces limitations such as not loading data directly into databases and missing critical tables for import, which could be crucial for application table migration. Although BICC includes customization options, these can be cumbersome and resource-intensive to implement.

Many customers who initially used BICC, attracted by its capability for handling large data volumes, have shifted to RiteSync. They found BICC’s maintenance costly and its functionalities, like delivering data only in CSV format and lacking an efficient way to handle anomalies in data (e.g., double quotes in clogged data), not fully meeting their needs. Moreover, BICC does not support WMS Cloud, presenting a significant gap for customers using this service.

RiteSync is an Extraction and Synchronization tool for Oracle SaaS Customers Table

On the other hand, RiteSync is designed to efficiently synchronize data with databases, including support for WMS Cloud, which is particularly relevant given its distinct architecture from other Oracle offerings. RiteSync also enables flexible scheduling, surpassing BICC’s daily scheduling limitation by allowing hourly updates, crucial for real-time data needs like monthly GL balances.

For citizen developers and those requiring streamlined data integration without extensive development, RiteSync proves to be a cost-effective and efficient solution. It simplifies the implementation of data pipelines and integration projects, allowing functional experts to leverage BIP reports and synchronize data across systems with ease.

All in all, RiteSync positions itself as a versatile and user-friendly alternative to BICC, especially for those facing BICC’s limitations or requiring integration with WMS Cloud. With features like flexible scheduling, support for a wide range of databases, and easier maintenance, RiteSync offers significant advantages for organizations looking to optimize their Oracle SaaS data synchronization and integration processes.

Time for some customer stories:

Banking Customer Smoothly Migrates Over 1 billion Records from Oracle HCM to Workday with RiteSync

A banking domain customer decided to transition their HR management system from Oracle HCM to Workday. Despite moving away from Oracle HCM, they required a solution to maintain dual-entry systems temporarily, align their data accurately, and archive over 12 years’ worth of data for historical preservation. Oracle itself recommended using RiteSync for this purpose. RiteSync successfully migrated all their data, including a challenging pay run balances table that contained more than 1 billion records. The migration showcased RiteSync’s high performance, as it efficiently handled and transferred up to 50 million records at a time, far exceeding the initial estimates of 10 to 20 million records. Specifically for this customer, RiteSync customized the data format to meet the requirements of Snowflake, their chosen data warehousing solution, ensuring a seamless and effective migration process.

Enhancing Financial Dashboards with RiteSync for an AMS Customer

An internal AMS customer, after exploring various tools, sought a cost-effective analytical solution for Power BI to enable their CFO’s office to access quick revenue outlooks and income statements. They required their financial data, spread across about 150 tables, to be readily available for analysis. RiteSync addressed this need by efficiently migrating the data to an MS SQL Server hosted on AWS, ensuring minimal latency. This integration allowed for near real-time data usage in their financial dashboards and insights, enhancing decision-making processes.

Streamlining Data Migration for a Pharmaceutical Giant in Egypt

A pharmaceutical company in Egypt partnered with RiteSync to achieve a comprehensive data migration goal. They aimed to identify and synchronize over 4,000 tables daily, ensuring any changes were migrated promptly to their Oracle database. Unlike other customers who used Snowflake or MS SQL Server, this company specifically required integration with Oracle DB to leverage their existing expertise. RiteSync enabled them to not only migrate their vast data efficiently but also to utilize the migrated data for creating reports and developing solutions independently of Oracle SAS. They chose to work with Apex for development, given their familiarity with the platform and the ease of connecting it to Oracle DB, avoiding the need to develop new skills in VPCS. This project is highlighted as a significant success story for RiteSync, demonstrating its flexibility and capability to handle large-scale, incremental data migrations across various database platforms.

Here are some questions that the audience had.
We believe you too, will benefit from these.

RiteSync functions similarly to middleware like OAC but focuses more on directly syncing application tables between source and target systems. It simplifies the data transfer process by allowing the listing of all tables in a single operation, unlike OAC which requires creating different connectors for each table.
Upon establishing a new sync connection, RiteSync automatically creates new tables in the target database corresponding to the source structure but does not create new schemas. Instead, it utilizes the schema associated with the user specified during the connection setup. Additionally, RiteSync can dynamically update tables to include any new columns introduced in source system updates, ensuring the target database structure remains current with the source.
RiteSync does not store data during the transfer process. However, it temporarily transforms data when necessary, such as converting files to the appropriate format for specific target systems (e.g., parquet for Snowflake). For database synchronization, data is transferred directly without intermediate storage, although temporary conversion processes might occur within RiteSync's system.
RiteSync uses columns designed to track updates (e.g., mod_ts in WMS Cloud) for identifying changes and performs incremental loads by pulling only new or updated records. This approach minimizes data transfer volumes and optimizes synchronization efficiency.
RiteSync does not have a predefined data volume limit. However, the initial full load of data might be time-consuming. The system is capable of handling large data volumes, demonstrated by successful transfers of up to 500 million records for a banking customer. The impact on scheduling is primarily related to managing the initial load and subsequent incremental updates based on volume.
For creating adapters, RiteSync uses SAS credentials specific to the ERP system being connected. It leverages both BIP servers and REST APIs for comprehensive data extraction and metadata validation. Users are advised to create a dedicated user account for RiteSync with roles suited for integration tasks, such as integration specialist or BIP admin, to ensure secure and effective data synchronization.

All of this shows how RiteSync is an extraction and synchronization tool but can do so much more for you!

Wanna try it out yourself? Sign-up for our 7-day trial