Forum

General discussion on using the Kognitio Analytical Platform.
Single Poster
Offline
User avatar
Posts: 1
Joined: Wed Feb 28, 2018 8:49 am

How to connected the kognitio database from mysql

by Lianamelissa » Sat Mar 10, 2018 9:50 am

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.
Reply with quote Top
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: How to connected the kognitio database from mysql

by markc » Tue Mar 20, 2018 9:46 am

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?
Reply with quote Top
Single Poster
Offline
User avatar
Posts: 1
Joined: Mon Aug 12, 2019 4:34 am

Re: How to connected the kognitio database from mysql

by mamoonmoulavi » Thu Aug 29, 2019 3:52 am

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.
Reply with quote Top

Who is online

Users browsing this forum: No registered users and 0 guests

cron