maria-discuss team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

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/odbc-driver
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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>