Creating Data Service to Fetch the data from external database

Help Data Service
,
4

Hi Harish,

If you simply want to show data in a table in your App, you don’t actually need to use Data Service.

You can use our Database Activities Pack to connect to your Oracle Database and then set the output DataTable of your Query as an OutArgument for your process, which can then be consumed in your App.

Data Service allows you to cache data from external sources or store internal data. If you plan to use Data Service to cache data, it will be a 2 step process -

  1. Step 1 - Write a process using the database activities that syncs data between your Oracle database and the entities you create in Data Service.
  2. Step 2 - Write and import processes that will take data from Data Service and pass it to Apps as an OutArgument.

Direct integration between Apps and Data Service is not available yet and Data Service also doesn’t have the ability to directly sync data from external sources.