HELP - Jobroller integration with SQL server third party app
I know that this issue falls outside the scope of support for the topic but I need some help. I have a third-party application in the intranet, RDMS is SQL Server. This database is updated daily with new jobs and I have to once a day publish these jobs on my jobroller website.
Because of security a shouldn't open SQL server (using web service) to the internet. I have to somehow access the jobroller MySQL database and automaticlly transfer these jobs.
Please, I need this very much. My ideas for now are linked servers on SQL server or webservices on wordpress side but I am not sure how to do that.
Thanks in advance.