Group items tagged

These instructions assume that you have Infobright installed and running.   First and foremost, download Talend.  In this example, we will download Talend Open Source Data Integrator v5.0. (http://www.talend.com/download.php)  Once fully installed, download the Talend/Infobright Connector.  Ensure you download the right connector; instructions are on the download page (http://www.infobright.org/Downloads/Contributed-Software/) If you download Talend 4.0+, you’ll want the latest connector For older versions of Talend, you’ll want the 3.7 connector and lower. Once downloaded, perform the following actions: [For Windows] Copy the infobright_jni([_32|_64])bit.dll to C:\Windows\infobright_jni.dll Copy the zipped “tInfobrightOutput” directory to this directory: [Install Root of Talend] \plugins\org.talend.designer.components.localprovider_5.0.1.r74687\components\tInfobrightOutput Copy “infobright-core-3.4.jar” to [Install Root of Talend]\lib\java Running Talend in Windows If using Windows, run talend as Administrator.  If you don’t, you will see odd “Access Denied” or “Accesse Refuse” error messages when trying to use the connector.

You need to do some work on these instructions. Version 5 is not like version 4. You must run Talend 5 before the “lib\java\” folder appears.  Once it does appear, it no longer contains the .jar files like version 4; just a file “index.xml” that you have to edit to point to the infobright jar file in the components folder.

Queries time

InfoBright was fully 1 CPU bound during all queries.

The greatest benefit of columnar is to avoid disk I/O.  By choosing “select *”, you run the risk of losing that benefit. 

BI tools are here to stay, and they really help make visualization of analytics easy.  When working with Infobright, always take an extra second to review the generated queries.  The extra few seconds could mean seconds or minutes in saved query times.