Skip to main content
Question

Preferred ETL Tool for IFS 22R2


Forum|alt.badge.img+2

Hello, can someone suggest few ETL tools which would help to fetch data out from IFS Cloud 22R2.

2 replies

bpfrenchak
Do Gooder (Customer)
Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • 16 replies
  • March 29, 2023

If you have access to connect to the Oracle database then could use any ETL tool that can connect to it, just the same as you would in an on-prem environment. Could use SSIS if building SQL Server DW on prem, or Azure Synapse/Data Factory, etc. if you want to do it in the cloud.


eqbstal
Superhero (Partner)
Forum|alt.badge.img+21
  • Superhero (Partner)
  • 677 replies
  • June 19, 2024

@GOGMANIKM Most likely you already got the answer elsewhere, you will, standard IFS Cloud setting have only read access to the database of IFS. Hence only their tools can be used. So this leaves you with:

  1. Manual entry of data
  2. Use Data Migration (Excel or flat file loading and processing)
  3. Data Migration Manager (the most complex to prepare of these alternatives according to me)

Hope there is someone who can shed some more light on this.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings