Epicor ERP Physcial server

Question

I am going to integration my Epicor system to wordpress site.

I mean I am going to integration database of Epicor to wordpress's database.

By the way, my Epicor system is located on physical server of my company. In this case, do i have to upload my local server to online server?

For get data from Epicor to wordpress, do I have to make online server of Epicor?

Let me know please. thank you

Answer 1

if one server is online and the other is offline yes you will need them both to be online servers if you require real time integration without manual procedures .

To make your company server online , you will need to get static public IP from your internet provider and configure it on your server to access it online.

What you need to do for uploading data to WordPress site by making connection to database from your WordPress website to your Epicor server .

and please adjust the question its very confusing but hopefully I answered what you need if I got you right

Answer 2

I'm going to assume your question is, "How do I get data from on-premise Epicor ERP for use in WordPress"?

You do not have to upload anything. Epicor has a very good API. One thing the comments here leave out, however, is that it's very dangerous to simply take your on-premise server and expose it to the internet. You should use SSL and a non-standard port, and protect yourself with a limited access scope via an API key.

So here are the steps (do everything in a DEV environment first obviously) and each one is a mini-project in its own right (for which Google is your friend).

1. Get your static IP for the location where your on-premise server lives;
2. Select a port to open (EG 8989) that is not standard;
3. Use router port forwarding to connect that WAN port to your Epicor AppServer;
4. Get an SSL certificate set up for connecting to your system from the WAN;
5. Create an integration user in Epicor (EG username WPConnect) and make this a basic authentication user;
6. Create an API key in Epicor that gives access only to the data you want to access in WordPress;
7. Test your connection using the integration user in the browser (Google "Accessing Epicor Rest API in Swagger") from a computer that is NOT on the same network as your server;
8. Make sure your Epicor AppServer is set up for Token authentication;
9. Use PostMan to figure out your REST API calls, starting with generating your token;
10. On the WordPress side work out your http calls to use the API