Snaplogic connect to MS-Access MDB database
You can use the JDBC snap to access the MS-Access MDB database by using 3rd party JDBC driver. The example here is using the JDBC driver from UCanAccess.
Note that the JDBC driver will have n...
Forum Discussion
If you are using the UcanAccessDriver, that JDBC URL doesn’t look correct since it won’t know the SLDB enviroment. That should be close to what the original stated but pointing to the file location on the node.
So where should the access file be stored? I tried the below still getting the same error,
The accdb file must be somewhere that can be accessed from the groundplex execution (not within the SnapLogic Database). In your example, it’s looking for a file in the folder /tmp.
Hope that helps.
Eric B.thank you, it solved the issue.
Our groundplex nodes are on Linux. Does the Access DB file have to reside on a file system that’s mounted on the groundplex node? Or could it reside on a Windows network share that’s network accessible from the groundplex node?
