-
Lianamelissa
- Single Poster
- Offline
-
- Posts: 1
- Joined: Wed Feb 28, 2018 8:49 am
-
markc
- Contributor
- Offline
-
- Posts: 386
- Joined: Thu May 23, 2013 4:48 pm
-
mamoonmoulavi
- Single Poster
- Offline
-
- Posts: 1
- Joined: Mon Aug 12, 2019 4:34 am
General discussion on using the Kognitio Analytical Platform.
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.
Thanks.
Lianamelisa.
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?
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?
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.
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.
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest