Hi team,
Is there a way to access real-time information in SAP database like data link?
I know there are BAPI smart service and SAP GUI libraries, and cofiguring record type with BAPI can have a bunch of records.But I also know the record type can have data as of the timing of full sync, which takes place once a day not every 10 mins.
If we can configure the record type with jdbc instead of the smart service, I hope we can refer the latest data.But the problem is that SAP does not allow users to connect directly to its database with jdbc.
Is there a good way to fulfill our requirement?What I wonder is if we can connect to SAP BTP with jdbc, we might be able to see the real-time data via BTP.And the idea I came up with is if the record type can be refreshed every 10 mins, this also helps us.
I appreciate any suggestion.
Thank you in advance,Masaki
Discussion posts and replies are publicly visible
Did you consider to disable sync? Then your data would be fetched directly from SAP.
Hi Stefan,Thank you for your response.What do you mean by "disable sync"? Is it possible by uncheck Schedule full syncs?When it is disabled, does record type fetch data from the data source in real time?
Sure, and yes.
Data sync is relatively new to Appian and while it might become the default, for certain use cases, it is a good idea to disable it. An a constantly changing data source can be a good indication. This only works well when the data source can notify Appian about any updates.
https://docs.appian.com/suite/help/24.2/about-data-sync.html#when-to-enable-data-sync
https://docs.appian.com/suite/help/24.2/generate-web-api.html
To do so, I understand appian API needs to be called by the data source whenever there is an update.I also believe that ID needs to be passed as a parameter when called to update the corresponding record, and this update cannot be done for multiple records at the same time.To update multiple records, API need to be called for the number of updated records.
Is my understading correct?
I don't think it's realistic that SAP calls API whenever there is an update on data.
Is there any case that fetch data from SAP BTP?If yes, could you give me any information about how the intergration is achieved?
Yeah, sure, but did you consider just disabling sync?
Hi Stefan,
As I answered above, I think it will not work in our situation.So I'm wondering if there are any other options.
What I mean is to disable the whole sync feature, do not cache any of the data in Appian, und just query the data in real time.
Ok, understood.So what you mean is calling API on demand.
Yes. You can still do that through a record, but you would loose the advanced data fabric features. I am not sure whether that would be a problem.