โ02-07-2017 10:13 AM
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 no idea on how to access an SLDB:// location. The database file must be local on the groundplex or somewhere accessible from the groundplex.
โ06-28-2017 03:25 AM
I tried to implement this, but while validating the account I get the error โPOST http://pa23sl-jccs-ux07672.fsac5.snaplogic.net:8090/api/1/rest/account/validate: Server Errorโ
โ06-28-2017 09:29 AM
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.
โ06-29-2017 04:31 AM
So where should the access file be stored? I tried the below still getting the same error,
โ06-29-2017 12:46 PM
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.