Skip to Content

What is the difference between Data Service and Modeler in HANA Studio?

I know that Data Service is more about connecting to the social networks to extract, transform and load the data beside to this, it performs Text Analysis ...etc ...but after this those data will be saved on HANA In-Memory ...but why we need to work with SAP HANA Modeler, the data are already processed by Data Service?? .... i need this explanation somehow because I'm working on Sentiment Analysis using SAP HANA Sentiment Intelligence RDS.

thanks alot

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on May 07, 2013 at 09:00 PM

    Hi Mirella,

    Data Services (DS) is an ETL (Extraction, Transformation and Loading) Tool, whereas the Modeler is the admin and Modeling tool. Modeler is used to create objects which can be used to Analyze the data stored in HANA.

    Regarding Sentiment Analysis, you are right that you can extract the data from Social media networks using the DS with Map / Reduce framework like Hadoop and store it in HANA. While loading it to HANA, you can "process" the data so that it is cleansed and validated before getting stored.

    What modeler helps you with, is to provide right structures so that the data can be Analyzed and reported properly. The structures provide efficient access patterns to the data. So you need the Modeler to access the stored data in HANA.

    Hope this helps.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 07, 2013 at 09:07 PM

    In addition to above points:

    BODS 4.1 is required to access HADOOP as a data source.

    The HANA modeller, can access only SLT and flat files as data source to control inbound flow of data into SAP HANA. If you need to pull data from other external databases or BW or ECC , you will need to use BODS to configure an ETL ( extract transform and load) into HANA.

    Hope this helps!



    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 13, 2013 at 07:27 AM

    Mirella ,

    SAP has integrated HANA with Hadoop, enabling customers to move data between Hive and Hadoop's Distributed File System and SAP HANA or SAP Sybase IQ server.

    Configuration Steps...

    Few Useful URL below.

    HANA Hadoop integration.

    SAP HANA and hadoop integration scenario.

    Soon I will be publishing my blogs on SAP HANA Hadoop integration.

    Hope it helps ,



    Message was edited by: Mahesh Kumar CV

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.