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.
Best answer by Togar Siahaan
Hi
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
+30Hi
Can you please help on the above or direct it to who can help?
Thanks & Best Regards,
Yasas
+1Hi
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
+2HI
We also use IFS Cloud and are looking for information on the IFS cloud data mart.
Have you set it up yet?
Thanks
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
