Moving table data from one PDI to another PDI

[Kishore32]

Hello,

I'm having an Application with 50+ tables in 2 different PDI's. Now i wanted to move the all tables data from 1 instance to another instance. Can it be done in one shot instead of doing export xml and import xml for every individual table?

Please let me know if you need more detail on this question.

Thank you

[david_ewen]

Hi @Jeremy Duncan -Do you know if the Multi-Table export tool with filter is still available?

[Kishore32]

Thanks @Chuck Tomasi and @Jeremy Duncan for response.

I imported and committed Multi-Table export tool update set xml to my PDI, after committing and i clicked on it and i'm seeing below screen shot. Is this tool doesn't support New York version as my instance is New York version?

 

I tried second tool and it is imported successfully if you see above screen shot.

[Chuck Tomasi]

The first one "multiple table exporter" worked best for me and allowed for filtering whereas the one from 2014 wasn't quite as flexible.

I tested multiple table exporter on an Orlando instance so I am pretty confident that it works on New York as well.

[Jeremy Duncan]

Your UI looks much different than mine, maybe it's been updated since I last grabbed it :).

You start with "Export Configurations" to define the tables with the appropriate filtered data. Then, once configured, you should be able to launch the XML dump directly from the export configuration. 

The main two things you'll use are Export Configuration and Table Exports. Should work OOB and i've tested in New York. 

[Kishore32]

@Chuck Tomasi @Jeremy Duncan 

I exported the tables and imported those in destination instance but after importing i'm not seeing records added to 'System Update Sets -> Retrieved Update Sets'. Is there anywhere i've to check?

Thanks