Question on loading data from IFS Cloud to existing Data Warehouse

Hi!

The concept of Access Views has been implemented for supporting loading of data to Data Warehouses. There are many benefits compared with using application views in IFS Cloud.

If the standard Information Sources and the Access Views based on the Information Sources are missing some information I would create IAL’s to “fill the gap”. The Access Views and the IAL’s are both located in the IFSINFO schema.

Hi Stefan, 

I constantly read that IAL's will be deprecated in the future and that is is not recommended to create new ones in IFS Cloud. Are there alternatives to create views on IFS data (and where datwarehousing is a use case)

Hi!

The recommended standard way would be to create new Information Sources (and related views) as a standard modification. Then you can create Access Views based on the new Information Sources.

/Stefan

Hello, is there a “how to guide” for creating a new informations sources and access views? For example, we want to load Supplier_blanket to our data warehouse that is missing in the standard liberary?

Hi @NPGIFSJOMAII 

Creating Info Sources using IFS Developer studio - https://docs.ifs.com/techdocs/24r1/060_development/026_br_and_a/010_develop_is/

Creating Quick info sources using IFS Cloud application - https://docs.ifs.com/techdocs/24r1/050_reporting/500_information_sources/060_quick_info_source_drafts/

Access views - https://docs.ifs.com/techdocs/24r1/050_reporting/256_br_and_a/050_integrations/080_external_access/010_access_views/

Hope these will help you to get started

BR,

Subash