NAV Integration 2013 Slowness

Tharanga_Chandrasekara

Dear All,

One of my client want to integrate his sales system with Dynamics NAV 2013 R2. They have all the data in a SQL database and they want to transfer data batch wise (once a day) and this one particular batch contain around 5000 journal lines.

To do that I have created new tables depending on the integration types (Sale,Purchase) and pages and expose them as web-service. Integration is developed using .NET and i have pass the values to NAV tables (newly created) and from using a NAV code unit I am transferring the data to NAV General Journals. User will manually post the entries to the ledgers.

I have completed the development and now my problem is integration is working slowly and it is a big issue to my client. I have tried running this integration in Server itself and then it has no problems. but when running in the client it gets slow.

What are the other integration methods that can be used to integrate with NAV and are there any proper recommended methods.

Thanks
Regards,
TharangaC

ssingla

Following Rashed's post on replacing NAS with SQL jobs, I am currently using SQL CLR for transferring General Journal entries to NAV from SQL database. The link is
http://mibuso.com/blogs/ssingla/

However the experience with SQL 2008 with Visual Studio 2008 on NAV 2009 R2 was great and I am currently posting 80-100 sales journal transaction (with customer ledger entry application) per minute. The things changed when I deployed using Visual Studio 2010, SQL 2012 with NAV 2013 and the solution post only 10-15 transaction per minutes. There is no change in the code or method of deployment. I have not tested with Visual Studio 2012 but you may try.