#MS Access Hi all, we need to get data from a microsoft access database, which i

From the Appian's perpective the only fully supported databases are listed here forum.appian.com/.../System_Requirements Even if your application server supports data sources of another type you will need to fully test the integration since the product is certified only for those in the list; it doesn't mean it won't work though but since Appian is not certified to work with them the product cannot guarantee all the functionality will work.

That statement may not be applicable for your specific scenario though since there's no JDBC driver for MS Access. Sun provides a JDBC-ODBC bridge un.jdbc.odbc.JdbcOdbcDrive which you could easily configure in JBoss, whether there's something similar compatible with WAS or not, that's something that you better ask to WAS Support or on a WAS Forum.

For WAS you may be able to find a third party JDBC-ODBC bridge, but it would be better if you research more on these options directly on the Web or with WAS Support.

Based on a quick online research I don't think WAS will support MS Access unless you find a third party JDBC-ODBC bridge for WAS.

OK. Thanks for the information. So I guess the best way would be to write a plugin that uses the JDBC-ODBC bridge or find some other way outside of Appian?! I guess no one had to do this before.

I have to admit it's an unusual requirement to integrate with a pure access db in a production environment with many users. Unfortunately we have to cope with it somehow.

If you have a SQL Server database you can add the Access database as a Linked database via native ODBC. You should then be able to read data using traditional Appian methods.

Maybe this is an option

www.easysoft.com/.../jdbc-odbc.html

I have not used this before and don't know if records will work with this. But it think SQL statements might work.