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

#MS Access Hi all, we need to get data from a microsoft access database, which is NOT based on MS SQL Server, but has its data within the access file. Has anyone experience in connecting the java world to ODBC like this? What would be the best way to do this from appian? Is there a way to create a datasource in Websphere, which we could use in Appian? TIA!...

OriginalPostID-114253

OriginalPostID-114253

  Discussion posts and replies are publicly visible

Parents
  • 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.
Reply
  • 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.
Children
No Data