Hello all, have a query. how to link website to the ERP? Website is in PHP & ERP is in MSSQL(Microsoft server).
Client has his ERP which is in MS SQL Server. & I want to link the Website( Designed in PHP ) with ERP system. Login from the website & then give access to the ERP system.
Please suggest me solution asap.
If you can share link of ERP you would want to use, it will be easy for experts to help you out. Most of the ERPs now a days have own APIs which lets your website access the data without being platform dependent.
Moreover it's important to understand for experts, if you would want to utilize that data anywhere in your PHP website or simply give access to users (Password Protected).
If it's only about giving access, iframe or redirecting users over ERP login is easiest way.
If you want a single sign-on, means user who logged in to your PHP site doesn't need to log-in again on ERP part, you need to have a common user table and that can be achieved using APIs.
Such nature problems/questions often comes when you have ecommerce or corporate website on PHP open source and ERP is on MS platform.
Hope this helps you.
Any ERP system developed would have an user interface to perform operations. The url (ex. - http://xyzERP.com/Login) of the ERP user interface can be linked to the website and most importantly, the ERP system has to be hosted online to be accessed from the website irrespective of the different databases.
Since your ERP is loaded with information that any hacker would love - I would recommend a VPN solution first and not what you are proposing.
I would doubt there are any boxed solutions. I have lots of questions about this: are the users internal or coming in from the Internet? Does your ERP have a web-browser UI? Does the ERP expose an API for authentication?
If you just want to view and not modify the data, ordinary SQL queries work from PHP. Lots of PHP frameworks have ready-made modules for handling different DB types.
Having two front-end systems modifying the data is fraught with problems. It might be best to hand users off between systems, or iframe the ERP content into the PHP system.
Often the issue is handing users between unlike systems. Sometimes you can just pass data in the browser between the systems and finesse the user experience so it appears seamless. It all depends on the details of what you're trying to achieve.
If I understand you correctly you have a client that has an ERP system using Microsoft SQL Server for its database.
You would need to determine whether or not the ERP system itself provides an API that allows you to access the data stored in the SQL server. It's generally not advisable to directly access the underlying datastore in this type of scenario.