dynamics-crmazure-data-factorydynamics-365import-csv

Import CSV file into multiple tables in D365


I'm searching for a no-code solution to import data from a single CSV file into multiple tables in D365, in a single data import process. OOB Import Data in D365 can only import data into a single table, not in multiple table, in one shot. Do you think Azure Data Factory can be used for this task?

What other alternatives can I take, please?

Thanks in advance for your time and knowledge!


Solution

  • You can use ADF pipelines (Dataflow) with multiple sources and load data into Dynamics. Read more and refer this

    Alternatives are configuration migration utility and Data import using zip file

    All these are not full fledged ETL tools, so hiccups are possible, even roadblocks considering your no code requirement.

    You can try SSIS+Kingswaysoft or Scribe as an option considering Import wizard is not getting much attention in the Dataverse product.