We are using FDM 18.104.22.168.We have a requirement where in we need to connect to SQL server database to get source files and load thm to HFM.
I hv seen that we can use Import Integration Script to acheive this. But I hv also read that we need to use ERP Integration adapter to connect to database and load data files. Can any one help me in understanding whether using Import Integration script is enough or we need to hv ERPI installed to acheive this.
You don not need ERPI to do what you are trying to achieve. A simple integration script in FDM will suffice. You would only require ERPI if you were looking to drill back to the data in the SQL Server tables seamlessly from within FDM.