You can translate the question and the replies:

excel data source

Is there any way to create a excel data source of the file stored in the local system of the user not in the local system of virtual dataport server? or is there any way to move the file from local system to local system of virtual dataport server?
user
17-06-2022 04:29:15 -0400

1 Answer

Hello, When using Excel file as a datasource, if I’m using **Local** as the data route, then I have to make sure the file is located in the server, where the VDP server is running and not in any other client machine. In case I want to use a file in some other location, I would try to use any other alternative data route, such as HTTP or FTP/SFTP or HDFS wherever possible. The manuals at [Path Types in Virtual DataPort — Virtual DataPort Administration Guide](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/path_types_in_virtual_dataport) and its subdirectories on the different path types would be helpful in exploring the options. I would also refer to the KB article on using [network drives](https://community.denodo.com/kb/en/view/document/Accessing%20network%20drives%20from%20Denodo%20Virtual%20DataPort). This could come handy in case of shared excel files. Hope this helps.
Denodo Team
20-06-2022 07:52:05 -0400
You must sign in to add an answer. If you do not have an account, you can register here