SAP 6.0 to NAV 2017. Tips please

Olof

We have two companies merging one of which has SAP as its ERP. We want to move that company over to our NAV 2017 system. And I'm looking for tips on how to approach this. Both companies are quite small (10 users each).

Systems:
Company 1: SAP 6.0 EHP6 (7.31)
Company 2: NAV 2017

My questions:
1. Are there any handy documents or tools available?
Note, I came across this older thread, but as a simple end-user, I do not have access to the partnersource link. Nor do I know if it is still relevant for our SAP & NAV version:
https://forum.mibuso.com/discussion/24576/sap-b1-to-nav-mapping

2. Is it 'just' a matter of hiring a SAP specialist and a NAV specialist and put them together?

3. What preparation homework can the SAP company do to prepare for the data move?

Thanks in advance for any suggestions!
Olof

bilalrai

If the SAP gives you the facility to export data in excel then the best method to import data in NAV is through Rapid Start Services. Create packages, add tables, export the header files and then copy the cleaned/transformed data in them and import them in NAV.
Check this link too
https://msdn.microsoft.com/en-us/library/hh179428(v=nav.90).aspx

kennie

You might want to use the Theobald SSIS connector to get data from SAP. Generation of SSIS packages could be automated using BIML

bilalrai

If the SAP gives you the facility to export data in excel then the best method to import data in NAV is through Rapid Start Services. Create packages, add tables, export the header files and then copy the cleaned/transformed data in them and import them in NAV.
Check this link too
https://msdn.microsoft.com/en-us/library/hh179428(v=nav.90).aspx

Olof

Hello Bilalrai,
Thank you for taking the time to respond and your links. Sorry about this delayed response. The pre-merger negotiations took longer than expected.
We are now starting a pre-project checklist and projectplanning

bilalrai

No issue. Best of luck for your project @Olof

kennie

You might want to use the Theobald SSIS connector to get data from SAP. Generation of SSIS packages could be automated using BIML

Olof

Thanks Kennie, I will look into it!