Hi Hans,
I tried to configure the generic connector for Access, but I wasn't able
to figure it out.
Here's what worked:
- I can connect via command line, using the console.bat script.
- I can connect via DBeaver (which uses the same UCanAccess driver)
Here's where I'm at:
- I set the environment variable HOP_SHARED_JDBC_FOLDER, pointing it to
a local folder C:\.....\jdbc
- I set the "Driver class" to net.ucanaccess.jdbc.UcanaccessDriver
- I tried various combinations of "throwing in" the numerous jar drivers
(all in the same folder, or following the same folder structure as the
zip file etc.), but to no avail. I closed Hop and reopened it after
every change, but no success.
Also, I don't even know where to put the database name. My hunch is that
it needs to go into the "Manual connection URL", and it likely looks
something like this: jdbc:ucanaccess://{file} (I found this in DBeaver).
But at this point, it's just too much guesswork.
Would you be able to put me on the right track how to proceed? In
return, I could gladly write up some documentation (in English, German,
even Spanish).
Thanks a bunch,
Gert
On 2022-08-08 10:40 a.m., Gert Wieland 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]> 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
>
