[Maria-discuss] New Question: newbie question
Hello, A new question has been asked in "MariaDB community" by lennartjohansson: -------------------------------- Hi all, I'm a newie to Mariadb but do have a question if a thing we need to do in a project is possible to do at all. We are working with a id-project where Sybase is feeding data into a ldap directory, now we need do to a upgrade witch means that the connector to sybase are lost. To get that to work again we need to have new views build in Sybase and since we dont own the Sybase database that is crazy expenciv. So we thought about using MariaDB as a middleware and store data from Sybase in it and use that instead as data source for our directory. So my question is if it's possible in MariaDB to run a query that reads data from a Sybase DB and store the result? And if so does anybody have any suggestions about best practice how to do that. /Lenanrt -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/newbie-question/
You will need to do from a client having such capability. The MySQL server (and any flavor of it) cannot connect to Sybase. With the possible exception that the MariaDB CONNECT storage engine can connect to your Sybase data after what you may find a way to copy data to MariaDB internal databases and tables. I don't know if CONNECT was ever tried with Sybase. There are several MySQL/MariaDB clients capable of importing data from other RDBMS (typically using ODBC to connect to the external data source) to MySQL/MariaDB. One such client is SQLyog (I mention this one because I work for the company "Webyog", who is"responsible" for SQLyog. The only requirement is a functional ODBC driver for your Sybase data source - I think this http://www.sybase.com/products/databasemanagement/advantagedatabaseserver/od... will do. But I don't know much about Sybase. There may be different drivers for different Sybase versions). -- Peter Laursen -- Webyog On Fri, Nov 7, 2014 at 4:40 PM, AskMonty KB <noreply@askmonty.org> wrote:
Hello,
A new question has been asked in "MariaDB community" by lennartjohansson: -------------------------------- Hi all, I'm a newie to Mariadb but do have a question if a thing we need to do in a project is possible to do at all. We are working with a id-project where Sybase is feeding data into a ldap directory, now we need do to a upgrade witch means that the connector to sybase are lost. To get that to work again we need to have new views build in Sybase and since we dont own the Sybase database that is crazy expenciv. So we thought about using MariaDB as a middleware and store data from Sybase in it and use that instead as data source for our directory. So my question is if it's possible in MariaDB to run a query that reads data from a Sybase DB and store the result? And if so does anybody have any suggestions about best practice how to do that.
/Lenanrt --------------------------------
To view or answer this question please visit: http://mariadb.com/kb/en/newbie-question/
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (2)
-
AskMonty KB -
Peter Laursen