Forum

[Lianamelissa]

Hi, I want to select some data from WX2 Database and put it in MYSQL DB. Is ODBC.ini configuration will work for the mysql database to connect to WX2 database?

Thanks.
Lianamelisa.

[markc]

This sounds more like a problem for a MySQL forum than a Kognitio one, as presumably MySQL has some standard way to pull data in from another ODBC DSN (if you were going the other way to pull data into Kognitio from an ODBC DSN, you would probably use the ODBC connector, which you can find in the Kognitio documentation).

I can see https://forums.mysql.com/read.php?104,627655,627655 has a similar question, so maybe review that thread, or find similar ones in other MySQL forums?

[mamoonmoulavi]

To access the data in Kognitio you could use the ODBC driver to retrieve it, or for better performance use the bulk unloader utilities to export it as CSV, which you could then load into MySQL.

If you were going the other way round, pulling data FROM MySQL TO Kognitio, you could bulk unload as CSV from MySQL then bulk load into Kognitio, or you could use the External Table functionality of version 8 to access MySQL tables on demand from Kognitio via an ODBC connector.