Course Hero Logo

17.Data Provisioning and Cleansing with SAP HANA SDI and SAP HANA SDQ.pdf

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 4 out of 92 pages.

James Hanck, Cheri M allory, Paul M edailleData Provisioningand Cleansing withSAP HANA® SDI andSAP HANA® SDQ® Rheinwerk®PublishingBonn • Boston
W hat You'll LearnGet your data in tip-top shape with SAP HANA smart data integration andSAP HANA smart data quality! Learn to set up data provisioning adaptersto read data from flat files, SAP ECC, Twitter, and more. Utilize flow-graphs and transforms to move, cleanse, and manipulate your data, andsee how SAP HANA's development tools can improve your data quality.1In tro d u ctio n............................................................................................52Primary Functions and Use Cases......................................................82.1Functions of SDI and S D Q............................................................92.2Use Cases.........................................................................................123A rch ite ctu re............................................................................................164Development Tools for SAP H A N A....................................................204.1SAP HANA Studio O v e rv ie w.......................................................214.2SAP W eb IDE..................................................................................235Data Provisioning Adapters...............................................................245.1File A dapters....................................................................................245.2Log Reader A d a p te rs......................................................................315.3SAP HANA A d a p te rs......................................................................355.4Hive A d a p te rs..................................................................................395.5Twitter A d a p te rs.............................................................................445.6SAP ECC A dapters..........................................................................475.7OData Adapters.............................................................................526Flowgraphs and Transform s................................................................586.1Flow graphs.......................................................................................596.2Transforms.......................................................................................777W hat’s N e x t?.........................................................................................924
1In tro d u c tio nSAP released the first version of the SAP HANA database in 2010, a signif-icant shift in focus for a traditional ERP company. Since then, the SAPcommunity has embraced the SAP HANA approach to managing data, asSAP has expanded the SAP HANA database into the SAP HANA databaseplatform. The SAP HANA platform offers more functionality than tradi-tional database systems and has a wealth of functionality and tools, whichgrow with each release. For example, in a recent release, SAP expandedthe number of prepackaged predictive algorithms, improved tools toaccess and process manufacturing machine data, and enhanced text ana-lytics and text mining. Similarly, with each release, SAP adds more andmore data integration functionality.This E-Bite covers native SAP HANA functionality that provide data pro-visioning and data quality capabilities within the SAP HANA databaseplatform. The types of data integration functionality that were once onlyavailable in standalone tools and complicated operating systems scriptsare now native to SAP HANA.Since the early years of data processing, data integration has consisted of1) creating a connection between two sources, 2) setting up security, and3) acknowledging data or message receipt. This process hasn't fundamen-tally changed, though it has become a bit more complex. What haschanged over time is the ease with which developers and system admin-istrators can create and manage data integration. The advent of customtools was a huge leap in productivity and quality, and the SAP HANAdatabase platform approach is at least as innovative and impactful.Within most application projects and implementations, the "data work" ishandled by a team who are experts in whatever toolset is used. You mayhave a team of extract, transform, load (ETL) programmers or data qualitydevelopers. You may have a data migration team or a data quality team.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 92 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
N/A
Tags
Data Management, SAP HANA

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture