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.