This article is intended for database admins, consultants, customers & partners to enable the File Adapter & configure sample data from your local file path to load into your SDI Project
In this blog, we are consuming the data provided by customer (extract & dump regularly) in the local path where DP Agent is installed. Few customers may not connect to their local database (source) due to privacy & security.
Register the agent
You will use the command-line tool to configure the data provisioning agent to connect to your SAP HANA instance using a secure connection.
Open a command line or terminal with administration rights. For Windows, search for cmd and use the context menu to choose Run as Administrator.
Save the configuration file in the same directory.
Create a Remote Source
Go back to the Database Explorer. You will see the adapter under Catalog -> Agents You should see the agent you registered.
Right-click on Remote Sources. Choose Add Remote Source Choose FileAdapter Call the source LocalFile. The Source location should automatically choose the agent you registered on step 4. Set the path to the workspace directory in which you downloaded the CSV file
Scroll down to the credentials and choose Technical User as the credentials mode and enter the access token in the AccessToken field. If you used the example token before, enter FileToken. Click Create
Check the remote objects to make sure configuration has been successful and to complete the validation below.
Create a Virtual Table
you will have to create a Virtual table by connecting to your remote source to load the data into table.
CREATE VIRTUAL TABLE ext.VT_testing_yoga AT "testing_yoga"."<NULL>"."<NULL>"."salarydata";
you can preview your data if that's coming from local file References