Skip to main content

Hi all,

 

does anyone have experience on the process/architecture when building data warehouse in IFS full managed cloud service, where user doesn’t have access to database? We as client are trying to find the right approach with IFS team, but seems we can’t get to right people within IFS to answer us this. Only response we get is that we can’t get access to database but no clarity how or who should than push our data to us to put into data warehouse.

Thank you all for your input. 

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,