Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Loading Infobright with SSIS in SQL Server 2012 Expand / Collapse
Author
Message
Posted Friday, July 12, 2013 2:54 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:56 PM
Points: 2,915, Visits: 1,848
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?


LinkedIn Profile
Newbie on www.simple-talk.com
Post #1473239
Posted Tuesday, August 27, 2013 4:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 2:32 PM
Points: 4, Visits: 53
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?
Post #1488987
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse