We will going to use Appian to remediate one of application. We will need to fetch data from Appian db and load it into our in house database, In our existing set up, where Appian is not used , we are using informatica Power centre to fetch data from external vendor application via CData ODATA connector. Is there any way to do with Appian also?
Discussion posts and replies are publicly visible
If your data volume is small, you could just create a web API in Appian and expose the data in JSON format. If you need more, there is a way to directly connect to the Appian cloud database.
https://docs.appian.com/suite/help/24.1/Enhanced_Data_Pipeline_for_Appian_Cloud.html
thanks I will check. Meanwhile is there a way to do POC of this connectivity. Is there any credits available or appian enterprise edition freely available for practice.
Appian currently runs a beta program that gives you limit access to an Appian environment. Find it here: https://us.appian.community/
This does NOT include any direct access to the cloud database. But the API approach should work.
Keep in mind that you are not tied to use the Appian cloud database. You can just connect any other database, like your in-house one, to an Appian environment and then do whatever you need.