July 12, 2013 at 2:54 pm
I am playing around with Infobright but am having some problems with populating it using SSIS.
Infobright uses the MySQL 3.5.1 ODBC driver and to external applications appears as if it is MySQL.
Using the ADO.NET Destination I can load data from SQL Server into Infobright provided the population mode is set to row-by-row rather than batch.
Populating a column store database row by row is s...l...o...w.
Has anyone else tried populating Infobright with SSIS and if so what did you do to get it to work in an acceptable manner?
August 27, 2013 at 4:49 pm
I don't think you'll have much success with that approach. From what I remember you need to use the InfoBright file loader (ASCII files, or binary files if you have InfoBright Enterprise) to get performant data loads.
You might still be able to automate it with SSIS though, perhaps using SSIS to export data to a file and then run a script to load the data via InfoBright loader using the mysql command line?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply