Hi.

We have a customer which requests to extract data from IFS Cloud production database to consolidate in a data warehouse. For this task, they plan to use Fivetran SaaS. The final purpose of these is run massive data analysis.

The customer is Cloud-residency so I wonder what options can we offer them to extract data in a efficient manner.

Fivetran has several ways to interact with Oracle databases:

Oracle data movement | Fivetran

Does anyone have done something like this before? As far as I’ve been informed, Fivetran uses Oracle log files to detect changes and do incremental data updates. As far as I understand, this option is not possible at all on Cloud-residency installation as host access is not provided.

Another option is to use SQLNet and a user to query the tables. This could be done with the IFSINFO user but it requires some network configuration to allow it. Is this correct? Is this site to site connection possible between Azure IFS Cloud infrastructure and the SaaS provider?

Thank you much for the help.
Best regards.
Gonzalo.