I'm also interested if anyone has experience with this.
Did anybody ever figure this out?
Hi @Tariq Hussain,
Can you please help on the above or direct it to who can help?
Thanks & Best Regards,
Yasas
Hi @josbla & @Koos,
Technically, you both are able to access the databases hosted at IFS Cloud services, as your company has already had Site to Site VPN to IFS Cloud Services. This is the pre-requisite to enable you having a direct connection to IFS Database servers at IFS Cloud Services, which is private access (S2S VPN/ExpressRoute). Then you can have one specific user to retrieve data from IFS tables/views, because you are still using Apps10, even I suggest to use IFSINFO for this DWH integration user, to make it simpler for accesses. At IFS Cloud version, only IFSINFO database user will be available by standard for such DWH usage.
You can use this user at Azure Integration runtime, for example, that is used for Azure DWH.
Then, you can talk to Finance consultant to discuss the Information Sources, Dimensions or facts to make it as your IFS sources for your DWH, or you can create your own IAL if necessary to be aligned with your DWH.
Hope this gives a light.
/Togar
HI @josbla
We also use IFS Cloud and are looking for information on the IFS cloud data mart.
Have you set it up yet?
Thanks
Hi @jgiroud ,
we use IFS app10, and we use Gateway connection to Oracle database where we fetch data and publish it to workspace. The fetching is programmed to do up to 6-8 times per day depending on data set. From workspace we use Power BI to build any type of report we want.
Hope it helps.
Br,