External data sources integration using JDBC

I see lot of discussions around integrating external data sources without replication. I came across such a requirement and

there is a third party JDBC driver for connecting to external system. I can create few meta tables for working on the external system

data by business entity. Driver supports SQL like syntax for CRUD. It is ANSI-92 compliant. Are there any limitation for Cloud Vs non

cloud to register a connection and work with external system data? If I am working on a external system document would I have to

import first in to Appian? Thanks for any support.

  Discussion posts and replies are publicly visible

Parents Reply Children
  • I identified a JDBC driver that can support share point integration. I did doubt that cloud customers may not be permitted for additional unsupported jdbc sources. I am more interested in learning the possibility for the following given situation. Let us consider on premise situation. If the driver provides list of documents by folder, would I be able to show them directly after saving them to meta tables in Appian business database in a grid, and open & edit a document using the link. Upon Save, my process model should write back the doc to Share Point for the same metadata parameters as different version. We are trying using Appian native a!shp.. but wanted to learn more about such kind of integration possibility.
  • 0
    Certified Lead Developer
    in reply to sudhakaraa0001
    SharePoint comes with a suite of services that you can call natively to update documents or lists. Depending on what version of SharePoint you are on you would need to use webservices or a RESTful approach.