New to SAP Data Services: Native Support for MongoDB



This is a guest blog by Subha Ramachandran, Vice President, Product Management at SAP Labs. It represents her personal views, thoughts, and opinions. It is not endorsed by SAP nor does it constitute any official communication from SAP.

The bulk of work in any Big Data initiative is in preparation of the data – specifically data integration and ensuring data quality. With native support of MongoDB in the new release of SAP Data Services 4.2 SP04, those tasks just got easier.

Bring in Data that Lives in Various Source Systems

SAP Data Services for MongoDB simplifies the extract transform and load (ETL) of data from the database by preserving the fidelity of JSON structures instead of artificially flattening them, which can result in data redundancies/repetition. Within SAP Data Services, ETL developers can operate on hierarchical structures, perform required transformations, and flatten as needed to fuel analytics use cases. For example, users can load multi-level machine/equipment data stored in MongoDB into SAP HANA, Hadoop, or any other data warehouse on a regular basis (e.g. daily or weekly ) for analytics.

Simplify & Maximize Performance with SAP Data Services

SAP Data Services provides a rich set of native out-of-the-box transformations, with over 80 built-in functions in its library, including native text data processing, data masking, and data quality transformations to standardize, validate, cleanse and enrich data.

MongoDB's dynamic schema allow SAP Data Services to automatically scan collections in parallel to quickly infer the metadata. The software also supports the pushdown of allowed operations to MongoDB and thus maximizes performance. The SAP Data Services 4.2 SP04 release supports both single node and replica set deployments of MongoDB.

In summary, the SAP Data Services 4.2 SP04 release allows you to combine MongoDB’s schema flexibility with a market leading set of data integration and data quality capabilities. This gives developers the power to easily extract, transform, and load MongoDB data as part of any Big Data initiative. SAP Data Services and MongoDB help you deliver a complete and accurate view of your data, allowing you to identify new insights and convert them into business value.

Stay tuned for further details on what’s to come in 2015, including plans for support of MongoDB sharded clusters.

Find out more about SAP Data Services, Data Services 4.2SP 04 native support of MongoDB and why SAP Data Services is recognized as a Leader in the Magic Quadrants for both Data Integration and Data Quality tools.