Thank you, @Akshay.
Hi @bella21 ,
In the past (almost two years back) I did use http://ucanaccess.sourceforge.net/site.html
(Pure Access JDBC driver) to fetch data from Access database. Paxata now supports generic JDBC driver meaning we can give it a try in your TEST environment and see if it helps.
Here are the steps:
- Copy the Access database to a known location on the frontend core server (JDBC driver need to access it locally)
- Download and deploy the UCanAccess JDBC driver (http://ucanaccess.sourceforge.net/site.html). Teja should be able to help you with this.
- Define a JDBC Connector using this driver and try to query the desired tables or views.
We would need Teja or someone DPS to deploy the JDBC drivers to core servers on TEST / PROD. Please let me know I can set up a session to go through this exercise.
With Best Regards