Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
6 subscribers
Views
3001 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
#MS Access Hi all, we need to get data from a microsoft access database, which i
moritzw
over 10 years ago
#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
0
Eduardo Fuentes
Appian Employee
over 10 years ago
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Eduardo Fuentes
Appian Employee
over 10 years ago
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data