Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Jeevan Murkoth (JeevanM)
Intel

Intel
US
JeevanM Member since 2017 5 posts
Intel
Posted: Sep 25, 2018
Last activity: Sep 27, 2018
Posted: 25 Sep 2018 16:01 EDT
Last activity: 27 Sep 2018 4:23 EDT
Closed

Pega PRPC - Access Database

Is it possible to connect and pull data from a Microsoft Access Database . If so , can you please point me to some documentation

Thanks

***Edited by Moderator Marissa to update platform capability tags****

To see attachments, please log in.
Pega Platform
Data Integration

Posted: 7 years ago
Posted: 27 Sep 2018 4:23 EDT
Domenico Giffone (DomenicoGiffone)
PEGA
Senior Principal Software Engineer, 1:1 Runtime
Pegasystems Inc.
IT

Hi @JeevanM1,

As far as feasible in theory (the references below show how-to connect to Access via JDBC) there are so many drawbacks to consider that I strongly advise against proceeding in this direction.
Basically this usage scenario is outside the scope for which the database originally was designed. (multi-user scenarios are not well supported, there are file size limitations, you need to access to the database file).
Also MS Access doesn't fully support ANSI SQL features hence you could be limited to Java activities and some Connect SQL Rules.

https://stackoverflow.com/questions/16626301/jdbc-driver-ms-access-connection
https://stackoverflow.com/questions/37397232/connecting-to-an-access-database-on-tomcat

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice