Joinutility seperatorLogin utility separator Infobright.com
   
 
Command line client / SQL Query
Posted: 13 February 2013 02:26 PM   Ignore ]  
Newbie
Rank
Total Posts:  1
Joined  2013-02-13

Hi

I recently downloaded infobright and Tableau, i want to be able to transfer data from an existing database ( for example MySQL) and manage it in Tableau, can anyone explain how i can get my own databases in there? im working at root server, port 5029.
I also wondering if its possible to create tables/columns/dimensions through the command line, i managed to create a new database and its visible in Tableau but i cant seem to do anything with the database.

I hope you understand what im looking for here, as you might noticed i am a beginner in this area but i really want to( and have to) learn more smile

Thanks in advance

Best regards

Kurtan

Profile
 
Posted: 13 February 2013 02:52 PM   Ignore ]   [ # 1 ]  
Administrator
RankRankRank
Total Posts:  359
Joined  2012-01-18

My suggestion would be to create the tables you want that are in your current Mysql database, then do a SELECT INTO outfile and then a LOAD DATA to load the data into the Infobright tables.  This works efficiently.

You may want to be aware of the reject file settings
http://www.infobright.org/wiki/Reject_File/

Migrating data is a webinar that we do alot of, you may also want to look into the next one and find out what the best practices are.

Go to http://www.infobright.com/

And look for Events.

Signature 

Craig Trombly
Community Manager
60 Hazelwood Dr Champaign,  IL 61820
(JavaScript must be enabled to view this email address)

Profile