0

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!

Arun Vinoth-Precog Tech - MVP
  • 22,364
  • 14
  • 59
  • 168
Antonache Radu
  • 29
  • 2
  • 6

2 Answers2

0

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.

Arun Vinoth-Precog Tech - MVP
  • 22,364
  • 14
  • 59
  • 168
0

XrmToolbox Field Creator tool is a life savior. It's free and does the job.

Adam Dave
  • 1
  • Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Apr 20 '23 at 04:09