Skip to main content
New Participant
June 7, 2024
Solved

Way to connect to SAP DB

  • June 7, 2024
  • 9 replies
  • 0 views

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

Best answer by stefanhelzle0001

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.

9 replies

stefanhelzle0001
June 7, 2024

Did you consider to disable sync? Then your data would be fetched directly from SAP.

New Participant
June 10, 2024

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?

stefanhelzle0001
June 10, 2024

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