How to connect to Access Database?

[bella21]

How can you connect to an Access DB? I can bring one in via local upload and through a data source. However, once it is in, Paxata does not let me select the specific tables/queries I want from that Access database. Is there a Character Encoding selection that would allow for this?

[Akshay1]

Hello @bella21, We currently do not have a connector that supports imports/exports to Access DB. For now, you will have to export the data from access and then import into Paxata or to use a datasource that is currently supported by Paxata.

[sudheerkumar1 · Accepted solution]

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:

1. Copy the Access database to a known location on the frontend core server (JDBC driver need to access it locally)
2. Download and deploy the UCanAccess JDBC driver (http://ucanaccess.sourceforge.net/site.html). Teja should be able to help you with this.
3. 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 Sudheer Kumar