How to Import XML files using data source from one instance to other

[deepum]

Hello All,

We are in the process of migrating the data from one instance to another, which includes more than 500 xml files. 

How can we achieve this ?Please provide any suggestions.

[Ankur Bawiskar]

@deepum 

you can create XML based data source

check these links

Create an XML data source to another instance 

XML File Import - Data Source Issue in defining the XPath 

XML Data Source to pull records from another instance issues 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[deepum]

Hello @Ankur Bawiskar ,

Thank you for the response. The links helps.

But we do have many tables, so each data source has a field "Xpath for each row" we should provide source table  name, which is not feasible to create so many data sources. Can you please tell me do we deal that?

[Ankur Bawiskar]

@deepum 

If you want to stick to out of the box then you should do it individually for each table.

Inform the custom this is the limitation.

you can come up with some custom solution but not sure how much efforts it will take and how much testing efforts will be involved.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Jaspal Singh]

Hi,

Is the target instance a fresh or vanilla instance or not in use? If so, why not clone.

Else, looking at the comments things will have to be directed to some other way.