OneCloud empowers business users to accelerate the use of their systems & data in support of timely analysis and well-informed decision making. With OneCloud Integration Studio, business users can easily build powerful integration. Now, with the introduction of OneCloud Data Prep, business users will also have access to an easy, intuitive, and interactive grid interface to harmonize data between systems.
The Connected Enterprise
To build a truly Connected Enterprise, we need to look beyond system integration and automation. While these are important components of a Connected Enterprise, accurate and reliable data are key when it comes to making the right business decisions. In the best of circumstances, managing your data to ensure accuracy and reliability is often a heavy lift with many pitfalls. The process typically relies on a patchwork of manual processes, custom code, and distributed IT resources. This scenario is not ideal and lacks flexibility, maintainablity, and auditabity required by the business to have accurate, timely, and trusted information.
Change is Constant
The one constant in life is change and this is particularly true in business. To support better planning and decision making, granular and on-demand data is of the highest importance. Change, however, doesn't only happen on the outside. In the ever-changing technology landscape, existing and new enterprise systems need to interoperate, processes need to be agile, and data flowing through these systems needs to be accurate and harmonized. As the volume of data continues to grow, we need to rethink our approach to integration and data quality and build a truly Connected Enterprise.
“Data is the single most important component of a Connected Enterprise. OneCloud Integration Studio & OneCloud Data Prep are foundational to delivering timely, accurate, and reliable data that empowers customers to make better business decisions.”
©2020 OneCloud, Inc | www.onecloud.io
Driving a Connected Enterprise with OneCloud
Harmonize your Data with OneCloud Data Prep
Technical transformation, the process of modifying data layouts, is supported by ODP through a form based wizard.
Operations that can be managed and owned by a business user include row and column modification, filtering capabilities, and data aggregation supported by Excel-based functions that provide column netting and conditional aggregation.
OneCloud Integration Studio (OIS)
Connected systems are the first step to accelerate a Connected Enterprise. Good integration helps to drastically shorten timelines and allows companies to embrace the best in class applications. OneCloud Integration Studio has an architecture that allows on-premises and cloud applications to interoperate seamlessly. With a range of application-specific connectors known as BizApps, OIS also allows companies to easily bridge disparate systems, integrate data flows and automate common application processes without writing code.
OneCloud Data Prep (ODP)
Accordingly, to address common data quality challenges, OneCloud Data Prep exposes a suite of comprehensive and powerful features to cleanse, transform, and map data ensuring cross dimensional relationship validation. Data Prep ensures that inconsistencies caused by varying data definitions are harmonized into a single reporting standard, and provides visibility into the data transformation process.
While OIS already has some built-in transformation capabilities, OneCloud Data Prep delivers extensive transformation capabilities through an intuitive and interactive user Interface. This allows the constituent of users that work with this type of data everyday - the business users - to easily manage data transformation. Users of OneCloud Data Prep can preview transformations as they are being applied. This streamlines the process of data preparation by making it less iterative. Comprehensive version history is provided to ensure that all changes to transformation rules can be audited, standardized, and shared. This not only reduces the cost of data management and compliance, it also increases the confidence in the data and allows functional business areas to focus on what matters most - making better decisions based on higher data quality.
Data quality management can be broken down into three primary pillars: technical transformation, functional transformation, and control. Let's explore how OneCloud Data Prep supports each.
Anaplan Use Case Examples
Functional transformation, or mapping, provides the business users the ability to create and maintain maps in an easy to use grid layout. ODP Mapping Rules can be created and maintained by functional business users to harmonize data sourced from virtually any system. Multiple mapping rules can be combined as a Mapping Rule Group and can be applied in any order necessary.
Mapping Rules support exact matches, ranges, and pattern-based types. For maximum flexibility, conditions can be added to evaluate multiple elements in a data set so transformation only occurs when one or more rules are satisfied.
Mapping Rule Groups extend this flexibility by bundling rules into groups that can be time-bound and applied to certain business events such as new accounting treatments, mergers, and acquisitions (M&A), or restructurings. Additionally, mapping rules groups can be shared across multiple business units to ensure systematic data consistency and reliability.
OneCloud Data Prep incorporates a granular security model to manage access, edit, and view setting. This helps safeguard sensitive mapping rules and ensure confidentiality of key information or planned events. For an added layer of control and to allow for off-line creation for mapping rules, OneCloud Data Prep natively supports importing and exporting from a CSV template. This ability helps streamline the creation and bulk maintenance of mapping rules and provides an additional control point of planned business activity.
To support audit, control, and compliance, OneCloud Data Prep also provides full tracking of any transformation and mapping rule changes. This provides the required insight to streamline external auditor requests and the confidence to understand the lineage of changes over time and restore any component as needed with visibility into version history.
tel: +1 212 749 2220
Technical data subject to modification and delivery subject to availability. Any liability that the data and illustrations are complete, actual or correct is excluded. Designations may be trademarks and/or copyrights of the respective company, the use of which by third parties for their own purposes may infringe the rights of such owner.
Confidence in the Data
OneCloud provides the enterprise with powerful integration through OneCloud Integration Studio. Now, with the introduction of OneCloud Data Prep, business users will also have access to an easy, intuitive, and interactive grid interface to harmonize data between systems. Data Prep ensures that inconsistencies caused by varying data definitions are harmonized into a single reporting standard, and provides visibility into the data transformation process. This not only reduces the cost of data management and compliance, it also increases the confidence in the data and allows you to build a truly Connected Enterprise.
To learn more, please do not hesitate to contact us!
Stay up to date