I have created a Data object based on External Data source. Created a report based on this. Now when I am updating the record in the database table, the updates are not getting updated in the report.
I searched in the forum and came across a very old post Refreshing BAM Report
in which it is mentioned that tables update will not get automatically reflected in the report.
Need to know that in 188.8.131.52 if there is any new feature which can help in this case.
What could be the best alternative solution in this case to get the report updated with real time updates in database table..
An External Data Source (EDS) is a connection to an external database. An EDS usually contains data that does not change very much or data that is too large to bring into the Oracle BAM Active Data Cache (ADC).
if we use EDS the data streaming very show.this will not support Active Data in BAM reports.
the Batter way use BAM Adapter in SOA stream like the process into BAM Data Objects and create reports that will give high performance in Active Data.
In Edit View of your report, click on Properties and then go to the Active Data tab. You should see some polling settings. Be sure it is set to polling mode and set the frequency of the polling. This should take care of it.
Does anyone know if alerts can be created on these external data sources. I am able to create a report by creating a external data source and linking it to an external database. I tried to create alerts on these data objects but they don't seem to be working.