Monday, 22 October 2018

Creating Virtual Table in WEB IDE for Flat file present in Remote Source Part 2

In Previous Part – we have understood how to configure DP Agent and enable a connection from HANA to Flat File Reomote source.

Let’s create a virtual table for the object “FILECONTENTTEXT” present in the Remote Source ,FlatFile.

Create following roles

SAP HANA Tutorial and Material, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

2. Create a User Self Service through which the above roles will be assigned to the Container Object owner and Application User

Login to XS Command Line Interface and execute following command to create User Self Service

SAP HANA Tutorial and Material, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

3. Update the mta.yaml file.

SAP HANA Tutorial and Material, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

4. Select the src folder and build it.

5. Create a hdbgrants file

SAP HANA Tutorial and Material, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

6. Select the src folder and build it.

7. Create a Virtual Table named as vtable

Right click on src-> New -> virtual table

SAP HANA Tutorial and Material, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

8. Create a Virtualtable config file

Right click on src-> New -> File

Give name as vtable.hdbvirtualtableconfig

SAP HANA Tutorial and Material, SAP HANA Guides, SAP HANA Learning, SAP HANA Certifications

9. Select the src folder and build it.

So , now we have built the virtual table.

4 comments:

  1. Home buying mistakes costs the investors more. Thanks for sharing an informative post. This helps me to rectify the mistakes when buying a home.
    New apartments in OMR
    Apartments in OMR
    Apartments for sale in Chennai

    ReplyDelete
  2. There is lots of Post about SAP But your Post is So Unique and Knowledgeable e So Thanks for Sharing a nice Information and Picking the fitting vocation can be hard; anyway SAP Course having a depicted calling bearing will assist you with getting a difficult and well-paying employment
    SAP Training in Delhi
    SAP Training in Noida
    SAP Training in Gurgaon

    ReplyDelete
  3. Multiply your career growth. SAP Training with 12+ Years Experienced Trainers | 100% Placement
    SAP Course in Delhi
    SAP Course in Noida
    SAP Course in Gurgaon

    ReplyDelete