SAP 6.0 to NAV 2017. Tips please
Olof
Member Posts: 27
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
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
0
Best Answers
-
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).aspx5 -
You might want to use the Theobald SSIS connector to get data from SAP. Generation of SSIS packages could be automated using BIML
5
Answers
-
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).aspx5 -
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
0 -
You might want to use the Theobald SSIS connector to get data from SAP. Generation of SSIS packages could be automated using BIML
5 -
Thanks Kennie, I will look into it!0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 328 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions