Is the accounting system local to the website?

If so what DB?

The accounting system is on a local server at the client site and HCC is hosted at PowerDNN. The accounting DB is SQL Server 2012.

Ok, that's going to be a doozy. Here is what I would do.

Moving that data over http might be slower than accessing directly from the web server.

I dont know if power dnn lets you create multiple DBs. If it doesnt I would probably just create a table in the DNN database. Then push to the new DB or table with of your data from the on-prem server.

That can be just a destop console app that you are probably familiar with, just straight sql calls from one to the other. After data completes sync, make an POST/GET to a WebAPI service on your DNN instance which will trigger reading from the hosted DB/Table and modifying the HCC records via server side code.

You following?

I take that back, I think we can make it even easier. If you push that data to the new db/table you can just read from that table during your checkout process or at that time they add to the cart to check stock.

https://hotcakescommerce....-Integration-Project

https://hotcakescommerce....959-Extension-Points

[quote=Adrian;395]Ok, that's going to be a doozy. Here is what I would do.

Moving that data over http might be slower than accessing directly from the web server.

I dont know if power dnn lets you create multiple DBs. If it doesnt I would probably just create a table in the DNN database. Then push to the new DB or table with of your data from the on-prem server.

That can be just a destop console app that you are probably familiar with, just straight sql calls from one to the other. After data completes sync, make an POST/GET to a WebAPI service on your DNN instance which will trigger reading from the hosted DB/Table and modifying the HCC records via server side code.

You following?

[/quote]
Adrian,

I guess I am not following. Are you saying that I cannot call the Hotcakes API in any way unless I am running the program (C# or JavaScript) on the server where Hotcakes is hosted? I follow your thoughts about making copies of the needed data on the web site but I don't follow the need to do it.
I can call thousands of API hosts all over the web without running the program on the hosting site. Does this not work that way? Thanks for your help!
Also, I will review the links you sent in the other posting first thing in the morning and see if that helps me understand.