Access MDB file using SFTP

[Former Member]

Hi All,

I need to access an mdb file using SFTP and then save it to the application server and then QUERY the data from the MDB file using the JDBC adapter.

Please note that the file needs to be read using SFTP and is it possible in any means to avoid the second step?

Kindly let me know the feasible way of doing this.

Thanks & Regards,

Sai

[Former Member]

Hello!

You can take the absolute path and perform the queries using the mapping program within the sFTP scenario, without using the JDBC adapter.

BR,

Lucas

[Former Member]

Hi,

Thank you,, can you please elaborate on the mapping program as where to assign it and as how to determine the absolute path.

Thanks and regards,

Sai