You can translate the question and the replies:

Connecting to a remote Excel file using Denodo Express

Hi, I need some help trying to connect to a remote Excel file as a data source. I have two servers (A & B), server A has Denodo Express installed on it, how, do I go about connecting to a Excel file on Server B? Using the FTP or HTTP options does not seem to help, unless I am getting the configurations wrong for FTP? Or will I need to use a specific driver in this case? All help is appreciated. Many Thanks
user
18-05-2021 08:56:49 -0400

6 Answers

Hi, First, I would try to determine where exactly the Excel data source is located on Server B, and furthermore, how it is being shared to Server A (via HTTP or FTP). I was able to connect to an Excel data source by following [this documentation](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/excel_sources/excel_sources). I suggest making sure that [the path is correct for HTTP clients](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/http_path#http-path), and that both [the path and credentials are correct for FTP servers](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/ftp_sftp_ftps_path). If you’re only interested in reading data from the Excel file, you do not need a specific driver, and an HTTP or FTP connection is fine. Hope this helps!
Denodo Team
18-05-2021 15:47:30 -0400
Thanks. I am thinking to create Creating a symbolic link to the network location and then use that in the excel connection.
user
08-06-2021 10:22:43 -0400
I created the symbolic link and that is visible as a file and not a folder. Can you please explain if something is wrong here? Also i need to use double quotes around the remote network folder. mklink /d c:\Tempsymboliclink \\server\elc\Shared\Projects\Active\Parameter Secondly, I created a map drive on the server and thats also not visible when in excel source. Why is that? Any help would be appreciated!! Thanks!
user
08-06-2021 20:08:33 -0400
Hi Team, Can anyone answer the above question on symbolic link? Thanks!!!
user
09-06-2021 18:46:49 -0400
> Hi Team, > Can anyone answer the above question on symbolic link? > > Thanks!!! It might have been better for you to create a new question thread instead of hijacking another one, as your question is not relevant to the original one.
user
10-06-2021 04:26:53 -0400
> Hi Team, > Can anyone answer the above question on symbolic link? > > Thanks!!! Hi, I would refer to the documentation on [accessing network drives from Denodo VDP](https://community.denodo.com/kb/en/view/document/Accessing%20network%20drives%20from%20Denodo%20Virtual%20DataPort) to successfully create your symbolic link. If you need more assistance, it might be more suitable to create your own Q&A thread on this issue. Hope this helps!
Denodo Team
10-06-2021 17:05:37 -0400
You must sign in to add an answer. If you do not have an account, you can register here