I have open a JIRA ticket requesting this as a feature. I have tried ucanaccess before, and tried adding it to different lib folders and setup HOP_SHARE_JDBC_FOLDER in the hop-gui.sh, however, I always get a no suitable driver found error.
On Mon, Aug 8, 2022 at 10:42 PM Gert Wieland <[email protected]> wrote: > Hi Hans, > > Thank you very much for your quick reply, this looks very promising. > > I'm (very) new to Hop, and I need to do some more homework first figuring > out how to add the plugin (the instructions > <https://hop.apache.org/manual/latest/database/databases.html> look > straight forward though :) ) > > But yes, I think it would be great if if we (well, you ;) ) could add an > MS Access transform by default. > > Hong-Yee, will you open a JIRA ticket? (Here's the link. > <https://issues.apache.org/jira/browse/HOP-3962?jql=project%20%3D%20%22Apache%20Hop%22%20and%20fixVersion%20%3D%202.0.0> > ) > > Thanks again, > > Gert > > On 2022-08-08 2:28 a.m., Hans Van Akelyen wrote: > > Hi, > > Thank you for reaching out, we can take a look at adding a transform to > read data from access so feel free to create a jira ticket. > In the meantime there is another solution, there is a JDBC driver > available to read data from access files you can find it here [1]. > > You can use a generic connection and the instructions from the website and > you should be able to read and even write to Access database files. > > Kr, > Hans > > [1] http://ucanaccess.sourceforge.net/ > <http://atpscan.global.hornetsecurity.com/index.php?atp_str=LTAuoQvAWs9NVle0lMe6dcDQ87U5rWQeqAQjeEN99m7YFNskPuI7eD0_IdFgVj0aCfjiJKskBA-LWY77Wl9ZzlHDEa6uUNIt0dBFw-oLyyiOc_Usc515BmCADGbCy3ssmaYknnlrnqxgp7bepNs4fdrMDtoMUVwch6wx4CQ52d9-ElMVCVEHRjQIejh8elb1c4goieuaKPwxWtR6jZCu5AZ_kx0GA-CZ6kijU8EIj5TFo1GeuCsoNirXaGGIyMHv_-WhQKxGM4J74-RB-cDq4k1zSoNK9RISwC01OGxd3wyzUlj9zGhcTtledkhHUPsPtLO4FDivLJiHspbEkiM6OiOQmHQ5aqtkiCL1nJIjOjojP2r_lOX3_1EU4wa_84q0wA> > > On Mon, 8 Aug 2022 at 05:42, Gert Wieland <[email protected]> > <[email protected]> wrote: > >> I would like to second Hong-Yee's request. >> >> In my work environment, there are (unfortunately still) many Access >> databases in use, and I need to pull data frequently (on a schedule). >> >> I found the Excel connector, but Access doesn't seem to be available. >> >> Much appreciated, >> >> Gert >> >> On 2022/08/08 00:34:27 Hong-Yee Seah wrote: >> > Hi, >> > >> > I just recently switched over from Kettle to Hop. One of the things I >> need >> > to do is to import Microsoft access files. >> > >> > I can't seem to find this in the current hop and there doesn't seem to >> be >> > much information about how to get around this. >> > >> > Thank you >> > >> >
