Thursday, 28 May 2020

Excel file as a remote source

Open config tool from dpagent server. Connect to the corresponding HANA server. 
Click on the excel adapter under Adapters and click on Register adapter. 
 
 
 
In the configtool, click on configure à preferences. 
Expand adapters and click on Excel adapter. Enter access token. Same like setting password.  
 
Now open web ide using the the below url 
 
Click on catalog. Expand provisioning à remote sources 

 

Right click on remote sources à new remote source 
Enter remote source name like “EXCEL”, select adapter name as “Exceladapter”.  
Put file system folder name as “share” (similar to what you have created under /usr/sap/dataprovagent/excel directory. 
Under table select “file row as header” as True. 
Under user token, enter the same token you have set in configtool. 
Click on save. 

 
Now the remote source will show up. 
 
Right click on the excel file entry “DP Agent” and click on New virtual table. 
Click OK to create a virtual table from the excel file as remote source. 
 
Now in studio, expand tables under the schema where the virtual table has been created and click on data preview to display the data.