You can translate the question and the replies:

CSV FROM A DIFFERENT SERVER

Hello, I wonder if it's possible to connect to a csv data source that is on a different server from the one that has Denodo on it, without using an FTP connection. It is not possible to create a data source of a csv that is on a virtual machine? Thanks, Maria
user
13-02-2024 09:02:26 -0500
code

1 Answer

Hi, It's my understanding that you want to create a data source from a .csv file that is located in a different machine than the one running Denodo VDP. Remote options like FTP, S3, etc… are beyond what you need. As explained in the Virtual DataPort Administration Guide, section [Delimited File Sources](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources), the option "local" in the Data route expects a local file in the VDP server. One option to make a remote directory/file local is to mount it under the machine where VDP runs. For that you might have different options depending on the Operating System, for example [here](https://askubuntu.com/questions/412477/mount-remote-directory-using-ssh) using SSH in Linux. Similarly, [this Denodo Knowledge Base](https://community.denodo.com/kb/en/view/document/Accessing%20network%20drives%20from%20Denodo%20Virtual%20DataPort) explains how to access files in network drives from Denodo, Here you mount a network drive location to make it look like a local unit. Another option to consider might be using the Data route option "HTTP Client", but that also requires a web server running on the remote machine, with access to the files location, so you could access through HTTP. In the end it is similar to setting up an FTP server in the same machine. In summary, you need to mount the remote directory and make it local, or use some of the other remote options available. Hope this helps.
Denodo Team
14-02-2024 08:05:15 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here