Hi, How can I define a MySql "Remote Server" on Linux ? Can I define some proxy table to INSERT data on MySql server ? Thanks. |
Just as a quick start (I don't use MySQL, so I can't give an example): What SA version are you using? Starting with SA 11.0.0, MySQL is supported as a remote server (class "mysqlodbc"), so that should work. In older SA versions, you could use the generic remote server class "odbc". You might have a look at the online docs. I don't know if there are particular Linux issues here (you might need to define an ODBC data source), but otherwise, proxy tables are quite easy to use. Basically you have to do three steps:
Insert/update/delete through SA should be possible as long as you do not define the remote server as readonly and as the connected user has according table permissions. |
Welcome NCister, by the way:) - I just retagged the question as "proxy tables" seems to be the more common term:)