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.
I want view as well as modify the data of ERP system which is in Microsoft SQL Server. Just want to access it through web browser after website login(PHP website & MySQL server for DB)....
Would there be issue about different DB technologies.
You're not getting more specific answers because the unknowns are too huge.
The people who said 'look for an API' were right because an API provided by the ERP developers would make it easier to interact in a safe way with the data. If you want to directly read/write data from another system, you need to rebuild the business logic that is in the ERP's code using PHP. That's probably a major project.
But the approaches I mention above sometimes turn out to work... Assuming the ERP has a web interface, their HTML (and JavaScript) cause things to happen on the server. You can pull that HTML (form elements and form actions and maybe some AJAX) into a template served up by PHP, or just have the PHP serve up an iFrame to the ERP. There may be restrictions requesting stuff between domains and server-level permissions limiting queries from certain IP addresses. Any of these hopefully leaves the business rules of the ERP system untouched so your data, hopefully, remains consistent.
If you just need people to log into the ERP, can you get the login form HTML including the form action into the page served by PHP? Again, assuming the ERP has an HTML front-end.
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.
Sir, client need login credentials on website. When login to the website login then they need access to the ERP system. They don't want direct access. I am stuck here only, how to access ERP MSSQL via PHP website.
You would need to review the documentation for the specific ERP system to determine what type of integration it provides for external applications.
Users are Internal employees.
ERP has GUI, I need to give access to that GUI after login to the website via browser. So I need to access GUI from browser.
So is it possible?
ERP database is Microsoft SQL server, and website database is MySQL.
I just want to give access to the ERP via website login through browser. All the other operation would be done in the ERP GUI only in the MSSQL DB.
So would it be issue about different databases.???? pls clear my this query sir asap.