2
Is there any way to free access to reading a specific database table for a third party system?
For example, I have a table called "customers" and a competing system has an efficient ticket issuing feature that can take advantage of this data and needs to consult my database to stay up to date and offer the resource. That’s possible?
I would not like to pass the ftp data of the system, and with a limited access of that would be enough...
Webservice was creating exactly for this. Search on the theme and the ways to create one, no doubt is bsm better than free access to your db
– Renato Tavares
Since WS would not be considered, you could create a database, a user with read-only permissions and make a copy of the tables you want. I think there is a way to automate the copies of the respective tables. It would not be an ideal solution but it is a sufficient solution.
– Filipe Moraes
So I thought about webserver logic although I never applied it to any solution. One detail is that the third system will generate the boletos, but somehow I have to be able to print/view on my site/system, up to this point I see what I can do, create a view, assemble a layout. The problem is to query the data, access database etc. Do you have any reference for me to read about? Thank you!
– Leatar